Warning: mysqli::query(): MySQL server has gone away in /var/www/admin/data/www/modna-panyanka.com.ua/system/database/mysqliz.php on line 26Warning: mysqli::query(): Error reading result set's header in /var/www/admin/data/www/modna-panyanka.com.ua/system/database/mysqliz.php on line 26Notice: Error: MySQL server has gone away
Error No: 2006
SELECT p.product_id AS product_id , (ABS(p.price-860)) AS new_price , (SELECT COUNT(*) AS total FROM order_product op WHERE op.product_id = p.product_id) AS orders , p.viewed AS viewed , (SELECT ROUND(IFNULL(AVG(r1.rating), 0)) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1') AS rating , (SELECT COUNT(r2.review_id) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1') AS reviews , (p.manufacturer_id=0) AS manufacture , p.date_added AS date_added FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_attribute pa ON (p.product_id = pa.product_id) LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id ) WHERE pd.language_id = '3' AND p.status = '1' AND p.quantity > 0 AND p2s.store_id = '0' AND pa.attribute_id = '13' AND pa.language_id = '3' AND pa.text = 'Зелений' AND p2c.category_id = '71' ORDER BY new_price ASC, orders DESC, viewed DESC, rating DESC, reviews DESC, manufacture DESC, date_added DESC LIMIT 4 in /var/www/admin/data/www/modna-panyanka.com.ua/system/database/mysqliz.php on line 60