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=132762
) 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=132761
) 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=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
16.05.2006
Leaders have failed to develop a "people's peace," says Julie Flint, warning that demonstrations by Darfurians against the deal as well as their ignorance of the deal's provisions are signs that it will not last.
15.05.2006
South Africa still suffers from "institutionalized gender oppression," says rights activist Delphine Serumaga, believing that the Jacob Zuma verdict reinforces chauvinistic attitudes toward rape as well as male privilege and power. Serumaga and four other South Africans respond to Zuma's acquittal.
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
