|
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=140064
) 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=140058
) 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=139521
) 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=139500
) 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=134841
) as subquery
Cultural Survival, Inc.
<< Back to organisation profile
Features
28.09.2006
In a ground-breaking decision being called a cultural and legal victory for indigenous people, the Noongar people have won their claim over an area of 2,300 square miles, including offshore islands and the city of Perth.
Story link
28.09.2006
In a ground-breaking decision being called a cultural and legal victory for indigenous people, the Noongar people have won their claim over an area of 2,300 square miles, including offshore islands and the city of Perth.
Story link
Related topics/regions:
[Australia]
18.09.2006
While a UN committee focused largely on issues relating to torture and terrorism in its review U.S. human rights compliance, it also made time to censure the world's superpower for its stealing of Native American land and loss of their money.
Story link
18.09.2006
While a UN committee focused largely on issues relating to torture and terrorism in its review U.S. human rights compliance, it also made time to censure the world's superpower for its stealing of Native American land and loss of their money.
Story link
Related topics/regions:
[United States]
14.06.2006
The new United Nations Human Rights Council, which starts work on 19 June, has been urged to put indigenous rights on its agenda.
Story link
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-23
| Next >>
|
|
|
|
