|
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=159144
) 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=158154
) 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=158006
) as subquery
Environment News Service (ENS)
The Environment News Service (ENS) is the original daily international independent wire service of the environment.
Main Address
1415 South Penaye Way
Las Vegas Nevada 89117
Main Telephone
702-889-0247
Joined OneWorld
05.11.2002
Features
25.03.2008
Reducing output of black carbon -- a particulate matter recently found to have an atmospheric warming effect three to four times greater than previous estimates -- "would have immediate societal benefits in addition to the long-term effect of reducing greenhouse gas emissions," say scientists.
Story link
Image: Pollution in New Jersey, United States. © Jeffrey Allen
Related links
22.02.2008
The emergence of deadly diseases has increased fourfold over the last 50 years as humans are increasingly moving into "shrinking pockets of biodiversity" where they come into contact with wild animals carrying fatal pathogens, say scientists.
Story link
Image: © World Wide Fund for Nature
19.02.2008
Project BudBurst allows regular people across the United States to partake in a national effort to track the effects of climate change by entering their observations of plants budding and flowers blooming in an online database.
Story link
Related topics/regions:
[United States]
Image: © American University Trade Environment Database/Environment News Service (ENS)
Related links
|
|
|
|
