Qry Err1 : select * from goods where goodok='Y' and (bLimit<2) and ( category='1421295112' or category='CHILD1522032820' or category='CHILD1522032882' or category='CHILD1522032891' or category='CHILD1522032899' or category='CHILD1523160293' or category='CHILD1523261715' or category='CHILD1550219562' or category='CHILD1550219891' ) order by setVal asc,idx asc limit -10, 10 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 1