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=109131
) 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=108373
) 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=107577
) 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=107427
) 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=104143
) as subquery
11.04.2005
A council has been formed to represent the indigenous population of Sakhalin island in Russia's far east in negotiations with government authorities and companies planning to wratchet up oil exploration on the island. The indigenous leaders are calling on the companies to launch a fund to support community development and do a servey to determine how the new activity will affect local people.
25.03.2005
A Canadian-based mining company that used "trickery [and] coercion" to buy up land in the towns of San Miguel Ixtahuacán and Sipakapa is imposing on the rights of indigenous communities, say local human rights groups, and causing social unrest. A Mayan man was killed after a heated dispute with mine workers on his land last week.
The latest issue of Cultural Survival focuses on indigenous peoples and violent conflict. It includes articles on peace-building initiatives, inter-community conflicts, ethnic conflict and more.
11.03.2005
Two of Kenya's prominent ethnic groups--the Maasai and the Kikuyu--continue to battle over use of water from the Ewaso Kedong River. At least 14 have been killed and hundreds forced to flee since the fighting began in late January.
03.03.2005
The poorest Indian communities with the weakest infrastructure are being left behind by the President's proposed budget, which drastically cuts programs specific to Indian students, say many tribal representatives.
