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=152249
) 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=150771
) 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 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=150521
) 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=149104
) as subquery
15.08.2007
Heidi Thorsen reflects on why helping communities rebuild after the tsunami is about more than just building houses, and asks what it really means to be someone's neighbour.
01.07.2007
CAFOD is urging supporters to take action against Argos and Goldsmiths because they are falling behind other jewellers in their response to the Unearth Justice campaign.
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.
26.06.2007
A new United Nations institution created to help countries emerging from war will fail unless it addresses key challenges, says a report issued today by three non-governmental agencies.
11.05.2007
As the British Prime Minister announces his departure from Downing Street (27 June), attention turns to his legacy and his successor. Both Tony Blair and Gordon Brown have emphasised their commitment to fighting global poverty - but has the reality matched the rhetoric?
+ Blair's legacy: generosity - not justice
