|
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=108595
) 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=108591
) 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=108512
) 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=108057
) 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=108067
) as subquery
United Nations
<< Back to organisation profile
Features
30.03.2005
United Nations advocates for solving the transport problems impeding free trade by landlocked developing countries.
Story link
Related topics/regions:
[Nepal]
30.03.2005
Ministers from 52 Asian and Pacific countries pledge to adopt environmentally sustainable growth approach as they fight against poverty.
Story link
29.03.2005
An earthquake that struck the west coast of Sumatra in Indonesia may not have caused a tsunami, but it's another wake up call for the region to set up an early warning system.
Story link
22.03.2005
Secretary-General Kofi Annan laid before the General Assembly his package for United Nations reform Monday, stressing the urgency of taking action in the three key areas of development, security and human rights. "This hall has heard enough high-sounding declarations to last us for some decades to come," he said. "What is needed now is not more declarations, but action to fulfil the promises already made."
Story link
Image: Kofi Annan addresses the UN General Assembly, March 21, 2005 © United NationsRelated links
22.03.2005
Story of a women-headed household, which recognises the importance of education and decides to send their daughter to school despite facing hardships, in Mumbai slums.
Story link
Related topics/regions:
[India]
<< Previous
| 36-45
| 46
| 47
| 48
| 49
| 50
| 51-60
| 61-70
| 71-80
| 81-90
| Next >>
|
|
|
|
