Warning: A non-numeric value encountered in /data/e/a/eab8d15a-7b75-4715-ac73-d03c3e659ec9/podsplavom.sk/ps3_prod_storage/modification/catalog/controller/product/manufacturer.php on line 177
Fatal error: Uncaught Exception: Error: 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 41<br />Error No: 1064<br />
SELECT
p.product_id,
(
SELECT AVG(rating) total
FROM `oc_review` r1
WHERE
r1.product_id = p.product_id
AND r1.status = '1'
GROUP BY r1.product_id
) rating,
(
SELECT price
FROM `oc_product_discount` pd2
WHERE
pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND pd2.quantity = '1'
AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
) discount,
(
SELECT price
FROM `oc_product_special` ps
WHERE
ps.product_id = p.product_id
AND ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
in /data/e/a/eab8d15a-7b75-4715-ac73-d03c3e659ec9/podsplavom.sk/web/system/library/db/mysqli.php on line 40