Автоматизация Торговли 319758.ru (Все сообщения пользователя)

SEL ECT 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 FR OM 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 = 101426) 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 BP.ACTIVE='Y' ORDER BY BP.SORT asc, BP.ID asc, BEPE.SORT asc, BEP.ID asc

SEL ECT BEP.ID IBLOCK_ELEMENT_ID ,BEP.IBLOCK_PROPERTY_ID ,BEP.VALUE ,BEP.VALUE_NUM FR OM b_iblock_section_element LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BEP.ID AND BEP.VALUE != '' AND BEP.IBLOCK_PROPERTY_ID IN (136, 137, 141, 158, 159, 164, 167, 275, 202, 278, 279, 282, 293, 294, 281, 277, 276, 283, 286, 321) WHERE 1=1 ORDER BY BEP.IBLOCK_ELEMENT_ID 

$strSql = " SEL ECT BEP.ID IBLOCK_ELEMENT_ID ,BEP.IBLOCK_PROPERTY_ID ,BEP.VALUE ,BEP.VALUE_NUM FR OM b_iblock_section_element LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BEP.ID AND BEP.VALUE != ''".(!empty($propertyIDs) ? " AND BEP.IBLOCK_PROPERTY_ID IN (".implode(', ', $propertyIDs).")" : "")." WHERE 1=1 ".$element->sWhere." ORDER BY BEP.IBLOCK_ELEMENT_ID ";