Fatal error: Uncaught Exception: Error: Unknown column 'p2c.category_id' in 'on clause'<br />Error No: 1054<br />
SELECT
p.product_id,
pd.name,
p.model,
p.price,
p.mpn,
p.upc,
p.ean,
p.jan,
p.isbn,
-- Средний рейтинг
AVG(r.rating) AS rating,
-- Количество отзывов
COUNT(r.rating) AS review_count,
-- Минимальная цена скидки
COALESCE(ps.min_price, pd2.min_price, p.price) AS final_price
FROM `oc_product` p
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id AND pd.language_id = '1')
LEFT JOIN `oc_review` r ON (p.product_id = r.product_id AND r.status = '1')
LEFT JOIN (
SELECT product_id, MIN(price) AS min_price
FROM `oc_product_discount`
WHERE customer_group_id = '1'
AND ((date_start = '000 in /sites/tent-chehol.com/system/library/db/mysqli.php on line 43