|
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=153666
) 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=153080
) 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=152973
) 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=152895
) 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=152901
) as subquery
United Nations
<< Back to organisation profile
Features
29.09.2007
Fleeing violence, drought, and unemployment, a growing number of Somali and Ethiopian immigrants are attempting to escape across dangerous waters, often encountering death at the hands of smugglers, the sea, or Yemeni forces, reports the UN.
Story link
Related topics/regions:
[Yemen]
[Somalia]
[Ethiopia]
Image: Somalis leaving in record numbers © Zoe Daniels / Mercy CorpsRelated links
12.09.2007
The UN has saluted the peaceful elections held recently in the fragile Southeast Asian nation of East Timor, but urged the country’s citizens and political parties to engage in political dialogue to consolidate the democracy and peace.
Story link
Related topics/regions:
[Timor-Leste]
Related links
07.09.2007
As the world mourns the loss of the extraordinary Italian tenor, the UN remembers his exceptional accomplishments as a Messenger of Peace.
Story link
05.09.2007
Despite the official end of the country's civil war and last year's historic national elections, the far eastern region of the Democratic Republic of Congo continues to be plagued by violence, and the number of displaced people is now growing at a terrifying rate.
Story link
Related topics/regions:
[Congo (Democratic Republic of)]
05.09.2007
Many Afghans returning to their homeland face a number of major challenges, including a lack of employment, health care, education and housing, according to an assessment carried out with the support of the United Nations refugee agency.
Story link
Related topics/regions:
[South Asia]
[Afghanistan]
<< Previous
| 1
| 2
| 3
| 4
| 5
| < 6 >
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
