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 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=133376
) 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=130707
) as subquery
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?
24.05.2006
For many people, communication facilities are unreliable, slow and costly. A new analysis explores how wireless technology could transform this situation, helps journalists get to grips with the many uses of wireless technologies and asks why governments aren’t doing more to help.
11.04.2006
Women farmers have become a dominant force throughout India, as more and more men migrate to earn money. Yet the slow pace of land and property rights reform has failed to keep up, says Keya Acharya.
