Fatal error: Uncaught Exception: Error: Column 'category_id' in field list is ambiguous<br />Error No: 1052<br />
SELECT DISTINCT c.category_id, cd.name, c.parent_id
FROM oc_product p
JOIN oc_product_to_category p2c ON p.product_id = p2c.product_id
JOIN oc_category c ON p2c.category_id = c.category_id
JOIN oc_category_description cd ON c.category_id = cd.category_id
WHERE p.manufacturer_id = '14'
AND cd.language_id = '1'
AND c.status = '1'
AND c.category_id NOT IN (
SELECT category_id
FROM oc_manufacturer
WHERE name = cd.name
)
ORDER BY c.parent_id, cd.name
in /var/www/konsmarket.ru/data/www/konsmarket.ru/system/library/db/mysqli.php:40
Stack trace:
#0 /var/www/konsmarket.ru/data/www/konsmarket.ru/system/library/db.php(45): DB\MySQLi->query('\n SELECT...')
#1 /var/www/konsmarket.ru/data/www/konsmarket.ru/catalog/model/catalog/manufacturer.php(84): DB->query('\n SELECT...')
#2 /var in /var/www/konsmarket.ru/data/www/konsmarket.ru/system/library/db/mysqli.php on line 40