|
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=139956
) 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=139390
) 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=139095
) 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=138918
) 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=138915
) as subquery
InfoChange
<< Back to organisation profile
Features
27.09.2006
Global CSO network Sustainability Watch reports that market-oriented development frameworks that promote trade liberalisation and privatisation adversely impact sustainable development as they do not pay attention to environmental constraints, especially in the case of planning for land and natural resource use.
Story link
Related topics/regions:
[India]
15.09.2006
A three-week yatra (protest rally) by NGOs in north Indian towns seeks to assert community rights over water resources. The rally specifically targets MNC soft drink giants Coca-Cola and PepsiCo over their exploitation of water.
Story link
Related topics/regions:
[India]
Image: Challenging the corporate water takeover © WDM
11.09.2006
An Indian government study finds that almost one in six ship workers at Asia’s largest shipbreaking yard, Alang in Gujarat, suffers from asbestos poisoning that could lead to lung cancer. At 2 per 1,000, the fatal accident rate among Alang’s ship workers is several times higher than the 0.34 per 1,000 in the mining industry, considered India’s most unsafe profession.
Story link
Related topics/regions:
[India]
Image: A worker in Gujarat
06.09.2006
The natural disaster over, now lower-caste survivors of the floods in Barmer have to face up to the human tragedy of caste discrimination in the distribution of relief.
Story link
06.09.2006
The natural disaster over, now lower-caste survivors of the floods in Barmer have to face up to the human tragedy of caste discrimination in the distribution of relief.
Story link
Related topics/regions:
[India]
<< Previous
| 1
| 2
| 3
| < 4 >
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
