
|

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 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=151620
) 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=151265
) as subquery
InfoChange
<< Back to organisation profile
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
25.07.2007
In the wake of the increasing number of clinical trials taking place in the country, and countless allegations about unethical practices, India is all set to introduce mandatory registration of all clinical trials.
Story link
Related topics/regions:
[South Asia]
[India]
13.07.2007
Latest data compiled in India has brought down the number of HIV-positive people to 2.5 million, which is less than half of previous estimates of 5.3 million. From being considered the country with the most HIV cases, the new figures put India below South Africa and Nigeria.
Story link
Related topics/regions:
[India]
[South Asia]
Related links
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
 |


|
 |