|
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=160141
) 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=159833
) 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=159330
) 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=158954
) 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=158781
) as subquery
Refugees International
<< Back to organisation profile
Features
25.04.2008
A photoessay reveals the toll 17 years of conflict, political instability, droughts, floods, and an international community struggling to provide aid has taken on Somalia.
Story link
Related topics/regions:
[Somalia]
Related links
16.04.2008
The international community and UN should do more to assist the hundreds of thousands of Ethiopians and Somalis who seek refuge in Yemen, one of the "least developed countries in the world," urges an international refugee agency.
Story link
Related topics/regions:
[Yemen]
[Somalia]
[Ethiopia]
Image: Yemen's geo-strategic position makes it a leading destination for regional asylum seekers. © New InternationalistRelated links
01.04.2008
Foreseeing a continued political stalemate in Burma, Joel Charny urges the international community to address regular peoples' humanitarian needs instead of tightening broad-based sanctions that "often hurt average Burmese more than the ruling regime."
Story link
Related topics/regions:
[Myanmar]
18.03.2008
The United States government lay extreme emphasis on the plight of the world's 11-15 million stateless people in an annual report submitted to Congress on human rights in countries around the world, note activists who are applauding the statement.
Story link
Related topics/regions:
[United States]
12.03.2008
Although three years have passed since the Sudanese government and the nation's main rebel group signed a peace agreement, the humanitarian situation remains deplorable throughout the country, writes an international refugee agency.
Story link
Related topics/regions:
[Sudan]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-32
| Next >>
|
|
|
|
