|
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=90307
) 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=89944
) 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=85640
) 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=85427
) 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=85369
) as subquery
Human Rights Watch
<< Back to organisation profile
Features
20.07.2004
Sudan government documents incontrovertibly show that government officials directed recruitment, arming and other support to the ethnic militias known as the Janjaweed, Human Rights Watch said today. The government of Sudan has consistently denied recruiting and arming the Janjaweed militias, including during the recent visit of UN Secretary General Kofi Annan.
Human Rights Watch
14.07.2004
Peace in Angola has paved the way for advances in freedom of expression, association and assembly, but in the interior of the country these freedoms continue to be violated, Human Rights Watch says in a report released. On July 2, the president's advisory council recommended holding general elections in 2006, the first since 1992.
Human Rights Watch
Related topics/regions:
[Angola]
08.05.2004
Colombias lawmakers must ensure that any laws passed to foster peace with illegal armed groups guarantee that crimes against humanity are prosecuted, Human Rights Watch said in a speech to the Colombian Congress.
Read more
Related topics/regions:
[Colombia]
05.05.2004
Con la sparizione lo scorso 16 aprile di Carlos Castaņo, il leader politico delle forze paramilitari AUC (Autodifese unite della Colombia) č sempre pių difficile il processo di pace in Colombia. Secondo Amnesty International e Human Rights Watch vi č comunque abbondante evidenza di strette relazioni tra i paramilitari e le forze governative. Intanto gli Usa starebbero preparando la seconda fase del Plan Colombia: un intervento armato multinazionale contro le guerriglie delle FARC e dell'ELN, previsto nel 2004.
Story link
Related topics/regions:
[Colombia]
Image: Carlos Castaņo e il fratello Fidel con parā Auc - da Warnews
05.05.2004
In United States a large number of children are engaged as farm workers. This seemingly harmless occupation is the most hazardous and grueling area of employment open to children. It is also the least protected. "In the fields, the United States is like a developing country" says this Summary of a 2000 Report.
Story link
Related topics/regions:
[United States]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
