|
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=147915
) 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=145979
) 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=145903
) 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=139846
) 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=139842
) as subquery
Centre for Science and Environment
<< Back to organisation profile
Features
04.04.2007
An Indian organisation, CSE (Center for Science and Environment), is providing a platform for experts and stakeholders to discuss issues ranging from the costs and impacts of mining, to mineral laws and regulations and people’s movements against mines on April 26-27, 2007 in Indian capital, New Delhi.
Story link
Related topics/regions:
[South Asia]
[India]
08.02.2007
India’s gharials are in serious trouble. There are fewer than 200 of these crocodiles left in the wild. And their deplorable state has remained ignored even by the media, while the tiger hogs the headline--but the truth is that gharials are 20 times more endangered than tigers.
Story link
07.02.2007
India’s gharials are in serious trouble. There are fewer than 200 of these river predators left in the wild. And their deplorable state has remained ignored even by the media, while the tiger hogs the headline - but the truth is that gharials are 20 times more endangered than tigers.
Story link
Related topics/regions:
[South Asia]
[India]
25.09.2006
The Centre for Science and Environment is disappointed that the Kerala High Court has cited a technicality to set aside the Indian state's ban on the production and sale of Coca Cola and Pepsi, which tests have found to be dangerously high in pesticides.
Story link
25.09.2006
The Centre for Science and Environment is disappointed that the Kerala High Court has cited a technicality to set aside the Indian state's ban on the production and sale of Coca Cola and Pepsi, which tests have found to be dangerously high in pesticides.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
