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=131857
) 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=130928
) 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=130153
) 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=128801
) 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=128187
) as subquery
28.04.2006
Twelve years ago on 27 April, millions of South Africans took part in the first non-racial democratic election following the end of minority white rule. Piers Pigou reflects on the unfinished business of the country's truth and reconciliation process.
14.04.2006
Twelve years after the Rwandan genocide, Gerald Caplan argues that understanding about its real causes remains limited, while the superpowers continue to act in their own self-interest when it comes to other genocides.
31.03.2006
The tension of expectation is building in Zimbabwe as people’s misery becomes unsustainable. Will this be the year for change, wonders Mary Ndlovu.
* OneWorld UK Guide to Zimbabwe
24.02.2006
Corruption in Kenya is driven by neo-liberal policies imposed by the West as well as by a lack of democratic institutions, argues Onyango Oloo, a political activist and former political prisoner.
