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=152961
) 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=150410
) 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=145270
) 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=134540
) 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=133991
) as subquery
20.06.2007
"Drought is serious now... disease spreads; children fall ill, people can’t be well-nourished; living becomes expensive; the price of animals falls. There is nothing good about desertification". Chuqulisa tells her story.
22.01.2007
An exhibition in St Paul's Cathedral (which costs £9.50 to enter) documents the ordinary lives and everyday locations caught up in trafficking and calls for end to this 21st century trade, London, 21 February-29 March.
* Breaking the Chains - Eliminating Slavery, Ending Poverty
09.06.2006
While the Doha talks on a new global trade deal in the World Trade Organization (WTO) have sparked tensions between governments, the real impact will ultimately be on the lives of ordinary people.
01.06.2006
How well are Bangladesh, Ethiopia, Haiti, Latvia, Malawi, Pakistan and Sri Lanka implementing UN-agreed commitments on HIV/AIDS? A new analysis raises several areas of concern.
* Antiretroviral drugs for all?
