Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT DISTINCT
p.*,
p.quantity > 0 AS available,
ss.name AS stock_status,
m.name AS manufacturer,
wc.unit AS weight_class,
lc.unit AS length_class,
c.name AS category,
c.category_id,
c.template_name,
c.template_h1,
c.template_title,
c.template_description,
c.template_text,
(SELECT COUNT(*) FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews
FROM oc_product p
LEFT JOIN oc_manufacturer m ON p.manufacturer_id = m.manufacturer_id
LEFT JOIN oc_product_to_category p2c ON p.product_id = p2c.product_id AND p2c.main_category = '1'
LEFT JOIN oc_category c ON c.category_id = p2c.category_id
LEFT JOIN oc_stock_status ss ON ss.stock_status_id = p.stock_status_id
LEFT JOIN oc_weight_class wc ON wc.weight_class_id = p.weight_class_id
LEFT JOIN oc_length_class lc ON lc.length_class_id = p.length_class_id
WHERE
p.product_id in /sites/pitomnik-rastenij.ru/system/database/mysqli.php on line 41