|
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=114583
) 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=91781
) 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=31320
) as subquery
Television Trust for the Environment
An independent, non-profit organisation, TVE's mission is to act as a catalyst for the production and distribution of films on environment, development, health and human rights issues.
Main Address
21 Elizabeth Street
London SW1W 9RP
Main Telephone
020 7901 8848
Joined OneWorld
26.09.2006
Features
04.07.2005
Ordinary Africans send their messages to the G8 leaders in a series of eight short films by TVE, on Channel 4, 4-8 July at 7.55pm.
Story link
13.08.2004
While North America and Europe fight over Kyoto, Costa Rica shows the world how things should be done. In the capital San Jose, citizens are already paying a 5% carbon tax which is being used to plant trees and protect forests.
Watch this video clip from OneWorld TV and TVE
Related topics/regions:
[Costa Rica]
28.11.2001
A new multimedia initiative on the impact of globalisation provides political analysis and a chance for poor people around the world to tell their stories and discuss what they think the world community should be doing to tackle trade, social justice, work, health, land, debt, housing and conflict.
Story link
Related topics/regions:
[South Africa]
|
|
|
|
