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=150652
) 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=150650
) 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=149603
) 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=149489
) 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=149013
) as subquery
26.06.2007
More than 70,000 music fans signalled their commitment to action on climate change at this year's Glastonbury festival by signing up to the UK's "I Count" campaign against climate chaos.
26.06.2007
More than 70,000 music fans signalled their commitment to action on climate change at this year's Glastonbury festival by signing up to the UK's I Count campaign to stop climate chaos.
24.05.2007
The UK government's new Energy White Paper is a huge missed opportunity and should have set out tougher polices on energy efficiency, renewable power and cleaner transport, said Friends of the Earth. Greenpeace joined the backlash with a statement setting out why it believes Tony Blair is wrong about nuclear power.
09.05.2007
Greenpeace, Friends of the Earth, WWF, the RSPB and enoughsenough.org have taken ads in several national papers to warn the government about the environmental risks of biofuels as an alternative to petrol and diesel.
