|
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=76002
) 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=75997
) 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=75745
) 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=75684
) 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=75661
) as subquery
InfoChange
<< Back to organisation profile
Features
30.12.2003
A supplementary education project in Kutch, Gujarat, in west India, shows how meaningful education is possible despite the limitations of the state-managed education system.
Story link
Related topics/regions:
[India]
30.12.2003
Teachers in a village in interior Maharashtra have come up with a new idea to boost school enrolments. They treat students when they are ill. This has helped boost school attendance and enrolments in the region.
Story link
Related topics/regions:
[India]
23.12.2003
A 20,000-square-foot business centre in the central Indian city of Hyderabad, designed by architect Karan Grover, has been rated as the world's most energy-efficient building.
Related topics/regions:
[India]
22.12.2003
The degradation of Muthumari, a dalit (lower caste) woman in Madurai district of India, by an upper-caste man has brought human rights organisations and dalit women together to fight all atrocities
Story link
Related topics/regions:
[India]
22.12.2003
Countries such as India, Bangladesh and Myanmar are heavily dependent on a predictable monsoon season for the cultivation of rice. But they are more likely to suffer increases in malnutrition if climate change affects the reliability of the rainy season.
Story link
Related topics/regions:
[Bangladesh]
[India]
[Myanmar]
<< Previous
| 36-45
| 46
| 47
| 48
| 49
| 50
| 51-60
| 61-70
| 71-80
| 81-90
| Next >>
|
|
|
|
