Форум

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 '1965d246-9e86-11e5-898e-382c4aaffa50'))))
            AND ((((BE.IBLOCK_ID = '1'))))
            AND ((((FPV0.VALUE LIKE 'Юни'))))
         )
         AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))