|
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=30660
) 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=30663
) 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=30664
) 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=18179
) 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=31407
) as subquery
Greenpeace UK
<< Back to organisation profile
Features
15.04.2002
Greenpeace climbers boarded and chained themselves to a ship in the Thames estuary on Monday to prevent the unloading of wood from a threatened Cameroonian rainforest.
Story link
Related topics/regions:
[Cameroon]
[United Kingdom]
11.04.2002
After Prime Minister Tony Blair dismissed a Greenpeace Cabinet Office invasion as misconceived, the environmental group re-asserted that wood used in the office's refurbishment comes from the destruction of African rainforests.
Story link
Related topics/regions:
[United Kingdom]
10.04.2002
Activists entered the Cabinet Office in Whitehall on Wednesday morning, declaring it an "ancient forest crime scene" and revealing the government was about to install hundreds of new doors and windows made of wood from Africa's last rainforests.
Story link
Related topics/regions:
[United Kingdom]
Image: Tony Blair's green credentials © World Wide Fund for Nature UK
25.03.2002
The historic declaration by North Sea Ministers, including UK Environment Minister Michael Meacher, to promote renewable energy in the North Sea is undermined by the continued support of the UK and France to the polluting nuclear industry, warns Greenpeace.
Story link
22.03.2002
The UK could be a rubbish-free zone according to a revolutionary new report published today. 'Zero Waste' by leading waste expert Robin Murray, explains how Britain could maximise recycling levels, change product design to eliminate waste and find innovative new uses for the rubbish we generate.
Story link
Related topics/regions:
[United Kingdom]
<< Previous
| 1-10
| 11-20
| 21-30
| < 31 >
| 32
| 33
| 34
| 35
| 36
| 37
| 38
| 39
| 40
| 41
| Next >>
|
|
|
|
