|
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 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=153778
) 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=153082
) 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=152103
) as subquery
Global Health Council
<< Back to organisation profile
Features
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
03.10.2007
Starting with a loan that she received from a local pharmaceutical company, Dorah Nyanja, a registered nurse, set up a much-needed clinic in the Kenyan capital's largest slum.
Story link
Related topics/regions:
[Kenya]
Image: A glimpse into Kibera, Nairobi's largest slum. © Peter Armstrong
12.09.2007
Infant and maternal mortality rates needlessly remain high in developing countries, say women's health advocates organizing a conference to build political will to end the problem.
Story link
Image: Infant mortality; mother and baby © Nancy Durrell McKenna©
Related links
09.08.2007
An international health non-profit explores why soap operas have been successful tools to promote understanding and change regarding health, human rights, and the environment in less developed countries.
Story link
Related topics/regions:
[Ethiopia]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
|
|
|
