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

UAE Fighter Jet Crashed in Yemen's Aden, 2 Pilots Killed

Mon Mar 14, 2016 15:49:24

Two Emirati pilots were killed when their fighter jet crashed on Monday in Yemen, where a Saudi-led coalition is battling Houthi Ansarallah fighters, the alliance said.

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