|
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=151600
) 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=151030
) 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=150813
) 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=150792
) 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=150234
) as subquery
United Nations
<< Back to organisation profile
Features
24.07.2007
The United Nations and Nepal's Maoists have agreed to resume the registration and verification of Maoist army personnel -- to ensure that no minors are serving -- as soon as possible.
Story link
Related links
06.07.2007
The Food and Agriculture Organization (FAO) has warned the governments of India and Pakistan against the desert locust swarms from Ethiopia and northern Somalia which are expected to reach both the countries. FAO has asked them to mobilize field teams, equipment and resources to tackle the insects.
Story link
Related topics/regions:
[Pakistan]
[India]
[South Asia]
Image: Headed for South Asia
29.06.2007
Efforts must be intensified to help the world’s least developed countries and small island states tackle climate change, a senior UN official said.
Story link
Image: Island nations and climate change
29.06.2007
The High Representative for the Least Developed Countries (LDCs), Landlocked Developing Countries (LLDCs) and Small Island Developing States (SIDS), Anwarul Chowdhury, said that the UN debate on climate change will lose credibility if the concerns of these countries are sidelined because they are most vulnerable to climate change impacts.
Story link
Image: Island nations highly vulnerable
14.06.2007
The Sudanese government agreed Tuesday to accept a robust UN-African Union force to ensure protection for the people of Darfur. As many as 19,000 peacekeepers may be deployed shortly.
Story link
Related topics/regions:
[Sudan]
Image: December 2006 poster: 'UN peacekeepers needed now to stop genocide in Darfur' © Africa ActionRelated links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| < 7 >
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
