SELECT
        BE.ID,
        BE.CODE,
        BEPS.PROPERTY_162 COORDINATES,
        BEPS.PROPERTY_229 PHONE,
        CONCAT_WS(', ', BEPS.PROPERTY_849, BEPS.PROPERTY_845) ADDRESS,
        BE.NAME,
        BE.PREVIEW_TEXT,
        BEPS.PROPERTY_165 DISTRIBUTOR_ID
    FROM b_iblock_element_prop_s15 BEPS
    LEFT JOIN b_iblock_element BE ON BE.ID=BEPS.IBLOCK_ELEMENT_ID
LEFT JOIN b_user BU ON BU.ID=BEPS.PROPERTY_848
LEFT JOIN b_uts_user BUTS ON BUTS.VALUE_ID=BU.ID
LEFT JOIN b_iblock_element_prop_s29 BEPS29 ON BEPS29.PROPERTY_834=BU.ID
    WHERE BUTS.UF_SHOW_IN_MASTER_LI=1 AND BU.PERSONAL_PHOTO IS NOT NULL AND BU.PERSONAL_CITY IS NOT NULL AND BEPS29.IBLOCK_ELEMENT_ID IS NOT NULL AND BU.PERSONAL_PHONE<>'' AND BU.ACTIVE='Y'
    GROUP BY BE.ID