|
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=156069
) 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=156071
) 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=155571
) 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=155569
) 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=151867
) as subquery
Friends of the Earth International
<< Back to organisation profile
Features
12.12.2007
Peoples from all over the globe have taken part in the Solidarity Village for a Cool Planet initiative. Their aim? To build real answers to climate change and expose false solutions.
Story link
Related topics/regions:
[Indonesia]
12.12.2007
Peoples from all over the globe have taken part in the Solidarity Village for a Cool Planet initiative. Their aim? To build real answers to climate change and expose false solutions.
Story link
28.11.2007
A new report provides nine testimonies from people around the world who have dramatic first-hand experience of the devastating impacts of climate change.
Story link
Image: Jacabamba Glacier, Peru, in 1980 (left) and 2002 (right) © Lynas
28.11.2007
A new report provides nine testimonies from people around the world who have dramatic first-hand experience of the devastating impacts of climate change. (PDF document)
Story link
Image: Jacabamba Glacier, Peru, in 1980 (left) and 2002 (right) © Lynas
02.08.2007
An international coalition of consumer, public health, environmental, labor, and civil society organizations spanning six continents has called for strong, comprehensive oversight of nanotechnology and its products.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-29
| Next >>
|
|
|
|
