select id,rdate,rbanner from (select * from tbltwar where rdate >= '2022-07-12' and rdate <= '2023-10-10') as y where lower(rquote) like '%brothers and sisters in arms%' or lower(rquote) like '%brothers in arms%' order by id desc limit 100
| 1 |
679943 | 09/30/2023 | To be removed from the Russian list of terrorists, the Taliban must fulfill three conditions |
| 2 |
679360 | 09/24/2023 | Israeli anti-Bibi activists meet NY tech fat cats: ‘We’re facing a protracted campaign’ |
| 3 |
679242 | 09/22/2023 | Israeli forces shell military ‘structures’ in Golan Heights, drone-zap 2 Islamic Jihadis farther down the border |
| 4 |
676405 | 08/22/2023 | Terror charges filed against Palestinian who stabbed coworker in Petah Tikva garage |
| 5 |
673984 | 07/29/2023 | Another 10,000 IDF reservists announce they won't serve anymore |
| 6 |
673429 | 07/23/2023 | What Matters Now to Dr. Yonatan Freeman: The dictatorship tipping point? |
| 7 |
672542 | 07/14/2023 | Reservists reject PM’s shouted accusations they are harming national security |
| 8 |
671372 | 07/02/2023 | Turnout rises, several arrested as anti-overhaul protests enter 26th week |
| 9 |
671197 | 06/30/2023 | Gun licenses revoked from several members of ‘Brothers in Arms’ protest group |
| 10 |
667815 | 05/22/2023 | Two PMF Factions Engage in Firefight in Kirkuk Over a Property Dispute |
| 11 |
662726 | 03/29/2023 | Roundup: The Biden war against Bibi continues after 100,000 Israelis protest for reforms |
| 12 |
654463 | 01/04/2023 | Pak Taliban to run parallel govt in Pakistan |
| 13 |
652774 | 12/18/2022 | Two UN peacekeepers killed in Mali |
| 14 |
639893 | 07/30/2022 | Ukrainian Perspective: Invasion of Ukraine: July 29th, 2022 |