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