[Bitrix\Main\DB\SqlQueryException] Mysql query error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'b_catalog_product.AVAILABLE='Y' order by VALUE' at line 7 (400) SELECT DISTINCT b_iblock_element_property.VALUE FROM b_iblock_element_property join b_catalog_product ON b_catalog_product.ID = b_iblock_element_property.IBLOCK_ELEMENT_ID join b_iblock_property ON b_iblock_element_property.IBLOCK_PROPERTY_ID = b_iblock_property.ID where b_iblock_property.CODE='BRAND_REF' and b_catalog_product.QUANTITY> 1and b_catalog_product.AVAILABLE='Y' order by VALUE /home/admin/web/testvps.erosmania.ru/public_html/bitrix/modules/main/lib/db/mysqliconnection.php:137 #0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL) /home/admin/web/testvps.erosmania.ru/public_html/bitrix/modules/main/lib/db/connection.php:330 #1: Bitrix\Main\DB\Connection->query(string) /home/admin/web/testvps.erosmania.ru/public_html/index.php:397