select id,rdate,rbanner from (select * from tbltwar where rdate >= '2003-12-21' and rdate <= '2017-03-22') as y where lower(rquote) like '%omar brooks%' or lower(rquote) like '% abu izzadeen%' or lower(rquote) like '% trevor brooks%' order by id desc limit 100
| 1 |
436210 | 11/20/2015 | Hungary Orders Deportation of British Muslim 'Hate Preacher' |
| 2 |
361156 | 01/29/2013 | European 'No-Go' Zones for Non-Muslims Proliferating |
| 3 |
338741 | 02/09/2012 | Terrorism gang jailed for plotting to blow up London Stock Exchange |
| 4 |
312394 | 12/24/2010 | Christmas bomb plotters radicalised in jail |
| 5 |
273808 | 07/07/2009 | British terror preacher back in prison |
| 6 |
269212 | 05/06/2009 | British terror preacher Abu Izzadeen freed from jail early |
| 7 |
252530 | 10/12/2008 | British terror preacher out by Christmas? |
| 8 |
249893 | 09/13/2008 | Radical Muslims warn of a British 9/11 |
| 9 |
237052 | 04/18/2008 | Muslim preacher Abu Izzadeen found guilty of inciting terrorism |
| 10 |
237047 | 04/18/2008 | Terror case man hands himself in |
| 11 |
223828 | 02/05/2008 | Islamic preacher 'recruited terrorists for Iraq' in Britain |
| 12 |
187349 | 05/02/2007 | UK Muslim: "We definitely want to see Sharia law in place here" |
| 13 |
186694 | 04/24/2007 | British Police Arrest 6 Terror Suspects |
| 14 |
179962 | 02/09/2007 | Five British Beheading Plotters Face Terror Charges |
| 15 |
179869 | 02/08/2007 | Abu Izzadeen has been arrested for encouraging terrorism |
| 16 |
177726 | 01/14/2007 | UK preacher in secret web call for jihad |
| 17 |
166905 | 09/26/2006 | The shadow cast by a mega-mosque |
| 18 |
166834 | 09/25/2006 | Londonstan's RoP Uncloaks! |
| 19 |
166706 | 09/23/2006 | Londonstan: Police to Notify Panel of Muslims before Antiterror Raids |
| 20 |
166488 | 09/21/2006 | 'Martyrdom is praiseworthy' |
| 21 |
165546 | 09/10/2006 | UK Dragnet For Abu Izzadeen, Jihadi Terrorist |
| 22 |
126141 | 08/07/2005 | UK: Extremists may face treason charges |
| 23 |
126114 | 08/07/2005 | Undercover with Al-Muhajiroun |
| 24 |
126089 | 08/07/2005 | Inside the sect that loves terror |
| 25 |
30835 | 04/18/2004 | British Muslim politician deserves to die, say Islamic zealots |