MySQL server has gone away
SELECT count(i.`i_id`) as all_items,
i.*,
coalesce(nullif(i.`i_price_action`, 0), i.`i_price`) AS 'price'
, SUM(`is_quantity_2`+`is_quantity`) as quantity_all
-- , (SELECT (SUM(`is_quantity_2`)+SUM(`is_quantity`)) FROM `items_subitem` WHERE `is_i_id` = i.`i_id`) as quantity_all
,v1.iv_id AS v1_id, v1.iv_value_ru AS 'value1', av1.ia_title_ru AS attr1_name
,v2.iv_id AS v2_id, v2.iv_value_ru AS 'value2', av2.ia_title_ru AS attr2_name
,v3.iv_id AS v3_id, v3.iv_value_ru AS 'value3', av3.ia_title_ru AS attr3_name
FROM items i
LEFT JOIN `items_subitem` ON `items_subitem`.`is_i_id` = i.`i_id`
LEFT JOIN `items_attribute_value` iav1 ON i.i_id=iav1.iav_i_id AND iav1.iav_ia_id=47
LEFT JOIN `items_values` v1 ON iav1.iav_iv_id = v1.iv_id
LEFT JOIN `items_attributes` av1 ON iav1.iav_ia_id = av1.ia_id
LEFT JOIN `items_attribute_value` iav2 ON i.i_id=iav2.iav_i_id AND iav2.iav_ia_id=47
LEFT JOIN `items_values` v2 ON iav2.iav_iv_id = v2.iv_id
LEFT JOIN `items_attributes` av2 ON iav2.iav_ia_id = av2.ia_id
LEFT JOIN `items_attribute_value` iav3 ON i.i_id=iav3.iav_i_id AND iav3.iav_ia_id=48
LEFT JOIN `items_values` v3 ON iav3.iav_iv_id = v3.iv_id
LEFT JOIN `items_attributes` av3 ON iav3.iav_ia_id = av3.ia_id
WHERE `i_show_sayt` = 1 AND `i_ic_id` IN (27)
AND (
v1.iv_id = '718' OR
v2.iv_id = '717')
AND (
v3.iv_id = '721')
GROUP BY i.`i_id`
HAVING quantity_all > 0
--
;
