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=101867
) 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=99295
) 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=95616
) 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=94461
) 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=88937
) as subquery
21.01.2005
Many Daily Headlines readers may have participated in the online dialogue with Professor Alan Whiteside of the University of KwaZulu-Natal in South Africa last month. Whether or not you submitted questions, enrich your understanding of the pandemic with insights from one of the top experts living and working at the epicenter of the disaster.
13.12.2004
South African Professor Alan Whiteside is one of the pre-eminent experts on the AIDS epidemic worldwide, having written numerous books on the subject, edited a popular newsletter for over a decade, and been named by Kofi Annan to the Commission for HIV/AIDS and Governance in Africa. He has conducted trainings in Africa, Asia, and the Ukraine. Read the interview with him and pose your own follow-up questions by December 22.
In India, a new book on HIV/AIDS takes a hard look at contemporary sexual behavior and sexual attitudes in rural and urban areas, and among different strata of society. Titled Sexuality in the Time of AIDS, the book identifies contextual, cultural and social factors in local communities that contribute to the risk of HIV infection.
Renown rock star, Peter Gabriel, has given the United Nations Development Program free rights to the song “Don’t Give Up Hope” as background score for a film on the lives of people living with HIV/AIDS in Asia.
The best way to “improve HIV prevention is to improve care for those living with HIV disease”, argues Paul Farmer, medical director of Clinique Bon Sauveur in Haiti. The AIDS epidemic in Haiti is declining because we “acted promptly to integrate HIV prevention with care.”
