|
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=156124
) 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=156099
) 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=156064
) 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=156042
) 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=156052
) as subquery
OneWorld UK
<< Back to organisation profile
Features
13.12.2007
Brittiakateemikko ja aktivisti George Monbiotilla on ratkaisu ilmastonmuutoksen uhkaan. Nykyisin yritetään vähentää energian kysyntää - ennemmin pitäisi vähentää fossiilisten polttoaineiden tarjontaa, Monbiot kirjoittaa.
Story link
Image: George Monbiot © Gabrielle Hamm
12.12.2007
African countries at the UN climate change conference in Indonesia today gave a bleak view of the talks, which have only two days in which to complete agreement.
Story link
Related topics/regions:
[Africa]
11.12.2007
Congressman Edward Markey (D-Mass.), Chairman of the Select Committee on Energy Independence and Global Warming, has linked up with OneWorld.net’s 'Virtual Bali' initiative to participate in the UN’s climate change negotiations currently underway in Bali, Indonesia. LIVE TUESDAY, 11th December, at 8:30 PM EST.
Story link
Related topics/regions:
[Indonesia]
[United States]
11.12.2007
The 10th anniversary of the Kyoto Protocol today – which requires industrialised countries to reduce their greenhouse gas emissions by at least five per cent from the 1990 level – was marked by a warning that the treaty is under threat at the UN climate change negotiations in Bali, Indonesia.
Story link
Related topics/regions:
[United States]
[Japan]
[Indonesia]
[Canada]
[Australia]
Image: Kyoto Protocol demonstration
11.12.2007
A prominent US Congressman links up with OneWorld.net’s Virtual Bali initiative to take part in the UN climate change negotiations in Bali, Indonesia - without spewing out carbon.
Story link
Related topics/regions:
[United States]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| < 7 >
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
