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=159264
) 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=159223
) 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=159046
) 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=158654
) 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=158338
) as subquery
31.03.2008
Zimbabweans heard Sunday night that the results of this weekend's general elections would be declared from 4am GMT on Monday, amidst mounting fears that the Zimbabwe Electoral Commission's failure to reveal the outcome of the vote earlier signalled further efforts to rig the polls.
+ OneWorld's Zimbabwe Guide
28.03.2008
MELBOURNE, Mar 28 (IPS) - Organisers of Earth Hour 2008 estimate that in excess of 30 million people worldwide will take action on Saturday to raise awareness of how small changes can make big differences when it comes to climate change.
21.03.2008
BANGKOK, Mar 20 (IPS) - New technology, religion, and the market must be harnessed to secure basic toilet facilities for Asia's rural and urban poor, sanitation experts from the region said here Thursday.
10.03.2008
WINDHOEK, Mar 10 (IPS) - The Namibian government plans to stay the course with an economic incentive program for corporations -- known as export processing zones (EPZ) -- despite one of the largest of the foreign investors deciding last week to close down its operations -- a move that will destroy 3,000 jobs.
28.02.2008
Alarming local and international rights activists, several officials in the Thai government are speaking freely about the 'necessity' of using extra-judicial killings as part of a national clampdown on narcotics.
