ERROR IN QUERY:
SELECT CASE a.retail_discount WHEN '0.00' THEN a.retail_price ELSE a.retail_discount END AS final_price, a.*, b.* FROM `m_shop_products` AS a LEFT JOIN `m_shop_products_data` AS b ON a.id = b.item_id WHERE b.lang = '17' AND a.status = '1' AND a.access = 'guest' AND a.categ = '4' ORDER BY a.position ASC LIMIT -12,12

ERROR INFO:
(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 16

ERROR LOCATION:
into file /home/animohr/www_luce/e5cms/modules/webshop/products/web.php on line 730