|
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=147781
) 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=147248
) 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=145830
) 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=145371
) 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=145348
) as subquery
United Nations
<< Back to organisation profile
Features
03.04.2007
For crises where minutes can make a difference between life and death, the United Nations has just graduated its first class of emergency telecommunications team leaders.
Story link
Related links
18.03.2007
A four-day conference will be held at the UN Training Centre in Italy this week in an effort to increase the "unacceptably" low number of female officers in United Nations policing.
Story link
05.02.2007
The UN Population Fund renewed its call today for intensified global efforts to save the 3 million girls who still face the risk of female genital mutilation or cutting every year.
Story link
Image: Logo della campagna - da Stop FGM
24.01.2007
The world must not lower its guard against the threat of a "bird flu" pandemic, Dr Margaret Chan, the head of the World Health Organization, warned this week. "Almost no country with large outbreaks in commercial or backyard flocks has successfully eliminated the virus," she pointed out.
Story link
24.01.2007
The world must not lower its guard against the threat of a "bird flu" pandemic, Dr Margaret Chan, the head of the World Health Organization, warned this week. "Almost no country with large outbreaks in commercial or backyard flocks has successfully eliminated the virus", she pointed out.
Story link
<< Previous
| 6-15
| 16
| 17
| 18
| 19
| 20
| 21-30
| 31-40
| 41-50
| 51-60
| Next >>
|
|
|
|
