|
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=160817
) 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=158767
) 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=157805
) as subquery
United Nations Children's Fund
Founded in 1946, UNICEF became a permanent member of the United Nations in 1953. UNICEF's Executive Director is Ann M. Veneman. UNICEF advocates for the rights of children and women and and contributes to their well-being through programmes that help them survive and thrive to adulthood, and that provide essential medicines, vaccines, educational, health and emergency supplies.
UNICEF's flagship publications include the State of the World's Children, the Progress for Children and the Annual Report. UNICEF's Annual Report, issued mid-year, spotlights the significant results achieved by UNICEF and its partners on behalf of children around the world. The Innocenti Research Centre (http://www.unicef-icdc.org/.) undertakes original research to improve international understanding of issues relating to children's rights.
Main Address
Unicef House
3 UN Plaza
New York NY 10017
Main Telephone
212 326 7000
Joined OneWorld
21.05.1998
Features
09.06.2008
Saw Leh Ler Shee is just one of the million children displaced by the Myanmar cyclone but he and many others have found refuge in child-friendly spaces run by caregivers and relief groups.
Story link
Related topics/regions:
[Myanmar]
Related links
14.02.2008
The number of armed groups or forces using child soldiers has increased from 40 to 57, according to a report by the UN Secretary-General's office.
Story link
Image: Child soldiers airlifted to safety © Unicef/HQ01-0088/Stevie Mann / UNICEF UK |
|
|
|
