|
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=155885
) 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=155871
) 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=155849
) 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=155829
) 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=155843
) as subquery
OneWorld UK
<< Back to organisation profile
Features
05.12.2007
Saudi Arabia was given the Fossil of the Day Award by NGOs at the climate change conference in Bali, Indonesia, on Wednesday.
Story link
Related topics/regions:
[Europe]
[Japan]
[Saudi Arabia]
05.12.2007
When Yvo de Boer, executive secretary of the UN Framework Convention on Climate Change, told participants at a climate change meeting in Bali this week that the countries of the world "are on a first date here," he didn't realise that his joke would come back to haunt him.
Story link
05.12.2007
Japan won the 'extremely-opposite-of-prestigious" Fossil of the Day Award at the climate change negotiations in Bali, Indonesia, today.
Story link
Related topics/regions:
[Iran]
04.12.2007
Does Japan want to scrap the international agreement on climate change, the world's biggest climate action NGO network asked at the start of the second day of United Nations negotiations on a programme to tackle global warming.
Story link
Related topics/regions:
[United States]
[Singapore]
[Saudi Arabia]
04.12.2007
Haluaako Japani romuttaa kansainvälisen ilmastosopimuksen, kyselivät useat kansalaisjärjestöt Balin kokouksen toisena päivänä. Niiden mukaan Japani ei ole suostunut puhumaan sitovista päästötavoitteista.
Story link
Related topics/regions:
[Japan]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| < 9 >
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
