|
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=160106
) 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=158443
) 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=157711
) 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=155903
) 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=154928
) as subquery
Global Health Council
<< Back to organisation profile
Features
24.04.2008
Dr. Binayak Sen -- imprisoned without trial for over a year on terrorism charges -- is being honored for his dedication to health and human rights in poor and tribal communities in his native India.
Story link
Related topics/regions:
[India]
03.03.2008
The head of a Nigerian organization seeking to empower people through sustainable development among youth and in rural areas discusses the history of the AIDS epidemic in Nigeria, the "AIDS generation" in this country, and ongoing awareness and prevention campaigns.
Story link
Related topics/regions:
[Nigeria]
Related links
11.02.2008
After raising her HIV-positive nephew, whose parents passed away due to AIDS, Bernadette Otieno founded an organization that currently supports 93 orphans so that they can live with foster families, not in orphanages.
Story link
Related topics/regions:
[Kenya]
06.12.2007
In past years, the HIV epidemic has ravaged the populations of many former Soviet nations, the majority of victims claimed by needle sharing and drug use. Thanks to new programs such as needle exchange and harm reduction, these countries are taking big steps in the fight against HIV/AIDS.
Story link
Related topics/regions:
[Russian Federation]
[Ukraine]
Related links
07.11.2007
Although syringe exchange programs have proven effective in reducing HIV infections among U.S. drug users, government support remains spotty, comment experts in the field.
Story link
Related topics/regions:
[United States]
Image: Syringe exchange programs curve HIV infection © Global Health Council
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
|
|
|
