|
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=156254
) 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=155529
) 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=155428
) 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=154400
) 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=153929
) as subquery
United Nations High Commissioner for Refugees
<< Back to organisation profile
Features
18.12.2007
The UN Refugee Agency is appealing to the British public to help displaced Iraqis following the displacement of people in northern Iraq as a result of shelling by Turkey.
Story link
Related topics/regions:
[Turkey]
[Iraq]
Image: Activists call for an end to US military activities in Iraq, January 2007 © Jeffrey Allen
25.11.2007
Amid media reports that thousands of refugees are going back to Iraq, the UN refugee agency says that while improved security conditions were welcome it was not yet time to promote returns.
Story link
Related topics/regions:
[Iraq]
Related links
21.11.2007
The number of displaced people inside Somalia has risen sharply to one million, says the UN refugee agency.
Story link
Related topics/regions:
[Somalia]
23.10.2007
The UN agency in charge of refugees is transferring hundreds of internally displaced people from makeshift camps to organized sites equipped with essential basic facilities in North Kivu, Democratic Republic of Congo.
Story link
Related topics/regions:
[Congo (Democratic Republic of)]
Related links
08.10.2007
Vincenzo Mulé has seen a lot of drama on the high seas during his years with the Italian coastguard, including shipwrecks, massive storms and dramatic rescues. But one incident sticks out in his mind.
Story link
Related topics/regions:
[Europe]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-24
| Next >>
|
|
|
|
