err:select * from (select date from Btime_table where t_code = '4323' and date < '2009-11-04' order by date desc limit 28) as table_buff order by date asc