select id,rdate,rbanner from (select * from tbltwar where rdate >= '2015-06-11' and rdate <= '2020-11-09') as y where lower(rquote) like '%eitam henkin%' order by id desc limit 100
| 1 |
514022 | 05/07/2018 | How much do terrorists who murder Jews get paid? |
| 2 |
470019 | 10/12/2016 | IDF seals off candy shop of terrorist’s family |
| 3 |
435640 | 11/15/2015 | IDF demolishes homes of four terrorists involved in recent killings |
| 4 |
432916 | 10/17/2015 | Several terrorists' homes to be demolished |
| 5 |
431636 | 10/06/2015 | Israel accuses Hamas of settler deaths
|
| 6 |
431434 | 10/04/2015 | IOF Hits Harshly at Palestinians in West Bank, Leaves 10 Wounded
|