SELECT
COUNT(bie.ID) as qty
FROM
b_iblock_element bie
INNER JOIN
b_iblock_element_prop_s46 prop
ON
prop.IBLOCK_ELEMENT_ID=bie.ID
WHERE
bie.IBLOCK_ID=46
AND bie.ACTIVE="Y"
AND prop.PROPERTY_279>0
AND prop.PROPERTY_276="zhenshchinam" AND prop.PROPERTY_277="zhenskiy-svitshot"
AND prop.PROPERTY_275="mops" AND prop.PROPERTY_274="sobaki"
LIMIT 3000
SELECT
bie.ID as goodId,
prop.PROPERTY_280 as minPrice,
prop.PROPERTY_272 as designName,
prop.PROPERTY_273 as productName,
prop.PROPERTY_276 as sectionFirst,
prop.PROPERTY_277 as sectionSecond
FROM
b_iblock_element bie
INNER JOIN
b_iblock_element_prop_s46 prop
ON
prop.IBLOCK_ELEMENT_ID=bie.ID
WHERE
bie.IBLOCK_ID=46
AND bie.ACTIVE="Y"
AND prop.PROPERTY_279>0
AND prop.PROPERTY_276="zhenshchinam" AND prop.PROPERTY_277="zhenskiy-svitshot"
AND prop.PROPERTY_275="mops" AND prop.PROPERTY_274="sobaki"
ORDER BY bie.SORT ASC, bie.SHOW_COUNTER DESC LIMIT 24,24