select id from content where statusid=1 and siteid=3 and id in(select contentid from content_properties where typeid=5 and propertyid =142916) 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 =142916) order by publisheddate desc
Search «Russian Iskander ballistic missiles» - Result Count 1 Item

Saudi’s Salman and Jordan’s Abdullah Meet Putin in Saint Petersburg

Wed Aug 19, 2015 10:23:10

King Salman bin Abdulaziz of Saudi Arabia and King Abdullah bin al-Hussein of Jordan are expected to attend the opening day of the MAKS-2015 air show in Russia on August 25.

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