|
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 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=154637
) 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=154054
) as subquery
Global Health Council
<< Back to organisation profile
Features
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
30.10.2007
The Thai government's policy of compulsory rehabilitation or incarceration for drug users has increased stigma and HIV risk, but local groups representing Thai drug users and HIV-infected citizens are pushing for more constructive programs.
Story link
Related topics/regions:
[Thailand]
Image: Widespread use of unsterilized needles provokes the spread of HIV/AIDS. © Global Health Council
Related links
11.10.2007
HIV-positive South Africans are finding love through an online dating service specifically designed for them, which helps to break the social stigmas associated with AIDS.
Story link
Related topics/regions:
[South Africa]
Related links
<< Previous
| 1
| < 2 >
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
|
|
|
