select id,rdate,rbanner from (select * from tbltwar where rdate >= '2002-01-26' and rdate <= '2020-12-25') as y where lower(rquote) like '%dishu district%' order by id desc limit 100
| 1 |
563205 | 02/11/2020 | 29 Taliban militants killed, detained in airstrikes and Special Forces raids |
| 2 |
546276 | 07/23/2019 | Airstrikes kill 7 Taliban militants in Helmand, Kunduz and Uruzgan provinces |
| 3 |
463426 | 07/30/2016 | Afghan official: Taliban capture district in Helmand |
| 4 |
375423 | 09/08/2013 | Shaboobs Claim Twin Blasts in Somali Capital that Kill 18 |
| 5 |
357035 | 11/29/2012 | Gov't forces begin to eliminate Illegal checkpoints set up in Mogadishu
|
| 6 |
308786 | 11/01/2010 | Afghan official says 17 insurgents killed in south
|
| 7 |
204305 | 10/29/2007 | Six killed as Ethiopian troops start security sweep of Mog |
| 8 |
192438 | 07/03/2007 | Gunmen slay Somali official, blast kills teen |
| 9 |
189701 | 06/01/2007 | We'll use all means to crack down remnants, Mogadishu mayor |
| 10 |
145038 | 03/10/2006 | Three killed as Afghan police clash with suspected Taleban |
| 11 |
133870 | 11/02/2005 | Suspected Taliban Kill 5 Police Officers |
| 12 |
128631 | 09/05/2005 | Afghan Violence Leaves 12 Dead |
| 13 |
62451 | 04/28/2005 | US Soldier, 6 Afghan Cops Killed in Clashes |