|
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=138245
) 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=136982
) 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=136897
) 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=136892
) 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=136864
) as subquery
InfoChange
<< Back to organisation profile
Features
24.08.2006
In a bold move India is backing moves to promote a national needle exchange and drug substitution programme for intravenous drug users in order to halt the spread of HIV/AIDS in this high-risk and vulnerable group.
Story link
Related topics/regions:
[India]
26.07.2006
The Indian Cabinet has approved key amendments to the landmark Right to Information that will restrict citizens’ access to ‘notings’ made by government officials on all files except those related to social and development projects. Angry activists say that such a measure will “take the life out of the law.”
Story link
Related topics/regions:
[India]
24.07.2006
Two decades after the launch of a nationwide initiative to ensure that government-run schools have more classrooms and teachers, a new survey shows that over 100,000--nearly 10%--of the country’s elementary schools have only one classroom.
Story link
24.07.2006
Two decades after the launch of a nationwide initiative to ensure that government-run schools have more classrooms and teachers, a new survey shows that over 100,000--nearly 10%--of the country’s elementary schools have only one classroom.
Story link
24.07.2006
Bio diesel blends are driving buses in many Indian states like Haryana, Karnataka and Pune. As bio diesel becomes the buzzword and corporates rush to develop jatropha and oilseed plantations, experts warn of adverse effects on biodiversity and food security.
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 >>
|
|
|
|
