|
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=160642
) 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=160237
) 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=159879
) as subquery
Pesticide Action Network North America (PANNA)
Works to replace pesticides and industrial agriculture with just, ecologically sound alternatives worldwide.
Main Address
49 Powell Street, Suite 500
San Francisco, CA 94102
Main Telephone
4159811771
Joined OneWorld
18.06.2003
Features
22.05.2008
The Union Carbide pesticide plant in Bhopal, India exploded in 1984, but people are still dying from the toxic gases the explosion emitted. Here, anti-pesticide advocates keep readers updated on the Bhopal survivors' struggle for justice.
Story link
Related topics/regions:
[India]
29.04.2008
In the wake of World Malaria Day, an anti-pesticide advocacy organization discusses the danger of spraying DDT to kill mosquitoes carrying the disease and promotes malaria prevention alternatives.
Story link
Related topics/regions:
[Mexico]
Image: Malaria sign, Kenya. © Peter Armstrong
Related links
17.04.2008
Scientists, food activists, and corporate and government representatives agreed last week on the necessity of an agricultural shift to small-scale, sustainable practices to meet global food, development, and environmental crises.
Story link
|
|
|
|
