select id,rdate,rbanner from (select * from tbltwar where rdate >= '2002-12-25' and rdate <= '2023-03-26') as y where lower(rquote) like '%john brown gun club%' or lower(rquote) like '%redneck revolt%' order by id desc limit 100
| 1 |
661032 | 03/12/2023 | Charlottesville neo-Nazi rally organizers ordered to pay $5 million in legal fees |
| 2 |
618290 | 11/24/2021 | Jury orders organizers of antisemitic Charlottesville rally to pay $26M in damages |
| 3 |
578206 | 07/29/2020 | More than 20 people were arrested at the antifa/BLM riot over the weekend in Richmond, Va. that were organized in support of the Portland antifa riots |
| 4 |
578147 | 07/28/2020 | White supremacists disguised as Black Lives Matter supporters triggered riots, Richmond mayor says |
| 5 |
576861 | 07/14/2020 | Trove of Leaked FBI, Fusion Center and DHS Documents Provide Insight Into Antifa, Charlottesville, Political Bias, and the Erosion of Civil Liberties |
| 6 |
575785 | 07/02/2020 | Man armed with a bazooka and gunmen with assault rifles turn up to protect protesters in Missouri angry over cop hitting man, 20, with unmarked car because he was mistaken for a suspect |
| 7 |
574936 | 06/21/2020 | My terrifying five-day stay inside Seattle's cop-free CHAZ |
| 8 |
573930 | 06/10/2020 | Project Veritas #EXPOSEANTIFA Part III: “We believe in complete abolition of the system itself, including police...” |
| 9 |
547617 | 08/10/2019 | Antifa Terrorism—The Coming Civil War |
| 10 |
505887 | 01/17/2018 | Redneck Revolt drew first blood in Charlottesville |
| 11 |
504663 | 12/30/2017 | This Week in Guns, December 30th, 2017 |
| 12 |
500136 | 10/24/2017 | From The Gym To The Gun Range, Where Antifa Learns To Fight |
| 13 |
496406 | 09/02/2017 | This Week in Guns, September 2nd, 2017 |
| 14 |
495861 | 08/26/2017 | This Week in Guns, August 26th, 2017 |