MySQL Query Error:
SELECT
COUNT(DISTINCT BE.ID) AS COUNT
,BEP.IBLOCK_PROPERTY_ID
,BEP.VALUE as VALUE_ID
,BEE.VALUE as VALUE_NAME
FROM
b_iblock_element BE
JOIN b_iblock_section_element BES ON BES.IBLOCK_ELEMENT_ID = BE.ID
JOIN b_catalog_price BCP ON BCP.PRODUCT_ID = BE.ID
JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID
JOIN b_iblock_property_enum BEE ON BEP.VALUE = BEE.ID
JOIN b_iblock_property BP ON BP.ID = BEP.IBLOCK_PROPERTY_ID
WHERE
BES.IBLOCK_SECTION_ID = 375
AND BEP.IBLOCK_PROPERTY_ID IN (499, 500, 501, 502, 405, 492, 406, 546, 535, 820, 825, 815, 398, 835, 846, 848, 850)
AND BE.ACTIVE = 'Y'
AND BCP.CATALOG_GROUP_ID = 23
AND BCP.PRICE > 0
AND BE.ID IN (
SELECT
DISTINCT IBLOCK_ELEMENT_ID
FROM
b_iblock_element_property
WHERE
IBLOCK_PROPERTY_ID = 406 AND VALUE IN (13302)
)
AND BE.ID IN (
SELECT
DISTINCT IBLOCK_ELEMENT_ID
FROM
b_iblock_element_property
WHERE
IBLOCK_PROPERTY_ID = 502 AND VALUE IN (17319, 17319)
)
AND BE.ID IN (
SELECT
DISTINCT IBLOCK_ELEMENT_ID
FROM
b_iblock_element_property
WHERE
IBLOCK_PROPERTY_ID = 492 AND VALUE IN (14739)
)
AND BE.ID IN (
SELECT
DISTINCT IBLOCK_ELEMENT_ID
FROM
b_iblock_element_property
WHERE
IBLOCK_PROPERTY_ID = 425 AND VALUE IN (13801)
)
GROUP BY BEP.IBLOCK_PROPERTY_ID, BEP.VALUE
[[2006] MySQL server has gone away]