select id from content where statusid=1 and siteid=3 and id in(select contentid from content_properties where typeid=5 and propertyid =143478) 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 =143478) order by publisheddate desc
Search «Saudi Apache military chopper» - Result Count 1 Item

Saudi Apache Chopper Down by Yemeni Army

Sat Aug 22, 2015 14:43:47

A Saudi surface-to-air missile military helicopter shot down by Yemeni joint forces in the province of Jizan in Southern Saudi Arabia.

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