select id from content where statusid=1 and siteid=3 and id in(select contentid from content_properties where typeid=5 and propertyid =35593) order by publisheddate desc limit 0,20;select count(*) totalcount from content where statusid=1 and siteid=3 and id in(select contentid from content_properties where typeid=5 and propertyid =35593) order by publisheddate desc
Search «Russia MiG Fighters» - Result Count 1 Item

Russia set to sell MiG fighter jets to Syria

Fri May 31, 2013 13:35:42

A Russian arms manufacturer has decided to engage in new contract with Syria to deliver at least 10 fighter jets to Syria.

2017 Alalam News Network. Islamic Republic of Iran Broadcasting. All Rights Reserved.