|
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=136628
) 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=136612
) 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=136351
) 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=135990
) 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=135963
) as subquery
United Nations
<< Back to organisation profile
Features
19.07.2006
In the face of an increasingly bleak situation for Palestine, the UN and various NGOs have added $169 million to their appeal for humanitarian assistance.
Story link
Related topics/regions:
[Palestine]
Image: Nearly 70% of Gaza's potential workforce is out of work or without pay. © United Nations
18.07.2006
Some of the 8,000 foreign combatants that remain in DR Congo after its devastating civil war represent a menace to civilians but do not seriously threaten a successful outcome for the 30 July elections, according to a UN official.
Story link
Related topics/regions:
[Congo (Democratic Republic of)]
Image: UN Mission in Congo: Pakistani peacekeepers, 2005 © Christophe Boulierac / DPI / United Nations
13.07.2006
Saying that he was “appalled by the brutal and callous bombings” of trains in Mumbai, India, United Nations Secretary-General Kofi Annan said today that such acts confirm that terrorism constitutes one of the most serious threats to international peace and security.
Story link
Related topics/regions:
[Pakistan]
[India]
Image: Anti-Terrorism, Writers and Freedom of Expression
06.07.2006
The easing of the total blockage of the Gaza Strip by the Israel Defence Forces has averted--for now--a possible humanitarian catastrophe, said a UN spokesman, but he warned that the situation remains serious, with supplies still not getting through and inadequate sanitation portending a health crisis.
Story link
05.07.2006
The easing of the total blockage of the Gaza Strip by the Israel Defence Forces has averted - for now - a possible humanitarian catastrophe, said a UN spokesman, but he warned that the situation remains serious, with supplies still not getting through and inadequate sanitation portending a health crisis.
Story link
Related topics/regions:
[Palestine]
[Israel]
<< Previous
| 16-25
| 26
| 27
| 28
| 29
| 30
| 31-40
| 41-50
| 51-60
| 61-70
| Next >>
|
|
|
|
