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=158950
) 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=157744
) 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=157317
) as subquery
18.03.2008
A five-year downward trend in asylum applications in industrialised countries was reversed in 2007, largely because of an increase in the number of Iraqi asylum-seekers, according to provisional statistics compiled by the UN refugee agency.
+ Carnage and Despair in Iraq
13.02.2008
Aid agencies operating in Iraq have launched their first Consolidated Appeal for more than $265 million to help meet the immediate needs of the most vulnerable displaced Iraqis.
30.01.2008
The UN refugee agency has asked donors to contribute $90 million for programmes to assist millions of internally displaced people during the coming year.
