Qry Err1 : select * from goods where goodok='Y' and (bLimit<2) and ( category='1383110139' or category='CHILD1522227479' or category='CHILD1522227575' or category='CHILD1523164467' or category='CHILD1633503921' or category='CHILD1660626253' or category='CHILD1660636909' or category='CHILD1660637056' or category='CHILD1671583787' or category='CHILD1689830392' or category='CHILD1689830411' ) 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