|
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=155802
) 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=155766
) 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=155790
) 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=155718
) 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=155704
) as subquery
OneWorld UK
<< Back to organisation profile
Features
03.12.2007
It's Day One of the UN climate change conference in Bali and alread there's good news: "My message is," said Alden Meyer of the Union of Concerned Scientists, "Help is on the way."
Story link
Related topics/regions:
[United States]
Image: President Bush: 'Won't be around when the successor treaty to the Kyoto Protocol on climate change is signed'
03.12.2007
Who do you think should be OneWorld's "Person of 2007"? Maybe it's someone who was working at the grassroots to bring change to their community or their country. Maybe someone working to improve governments' policies towards marginalised people. Or someone who raised issues that others were neglecting.
Story link
03.12.2007
This will be news to the millions, probably billions, who don’t think about climate change or to whom it is unproven conjecture -- but the United Nations conference that started in Bali, Indonesia, this week is not discussing whether climate change is taking place.
Story link
30.11.2007
OneWorld's own social networking space, OneClimate.net, is opening a virtual window on the UN's forthcoming climate conference in Bali, allowing people around the world to participate in the event without emitting carbon through flying to Indonesia.
Story link
Related topics/regions:
[Indonesia]
Image: Climate change: 'The greatest creator of poverty and suffering the world has ever known' (Anuradha Vittachi)
29.11.2007
Kuka kärsii, kun teollisuus pitää hinnat niin korkeina, ettei maailman köyhimmillä ole varaa lääkkeisiin? Köyhien lisäksi teollisuus itse, sanoo kansalaisjärjestö Oxfam. Sen mukaan lääketeollisuus on jo menettänyt investoinneissa jopa biljoonan.
Story link
Image: -
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| < 10 >
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
