|
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=151850
) 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=151748
) 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=151675
) 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=150623
) 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=149184
) as subquery
United Nations Children's Fund
<< Back to organisation profile
Features
02.08.2007
The west Indian state of Gujarat is celebrating a successful school enrollment drive that started five years ago to ensure all children, especially girls, are enrolled in schools. Through community mobilisation in 18,000 Gujarat villages the initiative has met with sizeable success.
Story link
Image: A girl in Gujarat, India. © IRIN (Integrated Regional Information Networks)
Related links
29.07.2007
Two UN agencies have issued a $129 million joint appeal aimed at getting tens of thousands of uprooted Iraqi children back in school.
Story link
Related topics/regions:
[Iraq]
Image: Iraqi children at Baghdad's rubbish dump. © IRIN
Related links
27.07.2007
As part of a new media video contest, 10 youngsters from around the world vlog their thoughts and experiences on HIV and AIDS.
Story link
26.06.2007
Nearly 50,000 street children and youth from underprivileged neighbourhoods get birth certificates in a vital initiative launched by UNICEF, government agencies, NGOs and the Kolkata Municipal Corporation that provides them with access to health care, education and other services. Registration also helps protect children against potential abuse.
Story link
Related topics/regions:
[South Asia]
[India]
14.05.2007
Nigeria has achieved universal salt iodization, the first African country to do so.
Story link
Related topics/regions:
[Nigeria]
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
