Примеры запросов
SELECT s.ID, s.NAME, COUNT(e.ID) as PRODUCT_COUNT FROM b_iblock_section s LEFT JOIN b_iblock_element e ON e.IBLOCK_SECTION_ID = s.ID AND e.IBLOCK_ID = 27 WHERE s.IBLOCK_ID = 27 GROUP BY s.ID ORDER BY s.NAME ASC
SELECT e.ID, e.NAME, e.CODE FROM b_iblock_element e WHERE e.IBLOCK_ID = 27 LIMIT 10
SELECT e.ID, e.NAME, p.PRICE FROM b_iblock_element e LEFT JOIN b_catalog_price p ON e.ID = p.PRODUCT_ID WHERE e.IBLOCK_ID = 27 AND p.CATALOG_GROUP_ID = 1 LIMIT 10