Бра хай-тек

• Выберите стиль:

Выбранные параметры (cбросить):

SELECT el.ID,el.NAME,el.IBLOCK_SECTION_ID,el.CODE,prop.PROPERTY_659,prop.PROPERTY_746,prop.PROPERTY_678 FROM ((b_iblock_element as el INNER JOIN b_iblock_element_prop_s53 as prop ON el.ID = prop.IBLOCK_ELEMENT_ID) INNER JOIN b_catalog_price as price ON el.ID = price.PRODUCT_ID ) WHERE el.IBLOCK_ID=53 and el.IBLOCK_SECTION_ID=2864 and price.CATALOG_GROUP_ID = 1 and (prop.PROPERTY_695 = 118401)