|
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=153234
) 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=150631
) 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=150253
) as subquery
Centre for Science and Environment
CSE is a public interest research and advocacy organisation, which promotes environmentally-sound and equitable development strategies.
Main Address
41
Tughlakabad Institutional Area
New Delhi 110 062
110 062 New Delhi
Main Telephone
+91 11 29956110
Joined OneWorld
02.02.1998
Features
17.09.2007
The botted water industry is global in nature. But it is designed to sell the same product to two completely different markets: one water rich and the other water scarce. The question is whether this industry will have different outcomes in these two worlds. Or will we, for two opposite reasons, agree that their business costs us the earth and that it is not good for us?
Story link
Related topics/regions:
[South Asia]
26.06.2007
Street vendors in India have been protesting against corporates entering retailing of fruits and vegetables as they fear this will deprive them of their livelihood. The protests, which turned violent in many cities, are against the government as vendors find it more sympathetic to the corporates than them.
Story link
Related topics/regions:
[India]
[South Asia]
14.06.2007
The Indian government's plans to put into place European emission standards by 2010 may not be achieved as diesel cars are expected to corner almost half of the car market. Diesel exhaust has been implicated for a variety of diseases including cancer and adverse birth effects.
Story link
Related topics/regions:
[South Asia]
[India]
|
|
|
|
