|
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=150104
) 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=157512
) 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=156934
) as subquery
Integrated Regional Information Networks (IRIN)
IRIN's principal role is to provide news and analysis about sub-Saharan Africa, the Middle East and Central Asia for the humanitarian community.
The networks target decision-makers in relief agencies, host and donor governments, human-rights organisations, humanitarian advocacy groups, academic institutions and the media. At the same time, IRIN strives to ensure that affected communities can also access reliable information, so they can take informed decisions about their future.
IRIN (Integrated Regional Information Networks) is part of the UN Office for the Coordination of Humanitarian Affairs, but its services are editorially independent. Its reports do not necessarily reflect the views of the United Nations and its agencies, not its member states.
Based in Nairobi, Kenya, IRIN was founded in 1995 to improve the flow of vital information to those involved in relief efforts in the Great Lakes region following the 1994 Rwandan genocide.
Main Address
PO BOX 30218
Nairobi
Main Telephone
+ 254 20 7621994
Joined OneWorld
23.02.2007
Features
05.02.2008
More than one million people live in the Kenyan slum of Kibera. Slum Survivors tells the stories of a few of them and charts their remarkable courage in the face of extreme poverty.
Watch the video here...
|
|
|
|
