MySQL Query Error: SELECT BP.*, BEP.ID as PROPERTY_VALUE_ID, BEP.VALUE, BEP.DESCRIPTION, BEPE.VALUE VALUE_ENUM, BEPE.XML_ID VALUE_XML_ID, BEPE.SORT VALUE_SORT FROM b_iblock B INNER JOIN b_iblock_property BP ON B.ID=BP.IBLOCK_ID LEFT JOIN b_iblock_element_property BEP ON (BP.ID = BEP.IBLOCK_PROPERTY_ID AND BEP.IBLOCK_ELEMENT_ID = 109666) LEFT JOIN b_iblock_property_enum BEPE ON (BP.PROPERTY_TYPE = 'L' AND BEPE.ID=BEP.VALUE_ENUM AND BEPE.PROPERTY_ID=BP.ID) WHERE B.ID = 18 AND BP.ACTIVE='Y' ORDER BY BP.SORT asc, BP.ID asc, BEPE.SORT asc, BEP.ID asc[MySQL client ran out of memory]
|