select id,rdate,rbanner from (select * from tbltwar where rdate >= '2022-07-12' and rdate <= '2023-10-10') as y where lower(rquote) like '%idf reservists%' order by id desc limit 100
| 1 |
676978 | 08/27/2023 | Top Dutch court confirms Gantz can’t be sued for civilian deaths in 2014 Gaza strike |
| 2 |
673491 | 07/24/2023 | ‘Time of emergency’: Dueling judicial overhaul rallies as Herzog makes final bid for compromise |
| 3 |
673429 | 07/23/2023 | What Matters Now to Dr. Yonatan Freeman: The dictatorship tipping point? |
| 4 |
652991 | 12/21/2022 | Notorious Terrorist Involved In Ramallah Lynching Dies in Israeli Prison, Glorified By Palestinian Society |
| 5 |
640525 | 08/06/2022 | Egypt is holding feverish talks in order to bring calm in Gaza |