|
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=160414
) 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=160155
) 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=160154
) as subquery
International Institute for Environment and Development
IIED is an independent, non-profit organisation with a mission to promote sustainable patterns of world development through collaborative research, policy studies, consensus building and public information.
Main Address
3 Endsleigh Street
London
WC1H 0DD
External phone number
44 (0)207 388 2117
Main Telephone
44 (0)207 388 2117
Joined OneWorld
01.01.1997
Features
06.05.2008
With food hitting the headlines like never before, the International Institute for Environment and Development has launched a web-based publication that describes how to rethink food production and distribution for environmental and social gain.
Story link
Image: Cooperative garden in Caracas © FAO © Food and Agriculture Organization of the United Nations
28.04.2008
The significant shifts driven by climate change in the polar regions present new opportunities and pressures for development. These are challenges which demand holistic, integrated responses (PDF briefing).
Story link
Image: Offshore oil and gas exploration are likely to increase © Global Witness |
|
|
|
