|
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 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=147897
) 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=146793
) as subquery
InfoChange
<< Back to organisation profile
Features
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
04.04.2007
A report by 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
Related topics/regions:
[South Asia]
[Bangladesh]
05.03.2007
The Indian government has initiated the registration of plant varieties with the Protection of Plant Variety and Farmers’ Rights Authority (PPV&FRA) to provide them globally-recognised protection against piracy. The government plans to register 12 varieties of crop that will provide protection to farmers and farm communities to evolve, preserve and refine crop varieties.
Story link
Related topics/regions:
[South Asia]
[India]
<< Previous
| 1
| < 2 >
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
