|
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=159378
) 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=159377
) 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=158861
) 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=158860
) 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=158403
) as subquery
Inter Press Service
<< Back to organisation profile
Features
03.04.2008
Our fingers are glued to the global thermostat, pushing it ever higher, and climate catastrophe has already begun to reshape human civilisation. Stephen Leahy looks at what the science is telling us.
Story link
Image: Getting hotter
03.04.2008
Our fingers are glued to the global thermostat, pushing it ever higher, and climate catastrophe has already begun to reshape human civilisation. Stephen Leahy looks at what the science is telling us.
Story link
Image: Getting hotter
16.03.2008
A year after the European Union's governments promised to take the lead in fighting climate change, they appeared to back-pedal on that pledge at a summit in Brussels March 13-14.
Story link
Image: Javier Solana warned that global warming carries great potential for conflict
16.03.2008
A year after the European Union's governments promised to take the lead in fighting climate change, they appeared to back-pedal on that pledge at a summit in Brussels March 13-14.
Story link
Related topics/regions:
[Europe]
Image: Javier Solana warned that global warming carries great potential for conflict
03.03.2008
Ecuador has taken the first step towards ending the oil dependence of its Galápagos Islands, in the eastern Pacific Ocean, with the official opening of a 10.8 million dollar wind energy facility on the island of San Cristóbal.
Story link
Image: Fifty percent of the island's energy now comes from the three 800 kilowatt turbines © Worldwatch Institute
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
