err:select * from (select date from Btime_table where t_code = '3823' and date < '2016-06-29' order by date desc limit 10) as table_buff order by date asc