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=134872
) 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=116918
) 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=113994
) as subquery
Ecologist
Founded in 1970, The Ecologist is the world's most widely read environmental magazine. Published in four continents, it is read by over 200,000 people in 150 countries. The Ecologist has been a key player in major environmental campaigns and has helped set environmental and political agendas across the world.
15.06.2006
from Ecologist:
You can watch the football and also behave in an ecologically sound manner, thanks to a new website called ‘Who should I cheer for?’
* Who should I cheer for?
11.08.2005
INVITO all’INCONTRO NAZIONALE
DOV’È L’ECOLOGIA NEI PROGRAMMI DI GOVERNO?
L’ECOLOGIA GUIDI L’ECONOMIA
CONTRIBUTI AD UN PROGRAMMA POLITICO
CHE METTA L’ECOLOGIA TRA I VALORI FONDAMENTALI
24.06.2005
The thought of Sports Utility Vehicles (SUVs) is enough to spoil the weekend for most OneWorld readers. SUV owners feel much the same about the criticism they incur. The two sides shape up in this debate.
