|
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=88540
) 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=88475
) 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=88297
) 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=88255
) 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=88215
) as subquery
Greenpeace UK
<< Back to organisation profile
Features
21.06.2004
Greenpeace activists have intercepted a shipment of GM maize destined for the dairy farms supplying milk to Britain's biggest supermarkets.
Story link
Related topics/regions:
[United Kingdom]
18.06.2004
The company that has done more than any other to keep the US hooked on oil is Esso (known as ExxonMobil in the USA). This addiction is causing global warming.
Story link
16.06.2004
Greenpeace has challenged lorry drivers protesting in Edinburgh about fuel price rises by sending vans emblazoned with the message "Global Warming Kills - Keep the Fuel Tax" to join their convoy.
Story link
Related topics/regions:
[United Kingdom]
Image: Climate Change - the real cost of fuel
15.06.2004
Climate change is a far bigger threat than global terrorism, according to Tony Blair's chief scientific advisor, Sir David King.
Story link
15.06.2004
In a victory for environmental campaigners, electronics giant Samsung is to stop using dangerous toxic chemicals in their TVs and mobile phones. The move follows discussions with Greenpeace, which is concerned that brominated flame retardants are linked to liver, kidney and testicular damage and to cancer.
Story link
Related topics/regions:
[United Kingdom]
<< Previous
| 1-10
| 11-20
| < 21 >
| 22
| 23
| 24
| 25
| 26
| 27
| 28
| 29
| 30
| 31-40
| 41
| Next >>
|
|
|
|
