You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-6, 6' at line 1 : select * from yp_product where product_status='Active' and product_type='Certificate' and product_id<>'25' order by product_id asc limit -6, 6