|
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=155491
) 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=155022
) 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=155021
) 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=154585
) 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=154583
) as subquery
Inter Press Service
<< Back to organisation profile
Features
23.11.2007
Total greenhouse gas emissions of 40 industrialised countries rose to a near all-time high in 2005, but the Kyoto Protocol will still exceed its reduction targets, says a United Nations agency in a pre-Bali assessment.
Story link
Image: Support for the Kyoto Protocol © World Wide Fund for Nature (UK)
09.11.2007
The world's richest countries must drastically reduce greenhouse gas emissions to mitigate climate change impacts, says a United Nations report, due for release later this month.
Story link
09.11.2007
The world's richest countries must drastically reduce greenhouse gas emissions to mitigate climate change impacts, says a United Nations report, due for release later this month.
Story link
29.10.2007
"By not acting soon enough, we won't have the resources to do more than keep our heads above water," says climate scientist.
Story link
Image: Climate Alarm
29.10.2007
"By not acting soon enough, we won't have the resources to do more than keep our heads above water," says climate scientist.
Story link
Image: Climate Alarm
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| < 9 >
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
