|
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=133054
) 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=132631
) 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=132514
) 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=131177
) 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=128501
) as subquery
Global Health Council
<< Back to organisation profile
Features
18.05.2006
Communities in over 100 countries are preparing for an International AIDS Candlelight Memorial on 21 May.
Story link
11.05.2006
A New York court judgement that the "Anti-Prostitution Pledge" requirement of US HIV/AIDS programmes violated the rights of two plaintiff organisations may open the doors for a reprieve for US organisations that work with groups of commercial sex workers around the world.
Story link
Related topics/regions:
[United States]
10.05.2006
Meet Bhagwati, the child of a day laborer in rural Nepal. A new program to train health workers on neonatal health problems probably saved her life.
Story link
Related topics/regions:
[Nepal]
Image: The program is currently covering 300,000 people in Morang District, Nepal. © Global Health CouncilRelated links
19.04.2006
Better understanding of why some people choose to sleep under the net while others don't is integral to fighting malaria, says a new study that presents some surprising findings on bednet use.
Story link
Image: One finding: the more nets a family owned, the less likely all of them would be used. © SciDev.Net
01.03.2006
Since it's founding in 1982 Operation Smile has been providing free reconstructive surgery to children with facial deformities in 24 countries around the world, helping end the isolation, embarrassment, and health problems associated with cleft lips and cleft palates.
Story link
Related topics/regions:
[Nicaragua]
<< Previous
| 1
| 2
| 3
| 4
| 5
| < 6 >
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
|
|
|
