|
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=159639
) 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=159455
) 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=159098
) as subquery
Earth Policy Institute
Earth Policy Institute, an independent environmental research organization founded in May 2001 by Lester R. Brown, provides a vision and plan for creating an “eco-economy”—an environmentally sustainable economy. It disseminates the latest information and research to help educate people about how they can make a difference.
Main Address
1350 Connecticut Ave., NW, Suite 403
Washington, DC 20036
Main Telephone
202 496 9290
Joined OneWorld
14.10.2003
Features
10.04.2008
Between 2000 and 2006, carbon dioxide emissions from the burning of fossil fuels grew 3.1 percent a year -- more than twice the rate of growth during the 1990s, says a new study from an environmental think tank.
Story link
Related topics/regions:
[United States]
[China]
Related links
04.04.2008
A new review of coal-fired electricity generation in the United States suggests that pressure from financial groups, state governments, environmental and community organizations, and scientists will soon spur a "de facto moratorium" on coal-driven power plants.
Story link
Related topics/regions:
[United States]
Related links
24.03.2008
World food production faces a "massive threat" as mountain glaciers in China and India -- the world's leading producers of wheat and rice -- are melting at an extremely fast, climate-induced rate, reports an environmental research institute.
Story link
Related topics/regions:
[India]
Related links
|
|
|
|
