|
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 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=140722
) 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=140693
) as subquery
Cultural Survival, Inc.
<< Back to organisation profile
Features
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
12.10.2006
The U.S. Senate will now consider legislation providing for the revitalization of Native American languages most notably through support of Native American language immersion programs.
Story link
11.10.2006
The U.S. Senate will now consider legislation providing for the revitalization of Native American languages most notably through support of Native American language immersion programs.
Story link
Related topics/regions:
[United States]
<< Previous
| 1
| < 2 >
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-23
| Next >>
|
|
|
|
