
|

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=160735
) 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=160545
) 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=160056
) 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=159769
) 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=159345
) as subquery
Amnesty International - International Secretariat
<< Back to organisation profile
Features
29.05.2008
International leaders including China, Russia, and the United States must apologize for "decades" of injustices and lead a global, unified effort to revitalize human rights, says Amnesty International's annual report
Story link
Related topics/regions:
[Europe]
[China]
[Russian Federation]
[United States]
14.05.2008
Asian governments -- seen to have greater leverage with Myanmar authorities -- are being asked to increase the pressure on the military junta to effectively address the humanitarian crisis caused by Cyclone Nargis.
Story link
Related topics/regions:
[Myanmar]
[South East Asia]
[East Asia]
Related links
02.04.2008
The Jamaican authorities are wilfully neglecting the poorest communities by failing to tackle inner-city violence, says a new Amnesty report that spotlights abusive policing methods that lead to hundreds of fatal shootings and extrajudicial executions.
Story link
Related topics/regions:
[Jamaica]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
 |


|
 |