Say:select id from where navid in (53) order by paixu asc,id descSay:select * from where navid in (53) order by paixu asc,id desc limit 0,12