|
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=134665
) 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=134712
) 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=134478
) 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=134432
) 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=131060
) as subquery
Cultural Survival, Inc.
<< Back to organisation profile
Features
13.06.2006
"If you do not have a cow, you have no respect, no voice in the community." Lisa Matthews talks to a people coping with a devastating drought.
Story link
Related topics/regions:
[Kenya]
13.06.2006
Over 30 years after first approaching the federal government for official acknowledgement as an Indian tribe, the Mashpee Wampanoag tribe of Cape Cod, Massachusetts has finally received recognition.
Story link
Related topics/regions:
[United States]
Image: Said one tribe member, “For me and my family recognition stands for education, health care, and housing.” © Jamie Brown / Cultural Survival, Inc.
09.06.2006
South Africa and New Zealand must do more, more quickly, to tackle inequalities between their indigenous and non-indigenous populations, according to two recently released UN reports.
Story link
08.06.2006
South Africa and New Zealand must do more, more quickly, to tackle inequalities between their indigenous and non-indigenous populations, according to two recently released UN reports.
Story link
Related topics/regions:
[South Africa]
[New Zealand]
17.04.2006
A potato patent disrespects and disregards "thousands of years of careful selection and breeding by indigenous peoples and local communities around the world" and could unwillingly make indigenous farmers dependent on the Swiss Syngenta company for seeds and fertilizer, say 40 leaders from potato growing communities in the Andes.
Story link
Related topics/regions:
[South America]
<< Previous
| 1
| 2
| 3
| < 4 >
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-23
| Next >>
|
|
|
|
