|
select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=157522
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=157520
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=157548
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=157441
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=157439
) as subquery
Greenpeace UK
<< Back to organisation profile
Features
07.02.2008
With soaring oil prices, companies including BP are looking to cash in on Alberta's tar sands.
Story link
07.02.2008
With soaring oil prices, companies including BP are looking to cash in on Alberta's tar sands.
Story link
06.02.2008
Greenpeace barricaded entrances to Lord's cricket ground this morning where UK Energy Minister Malcolm Wicks was due to deliver the opening speech for a major coal industry event.
Story link
Related topics/regions:
[United Kingdom]
04.02.2008
Is Britain to have a renewables revolution, or a renaissance for the most polluting fuel there is? Greenpeace finds out what's going on behind the scenes.
Story link
Image: More pollution; no carbon capture
04.02.2008
Is Britain to have a renewables revolution, or a renaissance for the most polluting fuel there is? Greenpeace finds out what's going on behind the scenes.
Story link
Related topics/regions:
[United Kingdom]
Image: More pollution; no carbon capture
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41
| Next >>
|
|
|
|
