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=136214
) 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=135500
) 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=135887
) 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=135561
) 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=134477
) as subquery
11.07.2006
Dr. Juan Manuel Canales has spent 25 years assisting poor peasant and indigenous communities in El Salvador and Chiapas, on the Mexico-Guatemala border, to demand their right to healthcare. He's been given this year's Jonathan Mann Award for Global Health and Human Rights.
“My parents are Holocaust survivors. They taught me at an early age that there is no 'over there'; there’s only 'over here.'” Maurice Middleberg shares his view of the changing landscape of global health.
04.07.2006
Evidence is accumulating that the incidence and prevalence of HIV/AIDS in some African countries - notably Kenya and Zimbabwe - is declining. Why? What do these reversals say about the best way forward for prevention on a large scale?
26.06.2006
Dr. Arata Kochi, the new director of the World Health Organization’s malaria program, sat down with the Global Health Council to answer questions about new treatment guidelines and some of the most challenging aspects of malaria control.
09.06.2006
At a recent conference on global health, Dr. Nils Daulaire, president of the Global Health Council, called on the international community to restore family planning as an integral part of the global health agenda. Read his speech and learn why reproductive rights are so important for women everywhere.
