|
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 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=150997
) 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=150222
) 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=147946
) as subquery
InfoChange
<< Back to organisation profile
Features
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
05.07.2007
By 2010, India aims to have 1 million medical tourists a year in its five-star hospitals. "Are we headed towards a system that mobilises incredible resources to protect the lives of the privileged, while abdicating its responsibility towards the poor," asks a doctor who spent a year in the HIV ward of a Chennai hospital.
Story link
Related topics/regions:
[South Asia]
[India]
Image: HIV positive couple, Delhi, India (Photo: UNAIDS/W.Phillips)
13.06.2007
The widows of farmers who have committed suicide in the Indian region of Vidarbha struggle to keep their farms running. For them too, it could be a losing battle.
Story link
Related topics/regions:
[India]
[South Asia]
Image: A woman farmer in India.
05.04.2007
A report by the international human rights organisation Amnesty International has severely criticised Bangladesh for its poor governance, corruption, nepotism, severe political tension, and lack of accountability. The report was released on the country's 36th Independence Day on 26th March 2007.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
