Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shop_item_discounts.id' in 'where clause'. Query: SELECT `shop_items`.`id`, `shop_items`.`shortcut_id`, `shop_items`.`shop_group_id`, `shop_items`.`shop_seller_id`, `shop_items`.`shop_producer_id`, `shop_items`.`modification_id`, `shop_items`.`length`, `shop_items`.`width`, `shop_items`.`height`, IF (`shop_items`.`shop_currency_id` = '3', `shop_items`.`price` * 53, IF (`shop_items`.`shop_currency_id` = '2', `shop_items`.`price` * 60, IF (`shop_items`.`shop_currency_id` = '1', `shop_items`.`price` * 1, `shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)))) AS `absolute_price` FROM `shop_items` INNER JOIN `shop_numbers_nested_groups` ON `shop_items`.`shop_group_id` = `shop_numbers_nested_groups`.`n` LEFT OUTER JOIN `shop_taxes` ON `shop_taxes`.`id` = `shop_items`.`shop_tax_id` WHERE `shop_items`.`shop_id` = '3' AND ( `shop_items`.`start_datetime` < '2025-07-06 12:59:26' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2025-07-06 12:59:26' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_item_discounts`.`id` IS NOT NULL AND `shop_items`.`active` = 1 AND `shop_items`.`modification_id` = 0 AND `shop_items`.`deleted` = 0 AND `shop_items`.`modification_id` = 0 GROUP BY `shop_items`.`id`
modules/core/database/pdo.php:604 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/extendedfilters/shop.php:2460 Core_QueryBuilder_Statement->execute
modules/extendedfilters/shop.php:697 Extendedfilters_Shop->getItemsIdAssoc
modules/extendedfilters/shop.php:852 Extendedfilters_Shop->getItems
modules/extendedfilters/shop.php:532 Extendedfilters_Shop->processFilters
hostcmsfiles/lib/lib_124/lib_config_124.php:345 Extendedfilters_Shop->processFiltersToController
modules/core/command/controller/default.php:528 include
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:253 Core_Router_Route->execute