|
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=154765
) 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=154717
) 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=154682
) 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=154577
) 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=154408
) as subquery
United Nations
<< Back to organisation profile
Features
02.11.2007
Given that more than 40 percent of the world's population lacks access to toilets and other sanitation facilities, a UN office specializing in housing has urged governments to adopt low-cost technology to ensure adequate sanitation for all.
Story link
Image: While the world has made significant progress in improving people’s access to safe water, access to improved sanitation “lags far behind.” © Paul Vernon / Corporate Watch
01.11.2007
Somali officials have dealt with a governance crisis with "a conciliatory tone and spirit," said the UN, as a humanitarian crisis grips the violence-wracked capital of Mogadishu.
Story link
Related topics/regions:
[Somalia]
Image: A Somali family displaced by the prolonged fighting. © Manoocher Deghati/IRIN
Related links
31.10.2007
Help the United Nations' World Food Program avert a food crisis on an island in the Indian Ocean in this exiting and informative online video game.
Story link
27.10.2007
The UN Children's Fund has criticised an attempt to separate more than 100 young Chadian children from their parents and take them to France for adoption as “illegal and totally irresponsible".
Story link
Related topics/regions:
[France]
[Chad]
23.10.2007
Migrants sent home over an estimated $300 billion last year, exceeding total official development assistance and foreign direct investment to developing countries, a UN study found.
Story link
Related links
<< Previous
| 1
| 2
| 3
| < 4 >
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
