|
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=148898
) 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=148740
) 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=148547
) 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=148508
) 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=148157
) as subquery
United Nations
<< Back to organisation profile
Features
08.05.2007
YK:n Informaatiokomitean (Committee on Information) kokouksessa puollettiin monipuolisen median käyttöönottoa. Sekä perinteisten että uusien medioiden avulla tulisi YK:n mukaan pyrkiä tehokkaammin levittämään rauhan, kehityksen ja oikeuksien sanomaa. Intian suurlähettiläs Ajai Malhotra sisällytti hyödynnettäviin informaatioteknologioihin niin lehdistön, radion kuin myös uudet webcast- ja podcast-teknologiat.
Story link
Related topics/regions:
[intermediate technology]
[media technologies]
03.05.2007
The International Criminal Court has issued its first warrants for war crimes and crimes against humanity in Darfur, giving the government responsibility for the arrest of a Sudanese minister and a militia commander.
Story link
Related topics/regions:
[Sudan]
25.04.2007
Somalia has become the most dangerous place in the world for relief workers to operate, the UN's humanitarian chief has warned, with none of the sides in the fighting in Mogadishu in recent weeks respecting the rules of war or making allowance for aid operations.
Story link
Related topics/regions:
[Somalia]
24.04.2007
The United Nations Human Settlements Programme (UN-HABITAT) signed an agreement with soft drink multinational Coca-Cola to collaborate on projects to improve community access to water and sanitation in India and Nepal.
Story link
Related topics/regions:
[South Asia]
[India]
[Nepal]
13.04.2007
Israel, Jordan, and the Palestinian Authority have united in their fight against the Mediterranean fruit fly, one of the world's most destructive agricultural pests.
Story link
Related topics/regions:
[Israel]
[Jordan]
[Palestine]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| < 9 >
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
