|
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=148061
) 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=148017
) 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=148032
) 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=148011
) 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=147415
) as subquery
United Nations
<< Back to organisation profile
Features
10.04.2007
Thirteen years after some 800,000 Rwandans were murdered by their compatriots in an orchestrated criminal campaign, UN Secretary-General Ban Ki-moon has called for “a global partnership against genocide” and pledged to strengthen UN mechanisms to ensure that such an event never happens again.
Story link
Related links
10.04.2007
A €1.5 million donation will feed over 108,000 Bhutanese refugees in eastern Nepal who are unable to work outside the camps where they live.
Story link
Related topics/regions:
[Nepal]
[Bhutan]
Related links
09.04.2007
Reacting to the IPCC report on climate change, United Nations Secretary-General Ban Ki-moon has said that the impacts of climate change are increasingly noticeable, and likely to become more so in the future as extreme weather events intensify. He also urged countries to work on mitigating the worst effects of climate change.
Story link
09.04.2007
The United Nations High Commissioner for Human Rights has called for investigations into widespread sexual violence during attacks by Sudanese Government forces and allied militia in Darfur as well as the disappearance of over a dozen men allegedly at the hands of rebels there.
Story link
Related topics/regions:
[Sudan]
05.04.2007
A portable testing device could revolutionize the fight against bird flu and many other livestock diseases. The detector saves vital time in identifying the source of outbreaks so they can be contained.
Story link
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| < 10 >
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
