err:select * from (select date from Btime_table where t_code = '7711' and date < '2010-09-13' order by date desc limit 30) as table_buff order by date asc