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=3633 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.
|
|