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=155967
) 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=155484
) 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=152553
) 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=151807
) 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=151630
) as subquery
07.12.2007
Who is the biggest NGO a the climate change talks in Bali? Is it Greenpeace? Is it WWF? The International Chamber of Commerce? It's the lobbying group, International Emissions Trading Association.
22.11.2007Flights from Heathrow’s third runway will emit the same amount of CO2 as Kenya, says a development lobby group as the government launches a consultation process on the runway.
24.08.2007Resistance is alive and kicking, but we rarely hear about it. Around the World in 80 protests attempts to redress the balance: a website that highlights struggles against corporate globalisation that don’t get covered in the mainstream news.
25.07.2007
"The events of this summer must act as a wake up call: climate change is real and is happening in our back garden... They give us a glimpse as to what the future holds for countries like Bangladesh," said the director of a global humanitarian group calling for a massive cut in CO2 emissions.
