|
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=158084
) 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=153488
) 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=153489
) as subquery
Amnesty International UK
Amnesty International UK is the UK section of Amnesty International, the worldwide voluntary movement of people campaigning for human rights.
Main Address
Amnesty International, U.K. Section
99-119 Roseberry Avenue
London
EC1R 4RE
Main Telephone
02070331500
Joined OneWorld
22.06.2006
Features
21.02.2008
The Uganda government has struck a deal with the rebel Lord's Resistance Army about where their leaders will be tried.
Story link
Related topics/regions:
[Uganda]
Image: Man released from rebel captivity
25.09.2007
The Iraqi refugee crisis is reaching breaking point, with help from the international community "seriously inadequate", says a new Amnesty International report.
Story link
Related topics/regions:
[Iraq]
[United Kingdom]
Related links
25.09.2007
To celebrate the launch of Amnesty's campaign, Unsubscribe, Amnesty is inviting bloggers, second lifers, social networkers, activists and anyone with an interest in changing the way the world is changed to an evening of wine, smoothies and stimulating speakers in a two-way conversation.
Story link
Related topics/regions:
[United Kingdom]
|
|
|
|
