|
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=158655
) 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=152570
) 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=146235
) 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=145492
) 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=144187
) as subquery
Pesticide Action Network North America (PANNA)
<< Back to organisation profile
Features
10.03.2008
Anti-pesticide activists are asking for support in their efforts to secure a U.S. Food and Drug Administration ban on lindane, a toxic, bioaccumulative pesticide still allowed in shampoos and lotions used on children.
Story link
Related topics/regions:
[United States]
24.08.2007
As the U.S. environmental agency reviews pesticides for re-registration, an anti-pesticide advocacy group is leading a campaign to demand the highest safety precautions for fumigant pesticides, which can cause birth defects, cancer, Parkinson's disease, and acute poisonings.
Story link
Related topics/regions:
[United States]
Related links
16.02.2007
A Senate committee has begun hearings into allegations of collusion between industry and political appointees to roll back health and environmental protections in the United States.
Story link
Related topics/regions:
[United States]
26.01.2007
Colombia has resumed spraying to destroy coca plants allegedly grown in the region that borders Ecuador. But the U.S.-funded operation seems to be causing a lot of collateral damage.
Story link
Related topics/regions:
[Ecuador]
[Colombia]
22.12.2006
The European Union took historic action last week to strengthen its laws on chemicals; health advocates hope the precedent will be followed in the United States.
Story link
Related topics/regions:
[Europe]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-12
| Next >>
|
|
|
|
