|
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=160874
) 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=160471
) 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=159876
) as subquery
Global Exchange
Global Exchange is a human rights organization dedicated to promoting environmental, political, and social justice around the world.
Main Address
2017 Mission Street, #303
San Francisco CA 94110
Main Telephone
01-415-255-7296
Joined OneWorld
30.04.2001
Features
13.06.2008
A group of South African women support their families by making recycled bottles into bead necklaces. The artisans -- and the steps they take to produce their crafts -- are featured in this slide show.
Story link
Related topics/regions:
[South Africa]
Related links
08.05.2008
Innovative local initiatives are strengthening rural regions throughout Mexico, which have been losing both people and their competitive edge in agriculture since Mexico opened its markets to free trade.
Story link
Related topics/regions:
[Mexico]
Related links
17.04.2008
While Darfur and Tibet activists took center stage as the Olympic torch passed through North America last week, anti-sweatshop advocates were also protesting against labor practices in Chinese factories making official Olympics garb.
Story link
Related topics/regions:
[China]
[United States]
Image: The protest was part of 'Play Fair,' a major international campaign pushing for respect for workers' rights in the global sportswear industry. © fairolympics.org
Related links
|
|
|
|
