Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'modification_id' doesn't exist in table 'shop_filter3'. Query: SELECT
COUNT(DISTINCT `dataTmpId`) AS `count`, `property138`
FROM ((SELECT
`shop_filter3`.`shop_item_id` AS `dataTmpId`, `property138`
FROM `shop_filter3`
INNER JOIN `shop_filter_group3` ON `shop_filter3`.`shop_group_id` = `shop_filter_group3`.`child_id` AND `shop_filter_group3`.`shop_group_id` = '645'
WHERE 1)
UNION ALL
(SELECT
`shop_filter3`.`shop_item_id` AS `dataTmpId`, `property138`
FROM `shop_filter3` FORCE INDEX (`shop_item_id`)
INNER JOIN `shop_items` ON `shop_filter3`.`shop_item_id` = `shop_items`.`shortcut_id`
INNER JOIN `shop_filter_group3` ON `shop_items`.`shop_group_id` = `shop_filter_group3`.`child_id` AND `shop_filter_group3`.`shop_group_id` = '645'
WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shortcut_id` > 0 AND ( `shop_items`.`start_datetime` < '2023-11-28 20:28:39' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2023-11-28 20:28:39' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`active` = 1)
UNION ALL
(SELECT
`shop_filter3`.`shop_item_id` AS `dataTmpId`, `property138`
FROM `shop_filter3` FORCE INDEX (`modification_id`)
INNER JOIN `shop_items` ON `shop_filter3`.`modification_id` = `shop_items`.`shortcut_id`
INNER JOIN `shop_filter_group3` ON `shop_items`.`shop_group_id` = `shop_filter_group3`.`child_id` AND `shop_filter_group3`.`shop_group_id` = '645'
WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shortcut_id` > 0 AND ( `shop_items`.`start_datetime` < '2023-11-28 20:28:39' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2023-11-28 20:28:39' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`active` = 1)) AS `filterProperty`
GROUP BY `property138`
modules/core/database/pdo.php:680 Core_Exception->__construct
modules/core/querybuilder/statement.php:87 Core_DataBase_Pdo->query
modules/shop/controller/show.php:1769 Core_QueryBuilder_Statement->execute
modules/shop/controller/show.php:1368 Shop_Controller_Show->_itemsProperties
templates/template60/template.htm:108 Shop_Controller_Show->show
modules/template/model.php:103 include
modules/core/page.php:168 Template_Model->execute
templates/template58/template.htm:211 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:168 Template_Model->execute
modules/core/command/controller/default.php:604 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:239 Core_Router_Route->execute
modules/core/database/pdo.php:680 Core_Exception->__construct
modules/core/querybuilder/statement.php:87 Core_DataBase_Pdo->query
modules/shop/controller/show.php:1769 Core_QueryBuilder_Statement->execute
modules/shop/controller/show.php:1368 Shop_Controller_Show->_itemsProperties
templates/template60/template.htm:108 Shop_Controller_Show->show
modules/template/model.php:103 include
modules/core/page.php:168 Template_Model->execute
templates/template58/template.htm:211 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:168 Template_Model->execute
modules/core/command/controller/default.php:604 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:239 Core_Router_Route->execute