INSERT INTO umotors_cache_filters (id, curr_time, path_id, path, list_item_id, list_id, list_item_value, list_item_path, dataplistiAll)
SELECT
CRC32(CONCAT(tt1.paths, '-', tt1.list_item_id)) id
, NOW() curr_time
, CRC32(tt1.paths) path_id
, tt1.paths `path`
, tt1.list_item_id
, tt1.list_id
, tt1.list_item_value
, tt1.list_item_path
, COALESCE((tt2.list_item_id > 0) * 1, 0) dataplistiAll
FROM (SELECT
'/accessory/wiper-blades/enduro/auto/' AS `paths`, `li`.`id` AS `list_item_id`, `li`.`list_id` AS `list_id`, `li`.`value` AS `list_item_value`, `li`.`path` AS `list_item_path`
FROM `shop_items`
LEFT JOIN `property_value_ints` AS `plisti241_0` ON `shop_items`.`id` = `plisti241_0`.`entity_id` AND `plisti241_0`.`value` = 1677 AND `plisti241_0`.`property_id` = 241
INNER JOIN `property_value_ints` AS `pvi_filter` ON `pvi_filter`.`entity_id` = `shop_items`.`id` AND `pvi_filter`.`property_id` IN (241, 1822, 5926, 5927, 159, 4440)
INNER JOIN `properties` AS `p_filter` ON `p_filter`.`id` = `pvi_filter`.`property_id`
INNER JOIN `list_items` AS `li` ON `li`.`id` = `pvi_filter`.`value` AND `li`.`list_id` = p_filter.list_id
WHERE `shop_items`.`shop_id` = 3 AND ( `shop_items`.`start_datetime` < '2024-04-28 14:15:05' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-04-28 14:15:05' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_group_id` IN ('74668') AND `shop_items`.`id` <> shop_items.modification_id AND `shop_items`.`active` = 1 AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0
GROUP BY `li`.`list_id`, `li`.`id`) tt1
LEFT JOIN (SELECT
`li`.`id` AS `list_item_id`
FROM `shop_items`
INNER JOIN `property_value_ints` AS `plisti241_0` ON `shop_items`.`id` = `plisti241_0`.`entity_id` AND `plisti241_0`.`value` = 1677 AND `plisti241_0`.`property_id` = 241
INNER JOIN `property_value_ints` AS `pvi_filter` ON `pvi_filter`.`entity_id` = `shop_items`.`id` AND `pvi_filter`.`property_id` IN (241, 1822, 5926, 5927, 159, 4440)
INNER JOIN `properties` AS `p_filter` ON `p_filter`.`id` = `pvi_filter`.`property_id`
INNER JOIN `list_items` AS `li` ON `li`.`id` = `pvi_filter`.`value` AND `li`.`list_id` = p_filter.list_id
WHERE `shop_items`.`shop_id` = 3 AND ( `shop_items`.`start_datetime` < '2024-04-28 14:15:05' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-04-28 14:15:05' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_group_id` IN ('74668') AND `shop_items`.`id` <> shop_items.modification_id AND `shop_items`.`active` = 1 AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0
GROUP BY `li`.`list_id`, `li`.`id`) tt2 on tt2.list_item_id = tt1.list_item_id
ON DUPLICATE KEY UPDATE curr_time = VALUES(curr_time), path_id = VALUES(path_id), path = VALUES(path)
, list_item_id = VALUES(list_item_id), list_id = VALUES(list_id), list_item_value = VALUES(list_item_value)
, list_item_path = VALUES(list_item_path), dataplistiAll = VALUES(dataplistiAll)
modules/core/database/pdo.php:680 Core_Exception->__construct
modules/core/querybuilder/statement.php:87 Core_DataBase_Pdo->query
libs/modules/moto/module/shop/controller/out.php:1513 Core_QueryBuilder_Statement->execute
libs/modules/moto/module/shop/controller/out.php:1946 Moto_Shop_Controller_Out->addFilterProperties
modules/shop/controller/show.php:2724 Moto_Shop_Controller_Out->_itemCondition
modules/shop/controller/show.php:1453 Shop_Controller_Show->applyItemCondition
modules/shop/controller/show.php:1784 Shop_Controller_Show->getShopItems
vendor/mikeborisov/hostcms-modules/src/utils/module/shop/controller/show.php:944 Shop_Controller_Show->show
libs/modules/moto/module/shop/controller/out.php:2485 Utils_Shop_Controller_Show->show
libs/modules/moto/module/shop/controller/show.php:74 Moto_Shop_Controller_Out->show
hostcmsfiles/lib/lib_43/lib_43.php:354 Moto_Shop_Controller_Show->show
modules/lib/model.php:277 include
modules/core/page.php:177 Lib_Model->execute
templates/template64/template.htm:2 Core_Page->execute
modules/template/model.php:108 include
modules/core/page.php:177 Template_Model->execute
templates/template62/template.htm:408 Core_Page->execute
modules/template/model.php:108 include
modules/core/page.php:177 Template_Model->execute
modules/core/command/controller/default.php:610 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:342 Core_Router_Route->execute