|
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=132078
) 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=131522
) 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=131159
) as subquery
People & the Planet
A global gateway into the inter-related issues of population, poverty, health, consumption and the environment developed by Planet 21, formerly publisher of People & the Planet magazine.
Main Address
60 Twisden Road
London
NW5 1DN
United Kingdom
Main Telephone
+44 (0)20 7485 3136
Joined OneWorld
10.10.2005
Features
04.05.2006
Twenty years after Sweden alerted the world to the meltdown at Chernobyl, it aims to phase out nuclear power and end dependency on fossil fuels, putting the country in the vanguard of green energy policy.
Story link
Related topics/regions:
[Sweden]
25.04.2006
Climate change and environmental degradation may lie behind a sharp rise in the number of natural disasters, according to a new World Bank report.
Story link
19.04.2006
Canada's new Conservative government is to make deep cuts in spending to combat global warming in order to fund tax cuts, according to cabinet documents obtained by the Canadian media.
Story link
Related topics/regions:
[Canada]
|
|
|
|
