|
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=148127
) 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=147245
) 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=147281
) as subquery
Survival International
Survival is a worldwide organisation supporting tribal peoples, helping them protect their lives, lands and human rights.
Main Address
6 Charterhouse Buildings
London
EC1M 7ET
Main Telephone
00 44 20 7687 8700
Joined OneWorld
07.09.1999
Features
12.04.2007
For a second time, Malaysian police in Sarawak have dismantled a blockade set up by members of the Penan tribe to protect their rainforest land from logging by Malaysian company Samling.
Story link
Related topics/regions:
[Malaysia]
23.03.2007
India must close a highway running through Jarawa lands, or the Andaman Island tribe may be wiped out, a UN report warns.
Story link
Related topics/regions:
[India]
Related links
19.03.2007
Only months after a High Court ruling enabled Botswana Bushmen to return to land from which they had been evicted, the government has turned down their request for permission to install a pump at an existing borehole. A leader of the community is travelling to London this week to protest against the ban.
Story link
Related topics/regions:
[Botswana]
|
|
|
|
