|
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=159894
) 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=159893
) 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=159287
) as subquery
Greenpeace UK
Greenpeace campaigns independently and globally to halt environmental abuse and promote solutions.
Main Address
Canonbury Villas
London
N1 2PN
Main Telephone
00 44 20 7865 8100
Joined OneWorld
19.01.2006
Features
18.04.2008
Would you care more about climate change if you lived in a mud hut? This is what Archbishop Desmond Tutu is asking the leaders of the most polluting economies.
Story link
18.04.2008
Would you care more about climate change if you lived in a mud hut? This is what Archbishop Desmond Tutu is asking the leaders of the most polluting economies.
Story link
01.04.2008
UK energy minister John Hutton 'has been caught trying to sabotage the EU renewable energy targets'.
Story link
Related topics/regions:
[United Kingdom]
|
|
|
|
