SELECT
BE.ID,
BE.CODE,
BEPS.PROPERTY_843 COORDINATES,
GROUP_CONCAT(BP228M.VALUE SEPARATOR ';') PHONE,
CONCAT_WS(', ', BEPS.PROPERTY_90, BEPS.PROPERTY_844) ADDRESS,
BE.NAME,
BE.PREVIEW_TEXT,
BE.ID DISTRIBUTOR_ID
FROM b_iblock_element_prop_s3 BEPS
LEFT JOIN b_iblock_element BE ON BE.ID=BEPS.IBLOCK_ELEMENT_ID
LEFT JOIN b_iblock_element_prop_m3 BP228M ON BP228M.IBLOCK_ELEMENT_ID=BE.ID AND BP228M.IBLOCK_PROPERTY_ID=228
WHERE BE.ACTIVE='Y'
GROUP BY BE.ID
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
SELECT
BE.ID,
BE.CODE,
BEPS.PROPERTY_862 COORDINATES,
BEPS.PROPERTY_230 PHONE,
BEPS.PROPERTY_840 ADDRESS,
BE.NAME,
BE.PREVIEW_TEXT,
BEPS.PROPERTY_168 DISTRIBUTOR_ID
FROM b_iblock_element_prop_s16 BEPS
LEFT JOIN b_iblock_element BE ON BE.ID=BEPS.IBLOCK_ELEMENT_ID
WHERE BE.ACTIVE='Y'
GROUP BY BE.ID
SELECT
BE.ID,
BE.CODE,
BEPS.PROPERTY_169 COORDINATES,
BEPS.PROPERTY_231 PHONE,
BEPS.PROPERTY_846 ADDRESS,
BE.NAME,
BE.PREVIEW_TEXT,
BEPS.PROPERTY_170 DISTRIBUTOR_ID
FROM b_iblock_element_prop_s17 BEPS
LEFT JOIN b_iblock_element BE ON BE.ID=BEPS.IBLOCK_ELEMENT_ID
WHERE BE.ACTIVE='Y'
GROUP BY BE.ID
SELECT
BE.ID,
BE.CODE,
BEPS.PROPERTY_171 COORDINATES,
BEPS.PROPERTY_232 PHONE,
BEPS.PROPERTY_847 ADDRESS,
BE.NAME,
BE.PREVIEW_TEXT,
BEPS.PROPERTY_172 DISTRIBUTOR_ID
FROM b_iblock_element_prop_s18 BEPS
LEFT JOIN b_iblock_element BE ON BE.ID=BEPS.IBLOCK_ELEMENT_ID
WHERE BE.ACTIVE='Y'
GROUP BY BE.ID
Мы используем cookie с целью сохранения информации о сеансе, повышения уровня безопасности во время проведения сеанса онлайн и для предоставления действенной рекламы, специально разработанной для удовлетворения требований посетителя.
