|
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=155078
) 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=154908
) 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=120271
) as subquery
United Nations University Institute of Advanced Studies (UNU-IAS)
As part of the United Nations University’s (UNU) network of research and training centers, UNU-IAS’ mission is “advancing knowledge and promoting learning for policy-making to meet the challenges of sustainable development”. The Institute is committed to contributing creative solutions to key emerging issues of global concern, particularly those on the UN agenda and the international community.
Main Address
6F, International Organizations Center, Pacifico-Yokohama
1-1-1 Minato Mirai
Nishi-ku, Yokohama 220-0012
Telephone numbers
No telephones
Joined OneWorld
05.10.2001
Features
15.11.2007
Only about 25 per cent of Europe’s medium-sized household appliances and 40 per cent of larger appliances are collected for salvage and recycling, according to a new study. Small appliances are close to zero percent collection.
Story link
Related topics/regions:
[Europe]
11.11.2007
The world community quickly needs to outlaw reproductive cloning or prepare to protect the rights of cloned individuals from potential abuse, prejudice and discrimination, according to study by the United Nations University’s Institute of Advanced Studies.
Story link
11.10.2005
Within five years the world will need to cope with up to 50 million refugees escaping the effects of creeping environmental deterioration, United Nations University experts warn today.
Story link
Image: 'Halt climate chaos' protest in London © Peter Armstrong
|
|
|
|
