Реклама

Каталог организаций

Нерудные материалы

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: 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 '?
AND (
	(
		`sale_location_location_l`.`LEFT_MARGIN` <= `sale_location_location' at line 4 (400)
SELECT 
	`sale_location_location_l`.`ID` AS `ID__`
FROM `b_sale_location` `sale_location_location` 
INNER JOIN `b_sale_location` `sale_location_location_l` ON `sale_location_location_l`.`TYPE_ID` = ?
AND (
	(
		`sale_location_location_l`.`LEFT_MARGIN` <= `sale_location_location`.`LEFT_MARGIN`
		AND `sale_location_location_l`.`RIGHT_MARGIN` >= `sale_location_location`.`RIGHT_MARGIN`
	)
	OR (
		`sale_location_location_l`.`LEFT_MARGIN` >= `sale_location_location`.`LEFT_MARGIN`
		AND `sale_location_location_l`.`RIGHT_MARGIN` <= `sale_location_location`.`RIGHT_MARGIN`
	)
)
WHERE `sale_location_location`.`ID` IN (SELECT 
	`sale_location_site_location_location`.`ID` AS `ID`
FROM `b_sale_loc_2site` `sale_location_site_location` 
INNER JOIN `b_sale_location` `sale_location_site_location_location` ON `sale_location_site_location`.`LOCATION_ID` = `sale_location_site_location_location`.`ID`
AND `sale_location_site_location`.`LOCATION_TYPE` = 'L'
WHERE `sale_location_site_location`.`SITE_ID` = 'ru')
/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/lib/db/mysqlconnection.php:104
#0: Bitrix\Main\DB\MysqlConnection->queryInternal(string, array, NULL)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/lib/db/connection.php:332
#1: Bitrix\Main\DB\Connection->query(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/lib/entity/query.php:1740
#2: Bitrix\Main\Entity\Query->query(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/lib/entity/query.php:454
#3: Bitrix\Main\Entity\Query->exec()
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/sale/lib/saleszone.php:248
#4: Bitrix\Sale\SalesZone::getSelectedTypeIds(string, string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/sale/lib/saleszone.php:286
#5: Bitrix\Sale\SalesZone::getCitiesIds(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/components/beton/sale.ajax.locations/component.php:37
#6: include(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component.php:535
#7: CBitrixComponent->__includeComponent()
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component.php:578
#8: CBitrixComponent->includeComponent(string, array, NULL)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/main.php:1032
#9: CAllMain->IncludeComponent(string, string, array)
	/var/www/beton_ru/data/www/beton.ru/bitrix/templates/.default/components/beton/baza.filter/.default/template.php:26
#10: include(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component_template.php:535
#11: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component_template.php:618
#12: CBitrixComponentTemplate->IncludeTemplate(array)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component.php:657
#13: CBitrixComponent->showComponentTemplate()
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component.php:605
#14: CBitrixComponent->includeComponentTemplate()
	/var/www/beton_ru/data/www/beton.ru/bitrix/components/beton/baza.filter/component.php:828
#15: include(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component.php:535
#16: CBitrixComponent->__includeComponent()
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/component.php:578
#17: CBitrixComponent->includeComponent(string, array, NULL)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/classes/general/main.php:1032
#18: CAllMain->IncludeComponent(string, string, array)
	/var/www/beton_ru/data/www/beton.ru/catalog/index.php:46
#19: include_once(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/modules/main/include/urlrewrite.php:154
#20: include_once(string)
	/var/www/beton_ru/data/www/beton.ru/bitrix/urlrewrite.php:2