err:select * from (select date from Btime_table where t_code = '6918' and date < '2017-07-12' order by date desc limit 9) as table_buff order by date asc