select id,rdate,rbanner from (select * from tbltwar where rdate >= '2001-08-27' and rdate <= '2019-11-25') as y where lower(rquote) like '%salman pak%' order by id desc limit 100
| 1 |
335430 | 12/18/2011 | Federal judge: Iran shares responsibility for 9/11 terror attacks |
| 2 |
265903 | 03/24/2009 | Will Sunni's rejoin AQI for the bucks? |
| 3 |
256969 | 12/11/2008 | One terr killed, 18 suspects in custody — MNF |
| 4 |
250877 | 09/24/2008 | Three die in roadside bomb attacks in Iraq |
| 5 |
246457 | 08/08/2008 | U.S. army nab 25 suspects including al-Qaeda commander |
| 6 |
242414 | 06/23/2008 | Iraqi official opens fire on visiting U.S. troops; killing one |
| 7 |
240734 | 06/03/2008 | U.S. forces kill 2 gunmen, arrest 30 in central, northern Iraq |
| 8 |
240312 | 05/29/2008 | Salman Pak showing signs of improvement - Here come the judge |
| 9 |
224000 | 02/06/2008 | Iraqi SWAT detains 28 suspects, kills seven terrorists in operations targeting AQI |
| 10 |
223754 | 02/05/2008 | Iraqi troops kill 11 in countrywide raids |
| 11 |
212377 | 12/10/2007 | Al-Qaeda networks disrupted; Coalition forces detain 10 suspects |
| 12 |
208649 | 11/22/2007 | Two British troops killed in Iraq helicopter crash |
| 13 |
208483 | 11/21/2007 | US helicopter crashes in Iraq |
| 14 |
205154 | 11/03/2007 | U.S. forces kill 10 al Qaeda suspects near Baghdad |
| 15 |
201458 | 10/06/2007 | Ground, helicopters team to kill 3 extremists during raid |
| 16 |
201373 | 10/05/2007 | Yemeni Fighter Iced |
| 17 |
199440 | 09/19/2007 | Marne Husky ends with capture of insurgent |
| 18 |
198532 | 09/10/2007 | Media Matters: On Fox News Sunday, Hume falsely asserted that Al Qaeda in Iraq 'was there before we got there' |
| 19 |
197842 | 09/03/2007 | US forces in Iraq kill eight suspected militants |
| 20 |
192881 | 07/08/2007 | Iraqi army still not meeting U.S. needs |
| 21 |
192638 | 07/05/2007 | When does a massacare count as news? |
| 22 |
192128 | 06/30/2007 | US military accuses media of reporting 'false' Iraqi claims (Bloggers confirmed) |
| 23 |
192059 | 06/29/2007 | Current Iraq Offensive w/Operational Map |
| 24 |
191978 | 06/29/2007 | Bombing kills 22 at Baghdad bus station |
| 25 |
191928 | 06/28/2007 | Coalition air strike destroys building, kills insurgents |
| 26 |
191348 | 06/22/2007 | Marne Torch continues clearing insurgent safe havens |
| 27 |
191231 | 06/20/2007 | Battle of Iraq 2007 - Bill Roggio June 20 |
| 28 |
191134 | 06/19/2007 | 10,000 US Troops Launch Iraq Offensive (D-DAY IN BAQOUBA!) |
| 29 |
188229 | 05/13/2007 | More on Mahmudiyah Ambush |
| 30 |
187459 | 05/03/2007 | He wasn't born an American but he died as one |
| 31 |
180658 | 02/17/2007 | Bomb-Making Factory Destroyed; Two Suspects Captured (EFP mention?) |
| 32 |
180474 | 02/15/2007 | Hostage rescued in Salman Pak |
| 33 |
168136 | 10/09/2006 | Hundreds of Iraq police sick from poison |
| 34 |
158041 | 07/03/2006 | No Medical Recovery Outside Of Iraq FOBs ?? |
| 35 |
153708 | 05/25/2006 | 11 killed in Iraqi drive-by shootings |
| 36 |
144523 | 03/05/2006 | Talabani calls Jaafari a block to unity |
| 37 |
144436 | 03/04/2006 | Iraqi President: U.S. to Stay As Long As Needed |
| 38 |
143958 | 02/27/2006 | Holy Shiite Tomb Attacked |
| 39 |
143939 | 02/27/2006 | Sunnis Ready to End Boycott, Leader Says |
| 40 |
142737 | 02/15/2006 | Searching Saddam's Hard Drives |
| 41 |
140502 | 01/22/2006 | Hoekstra has 39 of 40 Iraqi documents listed by the Weekly Standard |
| 42 |
139222 | 01/07/2006 | Saddam's terrorist training camps |
| 43 |
123004 | 07/01/2005 | Get Smart |
| 44 |
61677 | 04/18/2005 | Mass kidnapping may be a tribal dispute |
| 45 |
61676 | 04/18/2005 | Huge operation launched to free Iraqi hostages |
| 46 |
61606 | 04/17/2005 | Iraqi troops rescue Shiite hostages in besieged town |
| 47 |
60221 | 03/30/2005 | Iraq Ops Update |
| 48 |
59902 | 03/26/2005 | After Action Report: Raven 42, engagement in Salman Pak |
| 49 |
59734 | 03/24/2005 | Largest terrorist training camp seized |
| 50 |
58999 | 03/16/2005 | Islamic Anger Brigades join Zarqawi |
| 51 |
58362 | 03/08/2005 | New fighting underway in Ramadi |
| 52 |
56211 | 02/11/2005 | 20 killed at Salman Pak |
| 53 |
53666 | 01/14/2005 | Iraqi Extremists Claim Killing of Cleric |
| 54 |
53588 | 01/13/2005 | Aide to revered cleric killed |
| 55 |
35539 | 06/15/2004 | Rioting follows bombings that kill 21, injure 62 in Iraq |
| 56 |
26643 | 02/21/2004 | Saddamâs ambassador to al-Qaeda |
| 57 |
26511 | 02/19/2004 | Follow the money - Syria and funding for the insurgency in Iraq |
| 58 |
25774 | 02/07/2004 | Interesting bit of info here ... |
| 59 |
22723 | 12/15/2003 | Sammy being jugged may scare Binny, but wonât effect al-Qaeda morale |
| 60 |
21272 | 11/15/2003 | About that smoking gun ... |
| 61 |
20026 | 10/17/2003 | Iraqi Daily: Saddam Ordered Training of Al-Qaida Members |
| 62 |
19428 | 10/03/2003 | Suspected Saddam executioner caught |
| 63 |
13037 | 04/14/2003 | Yemen arrests returning Iraqi volunteers |
| 64 |
12570 | 04/06/2003 | Marines Attack Suspected Terrorist Camp in Salman Pak |
| 65 |
11343 | 03/16/2003 | Spain links suspect in 9/11 plot to Baghdad |