err:select * from (select date from Btime_table where t_code = '2207' and date < '2009-10-27' order by date desc limit 3) as table_buff order by date asc