Распродажа

Сортировать:
  • По убыванию цены
  • По возрастанию цены
  • По новизне ↓
  • По популярности

MySQL Query Error: SELECT fp6.PROPERTY_29 AS ID FROM b_iblock_element f LEFT JOIN b_iblock_element_prop_s6 AS fp6 ON fp6.IBLOCK_ELEMENT_ID = f.ID LEFT JOIN b_iblock_element_prop_s5 AS fp5 ON fp5.IBLOCK_ELEMENT_ID = fp6.PROPERTY_29 LEFT JOIN b_catalog_price AS p51 ON p51.PRODUCT_ID = f.ID AND p51.CATALOG_GROUP_ID = LEFT JOIN b_catalog_price AS p52 ON p52.PRODUCT_ID = f.ID AND p52.CATALOG_GROUP_ID = LEFT JOIN b_catalog_price AS p53 ON p53.PRODUCT_ID = f.ID AND p53.CATALOG_GROUP_ID = 221 LEFT JOIN b_catalog_price AS p54 ON p54.PRODUCT_ID = f.ID AND p54.CATALOG_GROUP_ID = 52 WHERE f.IBLOCK_ID = 6 AND fp5.PROPERTY_126 > 0 AND p51.PRICE > 0 AND p52.PRICE > 0 AND p53.PRICE > 0 AND p54.PRICE > 0 GROUP BY fp6.PROPERTY_29 [[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 'JOIN b_catalog_price AS p52 ON p52.PRODUCT_ID = f.ID AND p52.CATALOG_GROUP_ID = ' at line 7]
MySQL Query Error!