|
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=157200
) 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=157123
) 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=156734
) 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=156458
) 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=156441
) as subquery
United Nations
<< Back to organisation profile
Features
25.01.2008
Peace may finally come to the war-weary Democratic Republic of Congo as the government recently reached an agreement with the armed rebels to halt violence after extensive negotiations in the Kivu regions, says the UN.
Story link
Related topics/regions:
[Congo (Democratic Republic of)]
Image: Child soldiers in the DR Congo. © Amnesty International
Related links
23.01.2008
Approximately 2,000 Colombians, including members of indigenous groups, fled their villages over the past two weeks as militias are intensifying their armed campaigns in the rural areas, writes the UN.
Story link
Related topics/regions:
[Colombia]
Related links
11.01.2008
To raise money and awareness for the plight of displaced Iraqis among neighboring Arab nations, the UN and the Arab League are launching a "massive" campaign featuring celebrities and refugee stories.
Story link
Related topics/regions:
[Iraq]
[Middle East]
Related links
01.01.2008
The joint UN-African Union force set up to stem the violence in Darfur has taken the reins from the existing African Union operation, but UN Secretary-General Ban Ki-moon warned that critical gaps remain in what will be the world's largest peacekeeping operation.
Story link
Related topics/regions:
[Sudan]
31.12.2007
The UN-African Union Mission in Darfur -- set to become the world's largest peacekeeping operation -- is poised to take over on Monday from the African Union force that has been working to quell the violence in western Sudan.
Story link
Related topics/regions:
[Sudan]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
