|
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=137940
) 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=135926
) 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=135694
) as subquery
Environmental News Network
Telephone numbers
No telephones
Joined OneWorld
05.11.2002
Features
17.08.2006
"If people don't get it, then they don't really care, so politicians and CEOs don't really care, and status quo rules the day. And blindly we march into the sunset." So if you do 'get it', tell your friends who probably don't, says David Suzuki.
Story link
05.07.2006
Caribbean Sea temperatures have reached their annual high two months ahead of schedule -- a sign coral reefs may suffer the same widespread damage as last year, scientists said.
Story link
Related topics/regions:
[Latin America & Caribbean]
28.06.2006
Antarctic Treaty countries failed to agree on tighter environmental measures to protect the continent amid a boom in tourism.
Story link
|
|
|
|
