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=159910 ) 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=159866 ) 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=159826 ) 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=159772 ) 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=159318 ) as subquery

War and peace

April 2008

Suomelta vaaditaan tukea rypäleaseiden kiellolle 04/18/2008 Rauhanliitto vaatii Suomen hallitusta liittymään rypäleaseiden täyskieltoa kannattavien maiden joukkoon. Kansainväliset rypäleaseneuvottelut alkavat Dublinissa ensi kuussa. Read more From: Suomen Rauhanliitto - YK-yhdistys Related: [Finland] [War and Peace] [Arms & Military]

Vetoomus rypälepommien kieltämiseksi 04/17/2008 Human Rights Watch -järjestön mukaan mikään tavanomainen ase ei muodosta yhtä suurta vaaraa siviileille kun rypälepommit. Allekirjoita vetoomus, jotta myös Suomi liittyisi rypälepommikieltoa ajavien valtioiden joukkoon. Read more From: Suomen Rauhanpuolustajat Related: [Finland] [War and Peace]

After 43 years, India-Bangladesh friendship train on track 04/16/2008 To bring their bilateral relations back on track, India and Bangladesh flagged off the Maitree (Friendship) Express on April 14, 2008 after more than four decades, coinciding with the Bangla new year. The two countries had suspended cross-border passenger rail service after the 1965 Indo-Pak war. Read more Related: [South Asia] [Transport] [Politics] [War and Peace]

Somalia Recalls the Old Ways for Peace 04/15/2008 Somalia has been torn apart by civil war for nearly two decades. Several attempts have been made at finding a peaceful resolution to the conflict, but so far all of them have left the country without a functioning central administration. But now a new initiative with an innovative approach to peace-building is taking roots. Read more From: Suomen IPS Related: [Somalia] [War and Peace] [Conflict Resolution] Image: © New Internationalist

Ylisanat pois ja yhteistyöhön, asiantuntijat ojentavat YK:ta 04/01/2008 Turvallisuusneuvoston jäsenten veto-oikeus unholaan! Ylisanat pois YK-puheista! Muun muassa tällaisia vaatimuksia esitettiin perjantaina Hanasaaren kulttuurikeskuksen paneelikeskustelussa, jossa kuultiin kolmea tunnettua YK-asiantuntijaa. Read more From: Ulkoministeriö Related: [War and Peace] [United Nations] Image: -

{intl-browse_by_month}

…

2006 AMJJASOND

2007 JFMAMJJASOND

2008 JFMA

 Printable version