|
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=158814
) 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=158698
) 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=158339
) 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=158255
) 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=158211
) as subquery
United Nations' Integrated Regional Information Network
<< Back to organisation profile
Features
13.03.2008
Many of the hundreds of thousands of displaced people in Somalia are surviving on less than one meal a day, reports the International Committee of the Red Cross, as the protracted conflict in Mogadishu escalates and spreads to other parts of the nation.
Story link
Related topics/regions:
[Somalia]
Related links
11.03.2008
Despite the power-sharing deal signed two weeks ago, hundreds of displaced Kenyans living in temporary shelters in Nairobi are still unable to return home.
Story link
Related topics/regions:
[Kenya]
Related links
28.02.2008
Violence incited by a taxi strike against high fuel prices in Douala, a major city in Cameroon, is spreading to other parts of the country, including the capital, Yaoundé.
Story link
Related topics/regions:
[Chad]
26.02.2008
As many as half a million Sri Lankans could be affected in 2008 alone as violence between the secessionist group, the Liberation Tigers of Tamil Elam, and the government continues to intensify.
Story link
Related topics/regions:
[Sri Lanka]
Related links
25.02.2008
Armed groups are mobilizing on all sides of Kenya's ethno-political divisions and threatening to destabilize the ongoing peace talks, which many observers say have been making notable progress.
Story link
Related topics/regions:
[Kenya]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
