MySQL Query Error: SELECT DISTINCT s.ID as SECTION_ID, s.NAME,s.CODE,pe.VALUE as BRAND, pe.ID, pe.PROPERTY_ID FROM b_iblock_element as e JOIN b_iblock_section_element as se on se.IBLOCK_ELEMENT_ID = e.ID JOIN b_iblock_section as s on s.ID = se.IBLOCK_SECTION_ID JOIN b_iblock_element_property as iep on iep.IBLOCK_ELEMENT_ID=e.ID and iep.IBLOCK_PROPERTY_ID=3631 and iep.VALUE > 0 JOIN b_iblock_element_property as ep on ep.IBLOCK_ELEMENT_ID = e.ID and ep.IBLOCK_PROPERTY_ID = 820 JOIN b_iblock_property_enum as pe on pe.ID = ep.VALUE JOIN b_catalog_price as c on c.PRODUCT_ID = e.ID and CATALOG_GROUP_ID= WHERE e.ACTIVE = 'Y' and c.PRICE > 0 and e.DETAIL_PICTURE is not null and s.ACTIVE = 'Y' and pe.VALUE in ('HIBERG','AVEX','BAFF','NORDFROST','SAMSUNG','LG','GEFEST','ATLANT')[[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE e.ACTIVE = 'Y' and c.PRICE > 0 and e.DETAIL_PICTURE is not nul' at line 10]

DB query error. Please try later.