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=66956
) 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=65030
) 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=62481
) 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=57552
) 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=65945
) as subquery
The same story has played out time and again in Liberia and across the African continent: from conflict to ceasefire to power-sharing to resentment to conflict. African rights expert Rotimi Sankore describes a Marshall Plan for Africa that could break the cycle and save billions of dollars in peacekeeping in the long run.
06.08.2003
Fahmau is dedicated to strengthening the work of not-for-profit and other organisations throughout the world through the use of information and communication technologies.
27.06.2003
The indictment of Liberian President Charles Taylor is a welcome announcement, especially for the millions of West Africans murdered, maimed and displaced by his war networks, says Nigerian lawyer and former UN human rights advisor in Sierra Leone, Chidi Anselm Odinkalu, but mismanagement by the prosecutor is to blame for the failure to secure Taylor's extradition.
Reports of arrests, beatings and other violence have been streaming out of Zimbabwe all week as opposition supporters staged a massive "stay-away" in a bid to force the resignation of President Robert Mugabe.
02.05.2003
Fahamu's programme 'Adilisha' (which in Kiswahili means "to teach or promote justice or good behaviour") seeks to strengthen advocacy capacity of human rights organisations in Africa. This is done through distance-learning courses that involve the use of CDROMS and email along with face-to-face workshops.
