select * from flowers where prod_status='Y' and cat_id=8 order by prod_id DESC limit -12, 12 1064 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 '-12, 12' at line 1