select *from (select top 9 * from (select top 18 * from img_new where typeid=11 order by id desc) t1 order by id asc) t2 order by id desc