Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN `oc_category_path` cp ON (cp.category_id = 367) AND cp.path_id = 367 G' at line 51<br />Error No: 1064<br />SELECT p.product_id,
pd.name,
p.model,
p.price,
p.sku,
p.upc,
p.ean,
p.jan,
p.isbn,
p.mpn,
p.quantity,
p.weight,
p.length,
p.width,
p.height,
p.subtract,
p.tax_class_id,
p.date_available,
p.status,
p.date_added,
p.date_modified,
p.viewed,
p.sort_order,
p.image,
p.manufacturer_id,
-- Агрегатные данные
AVG(r.rating) AS rating,
COUNT(r.product_id) AS reviews,
-- Цены со скидками и спецпредложениями
COALESCE(pd2.price, p.price) AS price_final,
ps.price AS in /sites/tent-chehol.com/system/library/db/mysqli.php on line 43