err:select * from (select date from Btime_table where t_code = '9107' and date < '2015-07-30' order by date desc limit 27) as table_buff order by date asc