|
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=156903
) 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=155867
) 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=154732
) as subquery
CAFOD
CAFOD is one of the UK's leading development and relief organisations. We work in partnership with organisations in Africa, Asia and the Pacific, Latin America, the Caribbean and Eastern Europe.
Main Address
CAFOD
Romero Close
Stockwell
London SW9 9TY
UK
External phone number
020 7326 5693
Main Telephone
0207 733 7900
Joined OneWorld
25.05.2001
Features
17.01.2008
CAFOD says its livesimply campaign has reached a landmark with its 2,000th promise online - from someone promising to eat less chocolate, if 30 other people join in. Money saved through the campaign goes to charity.
Story link
Related topics/regions:
[United Kingdom]
05.12.2007
Meet baby Sidr, born during the cyclone bearing her name which battered Bangladesh, and saved by a cyclone shelter.
Story link
Related topics/regions:
[Bangladesh]
01.11.2007
Right now jewellery industry bosses are working out how to end the sale of dirty gold. Make sure they know you're watching - and waiting for results.
Story link
Related topics/regions:
[United Kingdom]
|
|
|
|
