|
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=160953
) 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=160734
) 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=158739
) as subquery
Asian Human Rights Commission
AHRC is an independent non-governmental body promoting greater awareness and realization of human rights in the Asian region.
Main Address
Asian Human Rights Commission
19/F, Go-Up Commercial Building,
998 Canton Road, Kowloon, Hong Kong, China
Main Telephone
852-2698 6339
Joined OneWorld
19.11.1999
Features
25.06.2008
To commemorate the birthday of former Prime Minister Benazir Bhutto, the Pakistani government is recommending President Musharraf commute the death sentences of more than 7,000 prisoners to life imprisonment.
Story link
Related topics/regions:
[Pakistan]
29.05.2008
The new Pakistani coalition government has "broken" a key election promise by failing to reinstate the deposed judges after taking power two months ago, says the Asian Human Rights Commission.
Story link
Related topics/regions:
[Pakistan]
Image: Nawaz Sharif's party broke away from the new governing coalition to protest the lag in reinstating the judges. © Radio Netherlands WereldomroepRelated links
12.03.2008
The Asian Human Rights Commission has asked the UN Rapporteur on Torture to help end the detention and alleged torture of a number of uncharged Sri Lankan journalists.
Story link
Related topics/regions:
[Sri Lanka]
|
|
|
|
