select id,rdate,rbanner from (select * from tbltwar where rdate >= '2013-12-06' and rdate <= '2017-03-06') as y where lower(rquote) like '%jund al-sham%' order by id desc limit 100
| 1 |
473827 | 11/22/2016 | Lebanon builds wall near Ein el-Hellhole |
| 2 |
467517 | 09/14/2016 | Chechen jihadist group joins rebels in northern Hama
|
| 3 |
452428 | 04/13/2016 | Car bomb in Lebanon’s Sidon kills Palestinian official |
| 4 |
429943 | 09/19/2015 | Pakistani among 7 people charged with supporting IS group in Germany |
| 5 |
427477 | 08/24/2015 | Cease-fire Agreement Reached in Ain Al-Hilweh
|
| 6 |
416270 | 04/30/2015 | White House Hits Back at Bush: Qaeda Wasn't in Iraq prior to 2003 Invasion
|
| 7 |
406832 | 12/24/2014 | Defected Syrian Soldier Held on Suspicion of Plotting Terror Acts |
| 8 |
406222 | 12/14/2014 | 2 Arrested over Bhannine Clashes, Another 2 over Ties to Extremist Groups |
| 9 |
394191 | 06/27/2014 | 15 Suspected Terrorists Charged with Assassination Plot |
| 10 |
389785 | 04/22/2014 | Tension Increases in Ain el-Hilweh after Gunmen Assassinate Ali Khalil |
| 11 |
387803 | 03/21/2014 | Syria Army Seizes Famed Krak des Chevaliers Fort in Border Push |
| 12 |
381523 | 12/12/2013 | Teenager Tasked by Jund al-Sham with Monitoring Hizbullah Mosque |