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=74123
) 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=73307
) 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=71766
) 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=68931
) 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=68645
) as subquery
"AIDS is not merely a unique situation, but a massive symptom of a much larger disease," says researcher Sanjay Basu, suggesting that resources and action in the coming year should focus not just on changing behavior, but on better understanding the societal and economic marginalization that fuels AIDS and combating the structural institutions that perpetuate it.
"Hunger knows neither limits nor dignity and induces reckless and dangerous behavior," says a woman who lives and works in Zimbabwe, describing the dire hunger situation there and the lamentable lives of poor women, who are the country's biggest losers.
31.10.2003
Uganda's main rebel group, which wants to install a government based on the Ten Commandments, abducted 8,500 children in a recent 12 month period to be used as soldiers and sex slaves and regularly raids and burns villages and refugee camps. More international attention is needed to stifle the expanding conflict, says Uganda expert Denise Lifton.
26.09.2003
Burundi's state regulatory body, the National Communication Council, has lifted the seven-day ban the minister of communications imposed on the private broadcaster, Radio Isanganiro, on 13 September. This allowed the Isanganiro to resume broadcasting last Thursday, Radio Bonesha reported. Radio Bonesha and another private broadcaster, Radio publique africaine (RPA), have since ended their boycott on reporting all state functions.
23.09.2003
The proponents of "deglobalization" won several victories last week--from the collapse of WTO talks to an Argentinian snubbing of the IMF--but as the World Bank and IMF meet in the Arab state of Dubai, where protest simply is not tolerated, there's little reason to expect anything but more neoliberal, pro-rich policy decisions this week, says South African political economist Patrick Bond.
