|
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=160225
) 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=160094
) 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=159983
) as subquery
Survival International Italia
E' un'organizzazione mondiale di sostegno ai popoli tribali. Difende il loro diritto a decidere del proprio futuro e li aiuta a proteggere le loro vite, le loro terre e i loro diritti umani.
Main Address
Via Morigi, 8 - 20123 Milano
Main Telephone
0039 02 890 0671
Joined OneWorld
04.01.2005
Features
29.04.2008
A new campaign has been launched targeting British company Vedanta over its plans to mine a sacred mountain in India.
Story link
Related topics/regions:
[United Kingdom]
[India]
24.04.2008
Seven villages belonging to the 'Jumma' tribal were burned to the ground on Sunday by Bengali settlers, with the support of the Bangladesh army, in violence apparently arising from a controversial resettlement programme.
Story link
Related topics/regions:
[Bangladesh]
Image: Village in the Chittagong Hill Tracts
22.04.2008
Tourist lodges requiring large amounts of water are to be built on the land of the Kalahari Bushmen in Botswana – but the Bushmen are not allowed to pump water from their single borehole, says an organisation supporting tribal peoples worldwide.
Story link
Related topics/regions:
[Botswana]
|
|
|
|
