|
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=155993
) 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=155854
) 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=155663
) 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=155301
) 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=155120
) as subquery
United Nations
<< Back to organisation profile
Features
10.12.2007
Environmental sustainability projects have generated millions of new "green collar" jobs around the world, and there is a potential for many more to come, according to a UN Environmental Programme report.
Story link
Related links
05.12.2007
Although primary school attendance, girls' enrollment, and academic funding have all skyrocketed in the last decade, one in five adults around the world still lack basic literacy skills, says a UN report.
Story link
Related links
29.11.2007
Hundreds of millions of people around the world have rolled up their sleeves and gotten their hands dirty to promote a greener earth and to show their support for next month's international climate change conference in Bali.
Story link
Related links
19.11.2007
Rising food prices, climate change, and population growth could severely affect sub-Saharan Africans in the coming years, warned the World Food Program's director, offering "solutions to help people adapt before it is too late."
Story link
Related topics/regions:
[Africa]
Related links
13.11.2007
United Nations Secretary-General Ban Ki-moon, during his historic visit to Antarctica, has said warming temperatures on the continent show the growing dangers of climate change and the need for action to address it.
Story link
Image: Antarctic ice sheet © British Antarctic Survey
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
