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=158119
) 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=154059
) 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=153833
) 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=151858
) 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=147831
) as subquery
22.02.2008
Concerned Americans are adding their voices to a new campaign urging presidential candidates to not only address climate change, but to provide specifics -- including how they plan to help developing nations cope with human-caused climate change.
11.10.2007
A 40-day nationwide fast for debt cancellation has secured a U.S. legislative hearing on the Jubilee Act, which would cancel the debts of up to an additional 25 developing countries that spend a daily average of $100 million on debt service alone.
04.10.2007
Zambian activist Muyatwa Sitali explains how his nation's debt, which is over $700 per person, burdens the country and hinders well-meaning efforts to solve the problem of poverty.
02.08.2007
"Must we starve our children to pay our debts?" asks Julius Nyerere, former president of Tanzania. A faith-based group is urging the U.S. Congress to expand debt cancellation, and they want your help...on a paper plate.
Learn about debt and economic justice issues at Jubilee USA's second annual conference in Chicago. It will include speakers from the Global South, skill-building sessions and workshops for activists.