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=154346
) 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=154274
) 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=154238
) 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=154057
) 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=154019
) as subquery
22.10.2007
A UN report conducted on the tenth anniversary of a landmark study about children in armed conflict stresses the importance of international vigor in ending the use of child soldiers and sexual abuse in conflicts.
18.10.2007
The World Food Programme suspended food distribution in Mogadishu after Somali government forces invaded the UN compound yesterday and abducted the local head of the agency in a move immediately condemned by Secretary-General Ban Ki-moon. And in Darfur, three WFP truck drivers were shot dead in the past week.
17.10.2007
While maternal deaths have dropped in developed countries, more than 1 in every 20 women dies in childbirth in Africa and Asia, a UN study shows.
11.10.2007
Two former commanders of a pro-government militia have been convicted by a local tribunal of war crimes they committed during the country's prolonged civil war in the 1990s.
10.10.2007
Teaching children about disaster risk reduction can inspire parents to engage the rest of the community -- and even elected officials -- to get prepared for future disasters, says a UN official. Wednesday is the International Day for Disaster Reduction.
