|
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=140271
) 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=140118
) 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=140112
) 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=130000
) 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=126064
) as subquery
Population Media Center
<< Back to organisation profile
Features
03.10.2006
As U.S. population passes the 300 million mark, the Amazon rainforest is in its second year of severe drought, which could have disastrous consequences for life on the planet. The Population Media Center outlines how these issues are related, and what it's doing to help solve the problem.
Story link
Related topics/regions:
[United States]
[Brazil]
29.09.2006
Halima Abdulsalami was 18 and suffering from a debilitating and isolating condition known as obstetric fistula until she learned, from a radio drama, that help was available.
Story link
29.09.2006
Halima Abdulsalami was 18 and suffering from a debilitating and isolating condition known as obstetric fistula until she learned, from a radio drama, that help was available.
Story link
Related topics/regions:
[Nigeria]
29.03.2006
Some 250,000 people tried to register for adult education classes in a single day following an episode of a Mexican television soap opera in which an older man broke down in tears when he could finally read his granddaughter's letters. TV and radio dramas not only get key messages across, but they're doing it cheaply and effectively.
Story link
24.01.2006
Overpopulation is not a new issue, but somewhere along the line it lost its sexiness. Perhaps the setters of prevailing opinion decided that advancing technologies would save us from having to worry about it. But that trend in thinking might be starting to turn back, as it seems the population prognosticators are gradually finding their public voice again...
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| Next >>
|
|
|
|
