|
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=160294
) 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=160318
) 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=160245
) as subquery
Friends of the Earth England, Wales and Northern Ireland
Friends of the Earth is the largest international network of environmental groups in the world; one of the leading environmental pressure groups in the UK; a unique network of campaigning local groups, working in more than 200 communities in England, Wales and Northern Ireland.
Main Address
26-28 Underwood St
London
N1 7JQ
Main Telephone
020 7490 1555
Joined OneWorld
01.06.1997
Features
02.05.2008
The Energy Bill being debated by parliament needs to be amended to guarantee a premium payment - known as 'feed-in tariffs' - for all the green energy generated by householders, businesses and local communities, says Friends of the Earth.
Story link
Related topics/regions:
[United Kingdom]
01.05.2008
a British court has ordered the government to disclose previously secret records of lobbying by the Confederation of British Industry, following a court case won by an environmental campaign group.
Story link
Related topics/regions:
[United Kingdom]
30.04.2008
Pop star Lily Allen is backing a campaign to boost green energy in homes and businesses around Britain.
Story link
Related topics/regions:
[United Kingdom]
|
|
|
|
