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