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=156393
) 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=156026
) 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=155993
) 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=155854
) 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=155663
) as subquery
27.12.2007
The UN Secretary-General’s Special Representative for Somalia has called for the release of two abducted female staff members of Doctors Without Borders.
From UN News
11.12.2007
The United Nations World Food Program is teaming up with the world's most popular food blog, Chez Pim, to raise money for small-scale farmers in the Southern African nation of Lesotho.
10.12.2007
Environmental sustainability projects have generated millions of new "green collar" jobs around the world, and there is a potential for many more to come, according to a UN Environmental Programme report.
05.12.2007
Although primary school attendance, girls' enrollment, and academic funding have all skyrocketed in the last decade, one in five adults around the world still lack basic literacy skills, says a UN report.
29.11.2007
Hundreds of millions of people around the world have rolled up their sleeves and gotten their hands dirty to promote a greener earth and to show their support for next month's international climate change conference in Bali.
