|
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=147627
) 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=147625
) 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=147426
) as subquery
Amnesty International USA
Amnesty International is a grassroots activist organization that works on human rights issues.
Main Address
600 Pennsylvania Ave. SE, 5th floor
Washington DC 20003
Main Telephone
202-544-0200
Joined OneWorld
01.08.2001
Features
30.03.2007
The Lao military is using the excuse of a long-concluded war to continue attacks on a destitute population of Hmong jungle-dwellers, says a new human rights report.
Story link
Related topics/regions:
[Laos]
Related links
28.03.2007
Australian David Hicks has been the first Guantanamo detainee to face trial, some five years after his capture. A report released just before Hicks' trial reiterates concerns that the U.S. government-sponsored "military commissions" will not meet international standards of justice.
Story link
Related topics/regions:
[United States]
27.03.2007
A constitutional amendment would give sweeping powers of arrest to Egypt's police, grant broad authority to monitor private communications, and allow the president to bypass ordinary courts and refer terrorism suspects to military and special courts.
Story link
Related topics/regions:
[Egypt]
Related links
|
|
|
|
