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=160067
) 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=159425
) 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=156293
) 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=155175
) 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=153730
) as subquery
23.04.2008
Small farmers from around the world celebrated last week the International Day of Peasant's Struggle and honored the communities and organizations in over 25 countries that are challenging escalating food costs.
03.04.2008
The 35th anniversary celebration of a Haiti's largest and oldest peasant movement demonstrates the organization's ability to empower rural people and the vitality of grassroots democracy in this Caribbean nation, writes Nikhil Aziz.
19.12.2007
Grassroots International, a OneWorld partner that builds alliances and provides grants to progressive movements worldwide, is one of three finalists for the MySpace Impact Awards. The final vote takes place on Dec. 24.
From: MySpace.com
14.11.2007
An alliance of peasants, indigenous peoples, and rights groups is declaring that U.S.-Mexico free trade in corn is not just about food, lost jobs, and confiscated land -- it is about the very identity of the Mexican people.
02.10.2007
While the two presidential candidates compete for votes in the politically important cities, Guatemala's large but quiet peasant population suffers from poverty, injustice and famine, comments columnist Saulo Araujo.
