err:select * from (select date from Btime_table where t_code = '9843' and date < '2012-12-06' order by date desc limit 26) as table_buff order by date asc