|
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=160944
) 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=160682
) 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=160381
) as subquery
United Nations' Integrated Regional Information Network
IRIN is an Internet-based humanitarian news and information service. It comes under the auspices of the United Nations and is dedicated to improving the response of the international community to humanitarian crises and natural disasters through the provi
Main Address
UNOCHA House
UN Avenue
Gigiri
PO Box 30218 Nairobi
Main Telephone
+2542 622147
Joined OneWorld
16.10.2000
Features
24.06.2008
Typhoon Fengshen, which hit the Philippines this weekend and is now moving towards China, has killed 244 people, left hundreds missing, and made thousands homeless in the island nation.
Story link
Related topics/regions:
[Philippines]
27.05.2008
Sexual abuse by aid workers and peacekeepers goes widely unreported as victims decline to speak out for fear of negative repercussions, says report released today by Save the Children.
Story link
Related links
05.05.2008
As of Monday Morning, almost 4,000 people are believed to have died -- and tens of thousands more were forced to flee their homes -- as Cyclone Nargis hit Burma this weekend. A thorough damage assessment will be difficult, notes the United Nations.
Story link
Related topics/regions:
[Myanmar]
Related links
|
|
|
|
