|
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 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=146823
) 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=141043
) as subquery
Global Health Council
<< Back to organisation profile
Features
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
07.03.2007
Global health advocates are dismayed over a Court of Appeals ruling that the U.S. government can require U.S. organizations receiving HIV/AIDS grants to have a policy condemning prostitution.
Story link
Related topics/regions:
[United States]
18.10.2006
"The chances are very good that you will make it to Kindergarten," the Global Health Council wrote in a Happy Birthday note as the U.S. population clock ticked past 300 million Tuesday morning. The same cannot be said for thousands of others who share your birthday, the group lamented.
Story link
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
|
|
|
