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=155768
) 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=153038
) 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=151604
) 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=151042
) 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=150807
) as subquery
01.12.2007
Kent Buse and Fiona Samuels examine how leadership has controlled sexually transmitted infections in the past and ask what new kinds of leadership will be needed to fight HIV and AIDS.
14.09.2007
Sunday is Global Day for Darfur. To read an alternative view of the the type of international action needed to foster peace there, read a posting on the Overseas Development Institute blog.
You can also Stand In for Darfur
+ A glimmer of hope
08.07.2007
The Overseas Development Institute has been named 'Think Tank of the Year 2007' by the UK's leading publication for the public affairs industry, and Friends of the Earth has has won the Chartered Institute of Public Relations Excellence Award for Public Affairs for its climate campaign, The Big Ask.
29.06.2007
UK development groups broadly welcomed the Cabinet changes ushered in by the new Prime Minister, Gordon Brown, as they outlined the areas in which they wanted action.
