|
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=155784
) 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=155786
) 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=155521
) 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=155520
) 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=155492
) as subquery
Inter Press Service
<< Back to organisation profile
Features
03.12.2007
During the Bali conference, Latin American governments will call for industrialised countries to provide financial support for developing countries to deal with the effects of climate change.
Story link
Related topics/regions:
[Latin America & Caribbean]
03.12.2007
During the Bali conference, Latin American governments will call for industrialised countries to provide financial support for developing countries to deal with the effects of climate change.
Story link
24.11.2007
This was the basic question underlying the United Nations' new Human Development Report which points to rich nations' responsibility in fighting climate change.
Story link
Image: What will climate change mean for her? © Josh Estey/CARE 2001 / CARE USA
24.11.2007
This was the basic question underlying the United Nations' new Human Development Report which points to rich nations' responsibility in fighting climate change.
Story link
Image: What will climate change mean for her? © Josh Estey/CARE 2001 / CARE USA
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)
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| < 8 >
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
