select id,rdate,rbanner from (select * from tbltwar where rdate >= '2002-01-31' and rdate <= '2019-08-29') as y where lower(rquote) like '%ahmad shah massoud%' order by id desc limit 100
| 1 |
549126 | 08/29/2019 | Son of Famed Afghan Commander Massoud Steps into Spotlight |
| 2 |
522677 | 09/11/2018 | Kabul: 110 arrested for gun s3x, ISIS claims Sunday’s suicide attack |
| 3 |
522597 | 09/10/2018 | Suicide Bomber Kills 7 Amidst Massive Demonstrations in Kabul |
| 4 |
497243 | 09/14/2017 | Kabul police arrest 12 on charges of gun sex during the week of martyrs
|
| 5 |
496985 | 09/10/2017 | Dostum invites his rivals for political rivalry rather than hatching conspiracies |
| 6 |
496981 | 09/10/2017 | Abdullah calls Taliban a ‘terrorist group’ |
| 7 |
495567 | 08/22/2017 | Abdullah slams Gulbuddin Hekmayar for his remarks against Ahmad Shah Massoud |
| 8 |
495562 | 08/22/2017 | Rising tensions among prominent Afghan political leaders amid deteriorating security |
| 9 |
472005 | 11/03/2016 | Noor reacts to political agreement report with Ghani for leaving Balkh |
| 10 |
450495 | 03/28/2016 | Gen. Dostum and Ata Mohammad Noor supporters end tensions in Faryab
|
| 11 |
432773 | 10/16/2015 | Mujahideen Should Help Fight Taliban: Massoud |
| 12 |
430177 | 09/21/2015 | Rassoul Sayyaf Believes Terror Attacks Plotted in Kabul |
| 13 |
429164 | 09/11/2015 | Wreath Laid At Massoud's Grave In Panjsher |
| 14 |
399663 | 09/11/2014 | Gunsex on Massoud Day Kills One, Injures Five |
| 15 |
399626 | 09/10/2014 | Sayyaf Condemns Terrorists, Foreign Spies |
| 16 |
393098 | 06/13/2014 | Abdullah best bet for Afghan peace: Hamid Gul |
| 17 |
392891 | 06/10/2014 | Ahmad Shah Massoud Foundation Endorses Abdullah |
| 18 |
390170 | 04/28/2014 | Afghan Election Front-Runners Trade Fraud Allegations |
| 19 |
387111 | 03/10/2014 | Marshal Fahim, Dies At 56 |
| 20 |
345027 | 05/21/2012 | September 9 Declared National Holiday to Honour Massoud |
| 21 |
329644 | 09/12/2011 | Pakistan is 'not an ally' in terrorism fight, ex spy chief says |
| 22 |
329487 | 09/09/2011 | 'Nearly Two Dozen Insurgent Groups Behind Massoud's Death' |
| 23 |
324350 | 06/11/2011 | Suicide Bomber Kills Four Police in Kunduz |
| 24 |
321875 | 05/05/2011 | ISI Behind Assassination of Ahmad Shah Massoud: Relatives |
| 25 |
315066 | 01/31/2011 | Tunisians wary as Islamists emerge from hiding |
| 26 |
278710 | 09/11/2009 | Afghan Governor Lashes Out at Central Govt. |
| 27 |
276659 | 08/15/2009 | The Afghans Have a Referendum on Democracy |
| 28 |
275221 | 07/28/2009 | Karzai's Running Mate Survives Ambush |
| 29 |
198424 | 09/09/2007 | Afghan bombers 'foreigners' - UN |
| 30 |
154387 | 05/31/2006 | Asia Times: Al-Qaeda's long march to war |
| 31 |
145422 | 03/14/2006 | Binny's mentor recalls rise and fall of the Taliban |
| 32 |
140122 | 01/18/2006 | Terrorism and crime go hand-in-hand in Europe |
| 33 |
131131 | 10/02/2005 | How Italy went from an al-Qaeda logistics base to a potential target |
| 34 |
129216 | 09/11/2005 | Bin Laden must be tried as a criminal, says sister-in-law |
| 35 |
125783 | 08/03/2005 | The Algerian connection |
| 36 |
122885 | 06/30/2005 | BREAKING NEWS - Afghan Interior Minister Resigns |
| 37 |
120755 | 06/04/2005 | Nuggets from the Urdu Press |
| 38 |
23651 | 01/01/2004 | Boycott mars Afghanistan voting |
| 39 |
20441 | 10/28/2003 | What If... |