
|

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=127701
) 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=125640
) 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=125327
) 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=123395
) 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=123002
) as subquery
Global Health Council
<< Back to organisation profile
Features
16.02.2006
Simple, inexpensive and community based solutions are yielding big rewards in a country with the highest child and maternal mortality rates in the world. Programs that focus on local participation, education and integrated approaches to improving healthcare are giving people the tools needed to treat and prevent the biggest killers: malaria, diarrhea and pneumonia.
Story link
Related topics/regions:
[Sierra Leone]
Image: Low-tech solutions can survive infrastructure breakdowns and can withstand times of conflict. © Human Rights Watch
17.01.2006
While HIV/AIDS and malaria get the most attention, Sub-Saharan Africans are suffering the devastating affects of five so-called "diseases of poverty," even though affordable means of prevention are available. In fact, a collaborative study has designed an integrated program that could treat all five diseases at once for $0.92 per person.
Story link
Related topics/regions:
[Africa]
10.01.2006
The Brazilian government refused to submit to a U.S. mandate requiring aid recipients to publicly declare their opposition to prostitution, costing the country $40 million of HIV/AIDS funds. Now, Brazilian NGOs are facing budget constraints and are worried the loss of money will wash away the huge strides they have made in fighting the pandemic.
Story link
Related topics/regions:
[Brazil]
[United States]
06.12.2005
G. Karunanidhi reveals the emotions and trials of living with HIV in Tamil Nadu, India. Reflecting on his own search for support, he founded three "Positive Living Centers," which today serve 1,400 people living with HIV/AIDS and their families. The Centers also give Karunanidhi a reason to live.
Story link
Related topics/regions:
[India]
29.11.2005
In many countries with high HIV rates, women do not have the power in sexual relationships to deny sex; in sub-Saharan Africa, for example, three-fourths of young people infected with HIV are women. As a result, methods of prevention controlled by women are crucial tools in the fight against HIV/AIDS.
Story link
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| < 7 >
| 8
| 9
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
 |


|
 |