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 '-1, 1' at line 1 : select * from yp_product where product_status='Active' and product_type='Gel' order by product_id asc limit -1, 1