Warning: mysqli::query(): MySQL server has gone away in /home/admin/web/lamp-nn.ru/public_html/system/database/mysqliz.php on line 19Warning: mysqli::query(): Error reading result set's header in /home/admin/web/lamp-nn.ru/public_html/system/database/mysqliz.php on line 19Notice: Error: MySQL server has gone away
Error No: 2006
SELECT SQL_CALC_FOUND_ROWS DISTINCT p.product_id FROM lamp_product p INNER JOIN (SELECT product_id, price, customer_group_id, date_start, date_end FROM lamp_product_special WHERE customer_group_id = '1' AND (date_start = '0000-00-00' OR date_start < '2019-12-09 12:51:00') AND (date_end = '0000-00-00' OR date_end > '2019-12-09 12:51:00') GROUP BY product_id) ps ON (ps.product_id = p.product_id) LEFT JOIN (SELECT product_id, price FROM lamp_product_discount WHERE customer_group_id = '1' AND quantity = '1' AND (date_start = '0000-00-00' OR date_start < '2019-12-09 12:51:00') AND (date_end = '0000-00-00' OR date_end > '2019-12-09 12:51:00') GROUP BY product_id) pd2 ON (pd2.product_id = p.product_id) LEFT JOIN lamp_product_description pd ON (pd.product_id=p.product_id) LEFT JOIN lamp_product_to_store p2s ON(p.product_id=p2s.product_id) WHERE p.status = '1' AND p.date_available <= '2019-12-09 12:51:00' AND p2s.store_id =0 AND pd.language_id = '1' AND COALESCE(pd2.price, ps.price, p.price) >=0 AND p.manufacturer_id IN(314) ORDER BY p.quantity=0, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,1 in /home/admin/web/lamp-nn.ru/public_html/system/database/mysqliz.php on line 53