|
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=81508
) 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=79396
) 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=74377
) as subquery
Earth Island Institute
Develops and supports projects that use education and activism to counteract environmental threats. Issues: sustainable development; biodiversity; restoration; wildlife habitat.
Main Address
300 Broadway, Suite 28
San Francisco 94133-3312
Main Telephone
(415) 788-3666
Joined OneWorld
12.08.1998
Features
15.03.2004
History is littered with the ghosts of many cultures, civilizations, and empires that extinguished themselves through lack of foresight and unsustainable lifestyles and policies. If leaders and ordinary people continue on the current path of denial and short-sightedness regarding the environment, our own civilization will likely count among them, writes Vinit Allen of the Sustainable World Coalition.
Story link
17.02.2004
Numerose organizzazioni ambientaliste lanciano un appello per porre fine al progetto estrattivo della Shell e ExxonMobil vicino all'isola di Sakhalin in Russia che, oltre a causare gravi danni ambientali, minaccia la sopravvivenza della balena grigia. La campagna fa parte della settimana di sensibilizzazione sul problema dell'estinzione di balene e altri cetacei.
Story link
Related topics/regions:
[Russian Federation]
Image: Immagine della Campagna - da Pacific Environment
03.12.2003
AIDS has killed millions of farmers in sub-Saharan Africa, compromising the nutrition and thus accelerating the death of millions more AIDS victims, resulting in further depletion of the agricultural sector. The Global Service Corps is working to break this vicious cycle by introducing better agricultural techniques and educating locals about HIV.
Story link
Related topics/regions:
[Tanzania]
|
|
|
|
