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=50294
) 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=50229
) 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=50433
) 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=50415
) 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=50247
) as subquery
24.02.2003
Sixteen of Kenya's 42 languages are at risk of disappearing, taking with them the rich cultural and historical knowledge of the minority ethnic groups who speak them. Are we heading towards a homogeneous world where everyone thinks, speaks, and acts the same, asks Kenyan linguist Kiplangat Cheruiyot.
03.02.2003
The conflict between ChevronTexaco and an indigenous group in Ecuador struggling to maintain control over their traditional lands has intensified over the past month, with reports of company-sponsored attacks, intimidation and disinformation designed to break up the community.
03.02.2003
Cultural Survival's free email digest provides the latest, under-reported stories from the perspective of indigenous communities worldwide. To subscribe, email joinweekly_indigenous_news@lyris.cs.org. For more information or to submit stories, contact Jon Mingle, jon@cs.org.
03.02.2003
This conference, hosted at Harvard University, invites grassroots leaders from around the world to share their skills, successes, and struggles in international development and community organizing. For more information, contact Kate Botham,
kate@bridgebuilding.orgor (617)620-6293.
29.01.2003
A new deal with the U.S.-based mining firm Alcoa has been hailed as "a huge development" by Suriname's Natural Resources Minister, but indigenous communities--who were never consulted about the deal--believe it will lead to increased exploitation of their land.
