err:select * from (select date from Btime_table where t_code = '1979' and date < '2013-09-09' order by date desc limit 8) as table_buff order by date asc