Ваш город:   Москва
Каталог товаров
< Главная
  Каталог
[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (0)  (400)
SELECT 
	`sale_internals_basket`.`ID` AS `ID`,
	`sale_internals_basket`.`LID` AS `LID`,
	`sale_internals_basket`.`FUSER_ID` AS `FUSER_ID`,
	`sale_internals_basket`.`ORDER_ID` AS `ORDER_ID`,
	`sale_internals_basket`.`PRODUCT_ID` AS `PRODUCT_ID`,
	`sale_internals_basket`.`PRODUCT_PRICE_ID` AS `PRODUCT_PRICE_ID`,
	`sale_internals_basket`.`PRICE_TYPE_ID` AS `PRICE_TYPE_ID`,
	`sale_internals_basket`.`NAME` AS `NAME`,
	`sale_internals_basket`.`PRICE` AS `PRICE`,
	`sale_internals_basket`.`CURRENCY` AS `CURRENCY`,
	`sale_internals_basket`.`BASE_PRICE` AS `BASE_PRICE`,
	`sale_internals_basket`.`VAT_INCLUDED` AS `VAT_INCLUDED`,
	`sale_internals_basket`.`DATE_INSERT` AS `DATE_INSERT`,
	`sale_internals_basket`.`DATE_UPDATE` AS `DATE_UPDATE`,
	`sale_internals_basket`.`DATE_REFRESH` AS `DATE_REFRESH`,
	`sale_internals_basket`.`WEIGHT` AS `WEIGHT`,
	`sale_internals_basket`.`QUANTITY` AS `QUANTITY`,
	`sale_internals_basket`.`DELAY` AS `DELAY`,
	`sale_internals_basket`.`CAN_BUY` AS `CAN_BUY`,
	`sale_internals_basket`.`MODULE` AS `MODULE`,
	`sale_internals_basket`.`PRODUCT_PROVIDER_CLASS` AS `PRODUCT_PROVIDER_CLASS`,
	`sale_internals_basket`.`NOTES` AS `NOTES`,
	`sale_internals_basket`.`DETAIL_PAGE_URL` AS `DETAIL_PAGE_URL`,
	`sale_internals_basket`.`DISCOUNT_PRICE` AS `DISCOUNT_PRICE`,
	`sale_internals_basket`.`CATALOG_XML_ID` AS `CATALOG_XML_ID`,
	`sale_internals_basket`.`PRODUCT_XML_ID` AS `PRODUCT_XML_ID`,
	`sale_internals_basket`.`DISCOUNT_NAME` AS `DISCOUNT_NAME`,
	`sale_internals_basket`.`DISCOUNT_VALUE` AS `DISCOUNT_VALUE`,
	`sale_internals_basket`.`DISCOUNT_COUPON` AS `DISCOUNT_COUPON`,
	`sale_internals_basket`.`VAT_RATE` AS `VAT_RATE`,
	`sale_internals_basket`.`SUBSCRIBE` AS `SUBSCRIBE`,
	`sale_internals_basket`.`RESERVED` AS `RESERVED`,
	`sale_internals_basket`.`RESERVE_QUANTITY` AS `RESERVE_QUANTITY`,
	`sale_internals_basket`.`BARCODE_MULTI` AS `BARCODE_MULTI`,
	`sale_internals_basket`.`CUSTOM_PRICE` AS `CUSTOM_PRICE`,
	`sale_internals_basket`.`DIMENSIONS` AS `DIMENSIONS`,
	`sale_internals_basket`.`TYPE` AS `TYPE`,
	`sale_internals_basket`.`SET_PARENT_ID` AS `SET_PARENT_ID`,
	`sale_internals_basket`.`MEASURE_CODE` AS `MEASURE_CODE`,
	`sale_internals_basket`.`MEASURE_NAME` AS `MEASURE_NAME`,
	`sale_internals_basket`.`CALLBACK_FUNC` AS `CALLBACK_FUNC`,
	`sale_internals_basket`.`ORDER_CALLBACK_FUNC` AS `ORDER_CALLBACK_FUNC`,
	`sale_internals_basket`.`CANCEL_CALLBACK_FUNC` AS `CANCEL_CALLBACK_FUNC`,
	`sale_internals_basket`.`PAY_CALLBACK_FUNC` AS `PAY_CALLBACK_FUNC`,
	`sale_internals_basket`.`RECOMMENDATION` AS `RECOMMENDATION`,
	`sale_internals_basket`.`SORT` AS `SORT`
FROM `b_sale_basket` `sale_internals_basket` 

WHERE `sale_internals_basket`.`DATE_INSERT` >= '1970-01-01 00:00:00'
AND (`sale_internals_basket`.`ORDER_ID` IS NOT NULL AND `sale_internals_basket`.`ORDER_ID` <> 0)
AND (`sale_internals_basket`.`PRODUCT_ID` not in (30281, 30358, 34010))
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
	/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
	/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:3193
#2: Bitrix\Main\ORM\Query\Query->query(string)
	/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:806
#3: Bitrix\Main\ORM\Query\Query->exec()
	/home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php:457
#4: Bitrix\Main\ORM\Data\DataManager::getList(array)
	/home/bitrix/www/local/modules/clickkey.main/lib/Util/Hit.php:24
#5: Clickkey\Main\Util\Hit::Get()
	/home/bitrix/www/local/templates/goodki/components/bitrix/catalog.section/.default/result_modifier.php:72
#6: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:877
#7: CBitrixComponentTemplate->__IncludeMutatorFile(array, array)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:784
#8: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:735
#9: CBitrixComponent->showComponentTemplate()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:683
#10: CBitrixComponent->includeComponentTemplate()
	/home/bitrix/www/bitrix/modules/iblock/lib/component/base.php:4147
#11: Bitrix\Iblock\Component\Base->loadData()
	/home/bitrix/www/bitrix/modules/iblock/lib/component/elementlist.php:1167
#12: Bitrix\Iblock\Component\ElementList->loadData()
	/home/bitrix/www/bitrix/modules/iblock/lib/component/base.php:4126
#13: Bitrix\Iblock\Component\Base->initialLoadAction()
	/home/bitrix/www/bitrix/components/bitrix/catalog.section/class.php:333
#14: CatalogSectionComponent->initialLoadAction()
	
#15: call_user_func(array)
	/home/bitrix/www/bitrix/modules/iblock/lib/component/base.php:4311
#16: Bitrix\Iblock\Component\Base->doAction()
	/home/bitrix/www/bitrix/modules/iblock/lib/component/base.php:4329
#17: Bitrix\Iblock\Component\Base->executeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:638
#18: CBitrixComponent->includeComponent(string, array, object)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1038
#19: CAllMain->IncludeComponent(string, string, array, object)
	/home/bitrix/www/local/templates/goodki/components/bitrix/catalog/main/section.php:305
#20: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:720
#21: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:815
#22: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:735
#23: CBitrixComponent->showComponentTemplate()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:683
#24: CBitrixComponent->includeComponentTemplate(string)
	/home/bitrix/www/bitrix/components/bitrix/catalog/component.php:171
#25: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:594
#26: CBitrixComponent->__includeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:653
#27: CBitrixComponent->includeComponent(string, array, boolean)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1038
#28: CAllMain->IncludeComponent(string, string, array, boolean)
	/home/bitrix/www/catalog/index.php:1686
#29: include_once(string)
	/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:159
#30: include_once(string)
	/home/bitrix/www/bitrix/urlrewrite.php:2