|
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=159781
) 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=151332
) 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=147629
) 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=143473
) 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=143413
) as subquery
Cultural Survival, Inc.
<< Back to organisation profile
Features
15.04.2008
A "megaproject" to integrate infrastructure across South America will likely lead to "poverty, displacement, exposure to diseases, cultural erosion, physical threats, and violent conflicts" for indigenous people in the region, writes Zachary Hurwitz.
Story link
Related topics/regions:
[South America]
17.07.2007
Several African States are attempting to limit indigenous people's rights in a historic UN declaration. A cultural rights group asks for your help in defeating their proposal.
Story link
Related topics/regions:
[Africa]
Related links
30.03.2007
An appeals court has rejected a plan to use treated waste water to make artificial snow for a ski resort in the San Francisco Peaks, which are sacred to 13 indigenous nations in the southwestern United States.
Story link
Related topics/regions:
[United States]
06.12.2006
"This is a very sad time for the world's indigenous peoples," said a human rights group Monday, commenting on the indefinite delay of a declaration that would require protection for indigenous groups worldwide.
Story link
05.12.2006
"This is a very sad time for the world's indigenous peoples," said a human rights group Monday, commenting on the indefinite delay of a declaration that would require protection for indigenous groups worldwide.
Story link
Image: Maasai woman and child. © MADRE
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-23
| Next >>
|
|
|
|
