Код |
---|
SEL ECT BE.ID as ID,BE.XML_ID as XML_ID,BE.TMP_ID as TMP_ID FR OM 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.CODE='CML2_SUPPLIER' INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((BE.XML_ID LIKE '2c5793d8-0511-11e5-aa97-382c4aaffa50')))) AND ((((BE.IBLOCK_ID = '4')))) AND ((((BE.CODE LIKE 'ada7b42227d2bb36e433c559399cbb39')))) AND ((((FPV0.VALUE LIKE 'ЗАО Авто-Евро')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) LIMIT 1 |