|
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=160939
) 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=160420
) 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=160378
) as subquery
Grassroots International
Grassroots International works to create a just and sustainable world by building alliances with progressive movements. We provide grants to our Global South partners and join them in advocating for social change. Our primary focus is on land, water and food as human rights and nourishing the political struggle necessary to achieve these rights.
Main Address
179 Boylston Street, 4th Floor
Jamaica Plain MA 02130
Main Telephone
1-617-524-1400
Joined OneWorld
20.09.2000
Features
24.06.2008
From starting tree nurseries to properly disposing of solid waste, a new guide offers simple solutions to help communities around the planet improve their quality of life.
Story link
07.05.2008
Jesus León Santos, the leader of a democratic farmer-to-farmer network, recently received a prestigious environmental award for promoting sustainability through traditional agriculture in Oaxaca, Mexico.
Story link
Related topics/regions:
[Mexico]
Related links
05.05.2008
Peasants' and other grassroots organizations are promoting change in Haiti, write two agricultural activists who paid a visit to the Caribbean island, where they found food scarcity, environmental damage, and general insecurity are widespread.
Story link
Related topics/regions:
[Haiti]
Related links
|
|
|
|
