|
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=118114
) 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=113206
) 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=111959
) as subquery
SaveOurEnvironment.org
A collaborative effort of the nation's most influential environmental advocacy organizations harnessing the power of the internet to increase public awareness and activism on today's most important environmental issues.
Main Address
1130 17th St. NW
DC, DC 20036
Main Telephone
(202)772-0299
Joined OneWorld
17.03.2001
Features
01.09.2005
This September, the U.S. Congress will vote on a bill that includes oil drilling in the Arctic National Wildlife Refuge. Save our Environment asks you to send a letter to Congress, or join thousands of Americans from across the country for Arctic Refuge Action Day on September 20 in Washington DC, and help keep the unspoiled refuge from turning into an industrial oil field.
Story link
Related topics/regions:
[United States]
14.06.2005
The Energy Bill being debated by the U.S. Senate does not adequately address foreign oil dependence, high gas prices, or the exploitation of public lands for oil exploration, says the SaveOurEnvironment coalition, urging citizens to oppose the measure and make America greener and cleaner.
Story link
Related topics/regions:
[United States]
24.05.2005
"ExxonMobil's unwillingness to build a low-carbon future is only furthering the dangerous addiction to fossil fuels," says a major U.S.-based environmental coalition, offering a letter citizens can e-mail to Dr. Michael Boskin before Wednesday's meeting urging him to lead the company toward a clean energy future.
Story link
Related topics/regions:
[United States]
Image: Exxon/Mobil has done more than any other company to stop the world from tackling climate change, charges Greenpeace. Their campaign urges citizens not to buy gas from Esso, the UK division of Exxon/Mobil. © Greenpeace UK / Greenpeace UK |
|
|
|
