|
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=81451
) 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=72472
) 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=72115
) as subquery
World Resources Institute
The World Resources Institute is an environmental research and policy organisation that creates solutions to protect the planet and improve people's lives.
Main Address
10 G Street, NE (Suite 800)
Washington DC DC 20002
Main Telephone
202 729-7600
Joined OneWorld
14.05.2001
Features
12.03.2004
"The world no longer has the luxury of time in achieving stability and security for the global climate system," warns the World Resources Institute in a statement issued in the run-up to next week's tenth anniversary of ratification of the Kyoto Protocol. During the past ten years greenhouse gas emissions have risen by 11 percent.
Story link
11.11.2003
A large number of farmers in rural India are breathing a little bit easier these days. For decades, they have been locked into a government-organized trading scheme that nearly ensures they get fleeced by the middlemen when they sell their grains at auction. But now that's changing.
More
Related topics/regions:
[India]
[capacity building]
[communications]
05.11.2003
1.5 million farmers in 11,000 Indian villages have access to a wired computer--provided and maintained by a nationwide grain trading corporation--enabling them to follow price trends, deal directly with companies to get the highest possible prices for their crop, and exchange information about growing techniques and more.
Story link
Related topics/regions:
[India]
|
|
|
|
