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 'ORDER BY ps.priority ASC, ps.price ASC LIMIT 1
) AS special,
...' at line 16<br />Error No: 1064<br />
SELECT DISTINCT
oc_product.product_id,
oc_product.image,
oc_product.adult,
oc_product.model,
oc_product.price,
oc_product.quantity_step,
(
SELECT price FROM oc_product_special ps
WHERE ps.product_id = oc_product.product_id
AND ps.customer_group_id = '1'
AND (
(
ps.date_start = '0000-00-00' OR ps.date_start < NOW()
)
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1
) AS special,
oc_product.tax_class_id,
oc_product.unit_class_id,
oc_product.minimum,
(
SELECT AVG(rating) FROM oc_review r
WHERE r.pro in /var/www/taktika.lv/web/system/library/db/mysqli.php on line 40