|
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=160810
) 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=160783
) 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=160695
) as subquery
Worldwatch Institute
Worldwatch is a nonprofit public policy research organization dedicated to informing policymakers and the public about emerging global problems and trends and the complex links between the world economy and its environmental support systems.
Main Address
1776 Massachusetts Ave. NW
Washington DC 20036
Main Telephone
202-452-1999
Joined OneWorld
03.06.2005
Features
06.06.2008
China's new wind power program, already surpassing expectations, is poised to become a major source of energy for the coal-dependent country, writes Chinese industrial expert Junfeng Li.
Story link
Related topics/regions:
[China]
Related links
03.06.2008
Leading manufacturers of compact fluorescent light bulbs have unveiled plans to reduce the amount of mercury in these energy-efficient lamps.
Story link
Related topics/regions:
[United States]
[Europe]
Related links
28.05.2008
A global reduction in wasted food -- feasible if government, industry, and civil society work together -- would conserve vast amounts of water says a new international report amid growing concerns over food and water scarcity.
Story link
Related links
|
|
|
|
