|
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=160508
) 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=159510
) 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=157603
) 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=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
United Nations
<< Back to organisation profile
Features
12.05.2008
More than 27,000 people in the Irrawaddy delta region of Burma -- one of the areas hardest hit by Cyclone Nargis -- have received food aid and other crucial supplies, a UN food agency announced yesterday.
Story link
Related topics/regions:
[Myanmar]
Related links
07.04.2008
As of Friday, twenty countries have ratified the first international convention on the rights of persons with disabilities.
Story link
07.02.2008
"Many of today's conflicts around the world are being fuelled or exacerbated by water shortages and climate change is only making the situation worse," says the UN Secretary-General, Ban-Ki Moon.
Story link
Related links
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
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
