|
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=68312
) 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=65651
) 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=65834
) 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=65835
) 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=57302
) as subquery
Mandate the Future
<< Back to organisation profile
Features
18.09.2003
Tens of thousands of people have disappeared from Sri Lanka during decades of conflicts – one by the Liberation Tigers of Tamil Eelam and the other by the Janatha Vimukthi Peramuna. Though the government has investigated many cases, thousands of cases are still to be resolved and convictions have been few.
Related topics/regions:
[Sri Lanka]
Image: Human Rights Watch.
12.08.2003
Chairman of Peace Worldwide, Hector Aleem, writes about the plight of street children in Pakistan's capital city Islamabad, and why they are exploited for labour. Read this interesting and though-provoking article.
Story link
Related topics/regions:
[Pakistan]
[South Asia]
04.07.2003
Resources for activists, advocacy groups, academics and enthusiasts who desire to contribute to the evolution of a global Information Society. The event will be held in Geneva later this year.
Story link
Related topics/regions:
[Switzerland]
[Europe]
01.07.2003
Development research projects use up vast sums of money and do not accomplish much. In this article, the author makes a strong plea for the surveillance of development research funds because recommendations are rarely implemented.
Story link
03.06.2003
There was an improvement in the human rights situation in the context of a cease-fire and peace talks between the government of Sri Lanka and the Liberation Tigers of Tamil Eelam. However, lack of accountability remains a serious concern, says the 2003 annual report of Amnesty International.
Story link
Related topics/regions:
[South Asia]
[Sri Lanka]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| Next >>
|
|
|
|
