|
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=153140
) 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=152903
) 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=152828
) as subquery
InfoChange
This is a one-stop site that provides news, views, perspectives and debates on India's development sector.
Main Address
Flat No. 3, Silver Spurs
NIBM Road
Kondhva
PUNE 411048
Main Telephone
91-20-26833911/ 26854062/ 9811679876
Joined OneWorld
08.07.2002
Features
13.09.2007
In a victory for those fighting for the rights of the girl-child, the Bombay High Court upholds an amendment to the law banning sex-determination tests. A Mumbai-based couple had mounted a legal challenge to the constitutional validity of the amendment that bans pre-conception gender selection.
Story link
Related topics/regions:
[India]
[South Asia]
Image: Gender gets a helping hand
05.09.2007
In a bid to enlist the cooperation of the local population in saving the endangered Asiatic lion, the Gujarat government has initiated a reward scheme for information on poachers and poaching activities in the Gir wildlife sanctuary, the last refuge of the endangered Asiatic lion.
Story link
Related topics/regions:
[India]
[South Asia]
03.09.2007
Climate change is likely to decrease food production in the developing world while industrialised countries could gain in production potential, increasing food insecurity in poorer nations, predicts the UN’s Food and Agriculture Organisation (FAO).
Story link
|
|
|
|
