|
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=117693
) 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=117372
) 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=117125
) 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=114036
) 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=113284
) as subquery
Global Health Council
<< Back to organisation profile
Features
25.08.2005
When her husband contracted AIDS, Kenyan nurse Ruth Abwao Bandi saw his care neglected even by other health professionals. This negative experience turned Bandi into an advocate against stigma and she has formed support groups in her community to help people understand and respond proactively to the results of their HIV tests.
Story link
Related topics/regions:
[Kenya]
19.08.2005
Donor countries are making decisions now concerning their contributions to the Global Fund which is facing significant shortfalls for 2005. The Global Health Council asks you to support replenishment of the Global Fund by signing the international appeal for increased and adequate funding by August 20.
Story link
16.08.2005
Thousands of women in Central America are being tested for cervical cancer every year thanks to Grounds for Health, a unique partnership between American companies and the coffee-growing communities where they do business, which provides life-saving testing, follow-up, and treatment to co-op member families.
Story link
Related topics/regions:
[United States]
[Central America]
Image: Volunteer teams and local community leaders make cervical cancer screening possible. © Global Health Council
27.06.2005
A partnership of Christian and Muslim religious leaders from five African nations has shown tangible success in establishing sustainable systems of HIV/AIDS prevention and service delivery, and represents a model of hope for reversing the tide of the epidemic's impact on the African continent.
Story link
Related topics/regions:
[Africa]
Related links
15.06.2005
Throughout the world, those who who save lives by giving blood were honored Tuesday. Inspired by the success of Malawi--who saw a hospital's maternal mortality cut in half after a blood bank was established--the WHO and other organizations are urging developing countries to promote voluntary, unpaid blood donation systems, as these tend to be the most effective.
Story link
Image: Pouch of blood © Environment News Service
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| < 9 >
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
|
|
|
