|
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=156519
) 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=156313
) 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=153395
) 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=153146
) 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=153124
) as subquery
United Nations Children's Fund
<< Back to organisation profile
Features
03.01.2008
Welcome to the International Year of Sanitation, which aims to highlight the need for urgent action on behalf of the more than 40 per cent of the world’s population who continue to live without improved sanitation.
Story link
20.12.2007
Three years after the Indian Ocean Tsunami killed more than 200,000 people and devastated towns and communities, the UN Children's Fund has released a report highlighting progress made for children since the catastrophe.
Story link
Related topics/regions:
[Asia and the Pacific]
Image: After the tsunami: Sri Lankan house and tents © Peter Armstrong
21.09.2007
Education systems in countries of the former Soviet bloc are leaving millions of children behind each year, the UN Children's Fund warned.
Story link
Related topics/regions:
[Eastern Europe]
13.09.2007
Global child deaths have reached a record low, falling below 10 million per year for the first time ever, says the UN Children's Fund in a new report.
Story link
Image: Child in Somalia. © Derk Segaar/IRIN
Related links
13.09.2007
An estimated 83,000 children in central and southern Somalia suffer from malnutrition, 13,500 of whom are severely malnourished and at risk of dying, warns the UN Children's Agency.
Story link
Related topics/regions:
[Somalia]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
