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