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=136313
) 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=135991
) 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=135961
) 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=134874
) 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=134134
) as subquery
12.07.2006Early this morning, Greenpeace volunteers climbed to the top of Admiralty Arch in London - currently under renovation - and unfurled a banner that read, "Repeat offender! Blair's trashed another rainforest!", while other volunteers attempted to remove some of the offending plywood containing hardwoods from the rainforests of Papua New Guinea.
06.07.2006
A nuclear expert has called for nuclear reactors in the UK to be immediately shut down after secret documents written by government inspectors revealed they contain structural defects.
05.07.2006
A nuclear expert has called for nuclear reactors in the UK to be immediately shut down after secret documents written by government inspectors revealed they contain structural defects.
16.06.2006
The UK throws away two thirds of the energy it generates in its nuclear, coal and gas fuelled power plants - that's enough to meet the whole country's heating and hot water needs. What are we waiting for? – a new film by Greenpeace - explains exactly how decentralised energy could help the UK beat climate change.
07.06.2006
Radioactive champagne, near nuclear meltdowns, leaked terrorism documents and a nuclear waste train crash... In the same month that Tony Blair announced nuclear power was 'back on the agenda with a vengeance', events in the real world put the lie to nuclear industry spin, says Greenpeace.
Greenpeace activist exposes nuclear threat
