|
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=124691
) 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=124299
) 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=123404
) as subquery
Friends of the Earth Scotland
Part of the world’s largest international environmental network, Friends of the Earth Scotland champions renewable energy, better public transport, cleaner rivers and beaches, and freedom of information, and tackles issues like opencast mining, GM crops, the need for reduction of waste and traffic, and the eradication of fuel poverty.
Main Address
Lamb's House
Burgess Street
Edinburgh EH6 6RD
Main Telephone
44 (0)131 554 9977
Joined OneWorld
30.09.2005
Features
23.12.2005
Some of the proposed changes to Scottish planning law could be a planning disaster for many communities, warns a leading environmental group.
Story link
Related topics/regions:
[United Kingdom]
19.12.2005
Although a face-saving deal was reached on trade issues at the WTO meeting in Hong Kong, the global trade system remains in crisis, warns a leading environment group. The agreement contains proposals that will further threaten the global environment and the livelihoods of the world's poorest people.
Story link
Related topics/regions:
[Hong Kong]
Image: Trade Justice Campaigners © Gabrielle Hamm
06.12.2005
A leading environment group has criticised the Chancellor for failing to take the urgent action needed to tackle climate change and stimulate a low carbon economy in his pre-Budget statement.
Story link
Related topics/regions:
[United Kingdom]
|
|
|
|
