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=128916
) 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=128271
) 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=122099
) 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=121400
) 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=120321
) as subquery
08.03.2006
Community radio is so important to Guatemala's rural and indigenous populations that it was specifically protected under the 1996 Peace Accords, but government raids over the past week are threatening the survival of all six of the country's community radio associations.
25.02.2006
Bolivia's new president is pushing for a new body politic that would ensure the representation of the country's two-thirds majority indigenous population. A minimum of one-third of the seats would be held by women too.
14.11.2005
Kenya's new draft constitution--set to be voted on November 21--does not protect indigenous ownership of natural resources or land and neglects the needs of Kenya's ethnic minorities, argue many in the Maasai community.
31.10.2005
The culture and livelihoods of the Gwich'in people, who have lived in the region for 20,000 years, could be destroyed by oil drilling programs proposed for the Arctic National Wildlife Refuge, according to a new report released last week. The U.S. Senate is expected to finalize the plans in early November.
The latest issue of Cultural Survival focuses on Fair Trade & Indigenous Peoples. Articles include: Confessions of a Fair Trader, By A Thread: The Benefits and Challenges of Being a Fair Trade Crafter, FLO Standards for Fair Trade Coffee and more.
