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 : select *  from  yp_pick where status='Active' and pick_type='Normal' and fea_status='Yes' and free_status='No'  order by pick_id limit -10, 10