|
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 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=158017
) 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=157612
) as subquery
Greenpeace UK
<< Back to organisation profile
Features
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]
20.02.2008
With just a few days to go until the consultation process ends, London mayor Ken Livingstone is keeping up the pressure on the government to abandon plans to build a third runway at Heathrow airport.
Story link
Related topics/regions:
[United Kingdom]
09.02.2008
Greenpeace has launched an interactive virtual city showcasing how towns and cities across the UK are fighting climate change and enjoying a cleaner and more secure energy future - without relying on new coal or nuclear power stations.
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 >>
|
|
|
|
