|
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=119763
) 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=119158
) 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=117695
) as subquery
BushGreenwatch.org
BushGreenwatch provides accurate and timely information on the Bush Administration's assault on our environment and public health. BushGreenwatch is a project of Environmental Media Services, a nonprofit communications clearinghouse, with support from MoveOn.org, the online advocacy group.
Main Address
1320 18th St, NW
Washington, DC 20036
Main Telephone
2024636670
Joined OneWorld
25.02.2004
Features
03.10.2005
The Endangered Species Act has saved such species as the Florida manatee and the bald eagle, but a new law--called "reform" by its sponsors--would cripple federal efforts to protect animals and plants, say groups across the entire spectrum of the enviornmental movement.
Story link
Related topics/regions:
[United States]
Image: The Endangered Blue Whale © Pieter Lagendyk / WWF
20.09.2005
The U.S. Environmental Protection Agency is failing to protect relief workers and others in the Gulf Coast, report government watchdogs, who say the agency does not appear to be testing for chemicals related to the petrochemical and oil industries, and the information it does have has not been made readily available.
Story link
Related topics/regions:
[United States]
25.08.2005
U.S. environmentalists criticized a Bush administration proposal to raise fuel efficiency of light trucks by replacing current standards with a fleet-wide average standard, saying the proposed changes will do nothing to help American motorists at the pump, or reduce America's dependence on imported oil.
Story link
Related topics/regions:
[United States]
|
|
|
|
