err:select * from (select date from Btime_table where t_code = '4397' and date < '2019-08-08' order by date desc limit 31) as table_buff order by date asc