Каталог

MySQL Query Error: SELECT BE.ID IBLOCK_ELEMENT_ID ,BEP.IBLOCK_PROPERTY_ID ,BEP.VALUE ,BEP.VALUE_NUM ,BEP.ID PROPERTY_VALUE_ID ,BEP.DESCRIPTION FROM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID INNER JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.ID=19 INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID left join b_catalog_product as PRD on (PRD.ID = BE.ID) left join b_catalog_price as PRC_5 on (PRC_5.PRODUCT_ID = BE.ID and PRC_5.CATALOG_GROUP_ID = 5 and ((PRC_5.QUANTITY_FROM <= 1 or PRC_5.QUANTITY_FROM IS NULL) and (PRC_5.QUANTITY_TO >= 1 or PRC_5.QUANTITY_TO IS NULL))) LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID AND BEP.IBLOCK_PROPERTY_ID IN (19, 76, 77, 78, 79, 80, 81, 82, 83, 85, 86, 99, 107, 175, 425, 428, 443, 444, 445, 446, 447, 449, 450, 491, 492)WHERE 1=1 AND ( ((((BE.IBLOCK_ID = '4')))) AND ((((BE.ACTIVE='Y')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND (((FPV0.VALUE_NUM IN ('75623', '73171', '61005', '59994', '59995', '59996', '59589', '48198', '48218', '48200', '49339', '48006', '47198', '45754', '46694', '46684', '45753', '44189', '44182', '43667', '27352')))) AND ((((PRD.AVAILABLE='Y')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY BEP.IBLOCK_ELEMENT_ID, BEP.IBLOCK_PROPERTY_ID, BEP.ID [[3] Error writing file '/tmp/MYa950NO' (Errcode: 28 - No space left on device)]

DB query error. Please try later.