Сексшоп в СПб

ЛИДЕР ПРОДАЖ

Производители

[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