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=135297
) 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=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=134586
) 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=131785
) 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=129582
) as subquery
21.06.2006
Bianca Jagger, Oscar Olivera and Benedict Southworth on tackling the global water crisis, plus the big debate: privatisation or public control? World Development Movement conference, London, 8 July.
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.06.2006
Back Ghana or Sweden in the World Cup, says a new website that ranks countries on 10 "supportability" criteria, including Third World debt, life expectancy, aid generosity, contribution to climate change, corruption and military spending. The US gets the biggest boo, ranked last in the list.
