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=62471
) 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=57276
) 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=56593
) 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=55403
) 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=54472
) as subquery
27.06.2003
In the rush to provide basic security and medical care in conflict and refugee situations, reproductive health care is often overlooked. As war loomed in Iraq, women's health groups worked to prepare local medical practitioners in the region to meet the medical needs of women affected by the conflict.
02.06.2003
"Brazil is saving lives and saving resources at the same time, and that should be an inspiration to countries around the world," said a senior fellow at the Bill and Melinda Gates Foundation, which awarded the country's national AIDS program this year's prestigious Gates Award for Global Health.
In a world where "haves" and "have-nots" have drifted far apart, is it possible to find common ground from which to promote effective development solutions? It is, and we must, says Global Water Partnership Chair Margaret Catley-Carlson, noting that participation by the poor in the decisions and processes that shape their lives is the key to successful development.
Remember the millions who have died of AIDS and show support for the living during the May 18 International Candlelight Memorial. Global Health Council provides a toolkit for organizing a ceremony in your community.
