|
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=16695
) 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=16694
) 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=16678
) 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=16697
) 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=7564
) as subquery
Panos London
<< Back to organisation profile
Features
11.07.2000
Despite having a strong pharmaceutical industry, India's health service is in bad shape. And critics of the government's national AIDS programme are blaming what they call the 'donor led programme' for redirecting scarce funds away from what they say are more pressing and widespread health needs. Ranjit Devraj reports.
Story link
Related topics/regions:
[India]
[South Asia]
11.07.2000
At least twelve million people in the developing world are in urgent need of the antiretroviral drugs which suppress HIV and indefinitely postpone symptoms of AIDS. But the vast majority live in the world's poorest countries and cannot afford the US$5,000 a year that the drugs, medical tests and consultations cost. Read the media summary briefing from Panos.
Story link
08.07.2000
With as many as 1.5 million rapes every year in South Africa and estimated HIV infection numbers at one in every nine adults, rape carries a potential death sentence for those who survive it. Doctors believe the only hope is drugs treatment AZT. But the government refuses to offer it free of charge.
Story link
Related topics/regions:
[South Africa]
08.07.2000
'Miracle cures' are not uncommon, whether in rich countries or poor. The latest claim to cure AIDS has come out of Zambia, a country that is badly hit by the disease. Using Chinese herbal remedies, a doctor who has developed the treatment is challenging doubting colleagues to try it out. Anthony Mukwita reports.
Story link
Related topics/regions:
[Zambia]
06.07.2000
You don't have to be a rocket scientist to crunch the numbers: as many as 1.5 million rapes occur every year in South Africa and the World Health Organization believes one in every nine adults in the country may be infected with HIV, the virus that causes AIDS. Clearly, rape carries a potential death sentence for those who survive it.
Story link
Related topics/regions:
[Afghanistan]
Image: Zambian AIDS orphan, being cared for by his grandfather © UNICEF/Zambia/Pirozzi
<< Previous
| 1-10
| 11-20
| < 21 >
| 22
| 23
| 24
| 25
| 26
| 27
| 28
| 29
| 30
| 31-38
| Next >>
|
|
|
|
