|
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 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=158428
) 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=158311
) 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=158209
) as subquery
Greenpeace UK
<< Back to organisation profile
Features
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
03.03.2008
The scale of public protest against an additional runway at Britain's premier airport is causing concern at the highest levels of government, says Greenpeace.
Story link
Related topics/regions:
[United Kingdom]
28.02.2008
Today, Plane Stupid campaigners scaled the Houses of Parliament to protest at the collusion between government and the aviation industry.
Story link
Related topics/regions:
[United Kingdom]
25.02.2008
Four Greenpeace activists climbed onto a plane on the tarmac at Heathrow this morning to wrap a climate change banner around the tailfin.
+ Say No to Heathrow expansion this evening: see OneWorld's Events page
Story link
Related topics/regions:
[United Kingdom]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41
| Next >>
|
|
|
|
