|
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 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=159149
) 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=159105
) as subquery
Greenpeace UK
<< Back to organisation profile
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]
26.03.2008
British and French leaders Gordon Brown and Nicholas Sarkozy will this week sign up to an entente atomique and herald a new era of cross-Channel cooperation.
Story link
Related topics/regions:
[United Kingdom]
[France]
Image: Sizewell nuclear power station, operated by British Energy © Greenpeace
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41
| Next >>
|
|
|
|
