|
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=160822
) 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=160791
) 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=160694
) as subquery
International Rescue Committee
IRC provides assistance in the form of relief, shelter and resettlement to refugees and other victims fleeing from or affected by oppression, epidemics, armed conflict, war, and other complex humanitarian emergencies worldwide.
Main Address
122 East 42nd Street
New York New York 10168
Main Telephone
1 212 551 3000
Joined OneWorld
23.06.2006
Features
09.06.2008
Security and international aid have become dangerously intertwined in Afghanistan, even though the 5 million refugees that have returned to the country since 2002 are in desperate need of humanitarian assistance, writes policy adviser Anna Husarska.
Story link
Related topics/regions:
[Afghanistan]
Related links
04.06.2008
Nepalese villagers return to their homes after a decade of war only to battle the familiar enemies of hunger and malnutrition.
Story link
Related topics/regions:
[Nepal]
Related links
28.05.2008
Only 25 percent of cyclone survivors in Myanmar are receiving the aid they need in terms of food, shelter, and other services.
Story link
Related topics/regions:
[Myanmar]
Related links
|
|
|
|
