|
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=157927
) 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=157924
) 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=156960
) 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=156959
) 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=156759
) as subquery
International Institute for Environment and Development
<< Back to organisation profile
Features
18.02.2008
UN-led efforts to address climate change, conserve biodiversity and fight poverty could cancel each other out unless the close links between these global challenges are given more attention, says a paper published today by the International Institute for Environment and Development.
Story link
Image: Biodiversity has a key role to play in tackling poverty and climate change
18.02.2008
UN-led efforts to address climate change, conserve biodiversity and fight poverty could cancel each other out unless the close links between these global challenges are given more attention, says a paper published today by the International Institute for Environment and Development.
Story link
Image: Biodiversity has a key role to play in tackling poverty and climate change
21.01.2008
Governments must agree international rules that would give indigenous communities access to genetic resources to help them fight poverty, preserve biodiversity and adapt to climate change, says a report released today.
Story link
Image: Peru, home to the International Potato Institute and a centre of potato diversity
21.01.2008
Governments must agree international rules that would give indigenous communities access to genetic resources to help them fight poverty, preserve biodiversity and adapt to climate change, says a report released today.
Story link
Image: Peru, home to the International Potato Institute and a centre of potato diversity
11.01.2008
Kenyan slum dwellers whose homes and livelihoods were destroyed in recent violence are calling for international help to support their local peace initiatives and plans to rebuild the devastated communities.
Story link
Related topics/regions:
[Kenya]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-12
| Next >>
|
|
|
|
