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 '/ Берем только родительские категории
...' at line 10<br />Error No: 1064<br />
SELECT DISTINCT parent.category_id, parent.name
FROM oc_product p
JOIN oc_product_to_category p2c ON p.product_id = p2c.product_id
JOIN oc_category child ON p2c.category_id = child.category_id
JOIN oc_category parent ON child.parent_id = parent.category_id
JOIN oc_category_description pd ON parent.category_id = pd.category_id
WHERE p.manufacturer_id = '14'
AND pd.language_id = '1'
AND parent.status = '1'
AND parent.parent_id = 0 // Берем только родительские категории
GROUP BY parent.category_id
ORDER BY pd.name
in /var/www/konsmarket.ru/data/www/konsmarket.ru/system/library/db/mysqli.php:40
Stack tra in /var/www/konsmarket.ru/data/www/konsmarket.ru/system/library/db/mysqli.php on line 40