×Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shop_discounts.day7' in 'on clause'. Query: SELECT MIN(t.price_absolute) AS `min`, MAX(t.price_absolute) AS `max` FROM (SELECT IF (`shop_items`.`shop_currency_id` = '3', IF (COUNT(`shop_discounts`.`id`), ((`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)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 28.2 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 28.2), IF (`shop_items`.`shop_currency_id` = '2', IF (COUNT(`shop_discounts`.`id`), ((`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)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 34.49 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 34.49), IF (`shop_items`.`shop_currency_id` = '4', IF (COUNT(`shop_discounts`.`id`), ((`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)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 1 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 1), IF (`shop_items`.`shop_currency_id` = '1', IF (COUNT(`shop_discounts`.`id`), ((`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)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 1 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`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 `price_absolute` FROM `shop_items` LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id` LEFT OUTER JOIN `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` AND `shop_discounts`.`active` = 1 AND `shop_discounts`.`deleted` = 0 AND `shop_discounts`.`day7` = 1 AND `shop_discounts`.`start_time` <= '16:36:10' AND `shop_discounts`.`end_time` >= '16:36:10' AND `shop_discounts`.`start_datetime` <= '2022-06-26 16:36:10' AND ( `shop_discounts`.`end_datetime` >= '2022-06-26 16:36:10' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' ) LEFT OUTER JOIN `shop_taxes` ON `shop_taxes`.`id` = `shop_items`.`shop_tax_id` WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shop_id` = '3' AND `shop_items`.`active` = 1 AND `shop_items`.`shortcut_id` = 0 AND `shop_items`.`shop_group_id` = '857' GROUP BY `shop_items`.`id`) AS `t`
modules/core/database/pdo.php:604 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/shop/controller/show.php:3619 Core_QueryBuilder_Statement->execute
hostcmsfiles/lib/lib_90/lib_90.php:234 Shop_Controller_Show->addMinMaxPrice
modules/lib/model.php:278 include
modules/template/section/lib/model.php:167 Lib_Model->execute
modules/template/model.php:801 Template_Section_Lib_Model->execute
templates/template19/template.htm:6 Template_Model->showSection
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template13/template.htm:94 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:583 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:238 Core_Router_Route->execute