|
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=160931
) 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=160410
) 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=159451
) as subquery
Co-op America
Co-op America harnesses economic power—the strength of consumers, investors, businesses, and the marketplace—to create a socially just and environmentally sustainable society.
Main Address
Co-op America
1612 K Street NW, 6th floor
Washington DC
Main Telephone
202-872-5332
Joined OneWorld
13.06.2007
Features
23.06.2008
Donate to a non-profit, plant a tree, or make a political statement with new socially responsible credit cards that redirect part of their profits to efforts to improve the community.
Story link
06.05.2008
One of the founders of bambu, a fair trade business making houseware from organic bamboo and other renewable materials, talks about his company's sustainable journey and the green business movement.
Story link
Related topics/regions:
[China]
Related links
04.04.2008
For eight years Yeumei Shon's local, organic cotton clothing business has been promoting environmental responsibility, agricultural sustainability, and the eradication of dangerous pesticides.
Story link
Related topics/regions:
[United States]
|
|
|
|
