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=156734
) 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=156458
) 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=156441
) 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=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
11.01.2008
To raise money and awareness for the plight of displaced Iraqis among neighboring Arab nations, the UN and the Arab League are launching a "massive" campaign featuring celebrities and refugee stories.
01.01.2008
The joint UN-African Union force set up to stem the violence in Darfur has taken the reins from the existing African Union operation, but UN Secretary-General Ban Ki-moon warned that critical gaps remain in what will be the world's largest peacekeeping operation.
31.12.2007
The UN-African Union Mission in Darfur -- set to become the world's largest peacekeeping operation -- is poised to take over on Monday from the African Union force that has been working to quell the violence in western Sudan.
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.
