err:select * from (select date from Btime_table where t_code = '4584' and date < '2014-04-25' order by date desc limit 4) as table_buff order by date asc