|
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=160950
) 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=160872
) 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=160807
) as subquery
Amnesty International - International Secretariat
Amnesty International is a worldwide campaigning movement that works to promote all the human rights enshrined in the Universal Declaration of Human Rights and other international standards.
Main Address
1 Easton St
London
WC1X 0DW
Main Telephone
44 (0)20 7413 5500
Joined OneWorld
25.08.1998
Features
24.06.2008
European governments are dodging the truth about the U.S. practice of kidnapping and illegally sending terrorism suspects for interrogation in countries with a reputation for torture, a leading rights group says in a new report.
Story link
Related topics/regions:
[Europe]
[United States]
13.06.2008
The UK's House of Commons voted this Wednesday to extend the period for which terrorist suspects can be jailed without charge from four to six weeks, in what human rights advocates warn is an erosion of civil liberties.
Story link
Related topics/regions:
[United Kingdom]
Related links
06.06.2008
The Wednesday detention of Zimbabwe opposition leader Morgan Tsvangirai has elicited strong criticism from human rights advocates who warn it is part of "a sudden, sharp and dangerous crackdown on political opposition in the run-up to the elections."
Story link
Related topics/regions:
[Zimbabwe]
Related links
|
|
|
|
