SELECT COUNT(DISTINCT a.id) AS cnt FROM
b_iblock_element AS a LEFT JOIN b_iblock_element_property AS raz
ON a.id = raz.iblock_element_id && raz.iblock_property_id="22"
LEFT JOIN
b_iblock_element_property AS price ON a.id = price.iblock_element_id && price.iblock_property_id="19"
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 wid ON a.id = wid.iblock_element_id && wid.iblock_property_id="26"
LEFT JOIN
b_iblock_element_property AS dia ON a.id = dia.iblock_element_id && dia.iblock_property_id="27"
LEFT JOIN
b_iblock_element_property AS nal ON a.id = nal.iblock_element_id && nal.iblock_property_id="116"
LEFT JOIN
b_iblock_element_property AS artik ON a.id = artik.iblock_element_id && artik.iblock_property_id="105"
LEFT JOIN
b_iblock_element_property AS ship ON a.id = ship.iblock_element_id && ship.iblock_property_id="44"
LEFT JOIN
b_iblock_element_property AS pro ON a.id = pro.iblock_element_id && pro.iblock_property_id="64"
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 ind ON a.id = ind.iblock_element_id && ind.iblock_property_id="31"
LEFT JOIN
b_file AS f
ON a.detail_picture = f.id,
b_iblock_element AS b,
b_iblock_element_property AS brand
WHERE
a.iblock_section_id="41" &&
a.id = brand.iblock_element_id && brand.iblock_property_id="39" && b.id = brand.value
&& price.value <= 74865
