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=131591
) 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=122269
) 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=117664
) 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=117348
) 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=115328
) as subquery
25.04.2006
One in 10 people who take anti-retrovirals will experience difficulties with the medication or their bodies will reject it completely. This was heard in Cape Town on Tuesday at Microbicides 2006, the first international conference held in Africa into research into gels that could prevent HIV transmission in women.
16.11.2005
Under the incredulous eyes of the participants at the World Summit on the Information Society (WSIS) in Tunis, Tunisia, journalists and human rights defenders were manhandled, insulted, and then beaten, said a press release from the Association for Progressive Communications (APC).
24.08.2005
Africa must urgently boost investments in aquaculture to fight hunger as natural fish stocks on the continent and elsewhere decline, scientists say. Africa is the only region in the world where the per capita fish consumption is dropping, placing an estimated 200-million Africans who depend on fish as a main part of their diet at risk of malnutrition. Experts are meeting on Monday at the Fish for All Summit in the Nigerian capital of Abuja to find sustainable ways of reviving Africa's dwindling fish stocks.
18.08.2005
When European settlers landed in South Africa, they hardly saw the locals as cutting-edge scientists and health practitioners. In fact the indigenous people harboured a treasure trove of remedies for all kinds of diseases, knowledge of how to farm effectively and principles of good nutrition. And African women who were mostly the gatekeepers of this knowledge always had a traditional fix for life’s problems.
14.07.2005
Leaders of the Group of Eight (G8) nations slammed the door in Africa's face in Gleneagles last week, just as the continent thought it was on the verge of a breakthrough in new aid and fair trade, ActionAid has said.
