SELECT COUNT(DISTINCT a.id) AS cnt FROM
b_iblock_element AS a LEFT JOIN
b_file AS f
ON (a.detail_picture = f.id)
LEFT JOIN
b_iblock_element_property AS zim ON a.id = zim.iblock_element_id && zim.iblock_property_id="38"
LEFT JOIN
b_iblock_element_property AS auto ON a.id = auto.iblock_element_id && auto.iblock_property_id="99"
LEFT JOIN
b_iblock_element_property AS nal ON a.id = nal.iblock_element_id && nal.iblock_property_id = ""
LEFT JOIN
b_iblock_element_property AS typ ON a.id = typ.iblock_element_id && typ.iblock_property_id="37"
LEFT JOIN
b_iblock_element_property AS promo ON a.id = promo.iblock_element_id && promo.iblock_property_id="23"
LEFT JOIN
b_iblock_element_property AS prim ON a.id = prim.iblock_element_id && prim.iblock_property_id="33"
LEFT JOIN
b_iblock_element_property AS os ON a.id = os.iblock_element_id && os.iblock_property_id="46"
LEFT JOIN
b_iblock_element_property AS usl ON a.id = usl.iblock_element_id && usl.iblock_property_id="36"
LEFT JOIN
b_iblock_element_property AS trans_typ ON a.id = trans_typ.iblock_element_id && trans_typ.iblock_property_id="103",
b_iblock_element_property AS p
WHERE
a.iblock_section_id = "57" &&
p.iblock_property_id = "39" &&
a.id = p.iblock_element_id &&
p.value = "2086"
GROUP BY a.code GROUP BY a.code