select id,rdate,rbanner from (select * from tbltwar where rdate >= '2013-08-27' and rdate <= '2015-11-25') as y where lower(rquote) like '%kunming%' order by id desc limit 100
| 1 |
418707 | 05/26/2015 | China Busts 181 'Terror' Gangs in Year-long Crackdown |
| 2 |
412129 | 03/05/2015 | Group: 450 Killed in China's Xinjiang Last Year, Mostly Uighurs |
| 3 |
403254 | 11/01/2014 | Three Uighurs given death sentences in rail station knife attack |
| 4 |
401995 | 10/14/2014 | 12 Condemned to Death for Attack in China's Xinjiang |
| 5 |
399834 | 09/13/2014 | Death for 3 in China station attack |
| 6 |
397794 | 08/15/2014 | Europe's BDS And Bonsai Armies: Is The Sun Setting In The West And Rising East In China? |
| 7 |
397178 | 08/06/2014 | Earthquake in China's Yunnan province razes an estimated 22,550 houses |
| 8 |
396345 | 07/25/2014 | N.Korean Defectors, Helpers Arrested in China |
| 9 |
393815 | 06/22/2014 | 13 killed in Xinjiang police station attack |
| 10 |
390978 | 05/13/2014 | Report: More than 200 Held in China Terror Video Crackdown |
| 11 |
387717 | 03/19/2014 | Militant Islamist Group Backs China Station Attack |
| 12 |
386854 | 03/05/2014 | Kunming terrorism: first responders took on assailants bare-handed (Xinhua) |
| 13 |
386710 | 03/03/2014 | Xinhua: Terrorist act on Chinese soil is merely "meaningless act" to USA |
| 14 |
386590 | 03/02/2014 | 28 dead in Kunming rail station violence |