|
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=154447
) 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=118116
) 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=116425
) as subquery
Network for New Energy Choices
Network for New Energy Choices (NNEC), a New York-based nonprofit launched in 2006, provides state and local governments with ideas and information on how to generate clean power from local, renewable energy resources.
Main Address
215 Lexington Ave. Suite 1001
New York, NY 10016
Main Telephone
(212) 726-9161
Joined OneWorld
14.01.2006
Features
24.10.2007
Is ethanol a green fuel? Will ethanol revitalize rural America? Advocates for environmentally sustainable energy choices debunk six myths about the fuel -- often made from corn -- that has been upheld by some as a panacea for global warming.
Story link
Related topics/regions:
[United States]
Related links
01.09.2005
Abolition 2000, a global network of disarmament groups on Monday called on the U.N. and world leaders to avoid the mistakes made at the May Non-Proliferation Treaty Review Conference and take advantage of the U.N. Millennium Summit to end the global threat of nuclear weapons.
Story link
04.08.2005
In May 2000, the nuclear weapons states agreed to an "unequivocal undertaking" to eliminate nuclear weapons, yet even now, tens of thousands of nuclear weapons still threaten the survival of humanity. You can add your signature to the petition calling for that vision to become a reality.
Story link
Related links
|
|
|
|
