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=18232 ) 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=31529 ) 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=31708 ) 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=39682 ) 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=39709 ) as subquery

Television Trust for the Environment

<< Back to organisation profile

Features

New strategy to help save ozone layer looking for input

20.11.2001 TVE, the non-profit media organisation, has been commissioned by the UN Environment Programme to develop a new strategy, to be presented to the world's governments, that will help save the ozone layer. TVE wants this to be an action-oriented strategy and is eager to hear from as many organisations and professionals as possible by November 30.

Story link
Related topics/regions: [Climate change]

Fuel of the future?

06.11.2001 Renewable and emission-free, hydrogen is being hailed as the fuel of the future. This Earth Report travels to Iceland and California to look at hydrogen schemes being put into reality. Could hydrogen be the key to unlock the world from its dependency on oil?

Story link
Related topics/regions: [Energy] [Transport]

Food works

06.11.2001 Multi-media information on what entrepreneurs and individuals around the world are doing.

Story link
Related topics/regions: [Food]

Chinese City Overcomes Pollution, Poverty

29.10.2001 China is undergoing extremely rapid urbanization; 12 million people each year leave the countryside for cities. This City Life program tells the story of how one provincial capital--Chengdu, in South West China--has reversed appalling environmental pollution and improved the lives of some of its poorest inhabitants.

Story link
Related topics/regions: [China] [Cities] [Poverty] [Environment]

City Life in Hanoi

10.09.2001 This City Life web documentary explores Hanoi, Vietnam, where urban growth has been rapid and unplanned, and traditional lifestyles are threatened.

Story link
Related topics/regions: [Vietnam] [Development] [Cities] [Culture]

<< Previous | 1 | 2 | 3 | 4 | 5 | Next >>