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=129586
) 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=129424
) 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=129117
) 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=129083
) 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=129028
) as subquery
21.03.2006
Burundi must be closely monitored in the countdown to the UN's planned withdrawal by the end of this year, Secretary-General Kofi Annan warned.
10.03.2006
A new emergency response fund--called "the most important qualitative step forward we have taken since 1991"--was launched at the UN Thursday. Already over half-funded, it has begun to support Kenya's drought-affected and Cote d'Ivoire's largely forgotten suffering population.
10.03.2006
The UN has formally launched a $500 million fund to jump-start relief operations in natural and man-made disasters.
* UN emergency fund: distribution is key
09.03.2006
Sudan's intelligence agencies continue to target activists, curtailing fundamental freedoms of expression and association, according to a UN independent human rights expert.
