|
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=159028
) 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=158952
) 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=158780
) 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=158478
) 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=157473
) as subquery
Co-op America
<< Back to organisation profile
Features
20.03.2008
Fair Trade flowers are the latest product in the United States to be certifiably produced under fair labor practices and rigorous environmental standards.
Story link
Related topics/regions:
[United States]
[Ecuador]
Related links
18.03.2008
For five generations Dr. Bronner's family business has manufactured organic, fair trade soap. In this interview, David Bronner discusses the company, his proudest moment as a green business owner, and much more.
Story link
Related links
12.03.2008
Environmental sustainability advocates explain the ins and outs of making your residential solar energy system an affordable clean-energy solution using government incentives, future energy savings, net metering, and much more.
Story link
04.03.2008
With the help of Kusikuy -- a fair trade business importing hand-knit sweaters, scarves, and other garments made by artisans in South America -- Brattleboro, Vermont became the second Fair Trade Town in America.
Story link
Related topics/regions:
[Peru]
[Bolivia]
Related links
05.02.2008
An organization promoting economic justice and environmental sustainability lists ten reasons why they believe nuclear power is not a climate solution.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| Next >>
|
|
|
|
