Exception: Query error 1054: Unknown column 'shop_discounts.active' 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`))) AS `absolute_price` FROM `shop_items` LEFT OUTER JOIN `shop_items` AS `modifications` ON `modifications`.`modification_id` = `shop_items`.`id` LEFT OUTER JOIN `shop_item_discounts` AS `shop_item_discounts_mod` ON `shop_item_discounts_mod`.`shop_item_id` = `modifications`.`id` LEFT OUTER JOIN `shop_discounts` AS `shop_discounts_mod` ON `shop_discounts_mod`.`id` = `shop_item_discounts_mod`.`shop_discount_id` WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2024-03-28 21:20:46' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-03-28 21:20:46' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND ( `shop_discounts`.`active` = 1 AND `shop_discounts`.`start_datetime` < '2024-03-28 21:20:46' AND `shop_discounts`.`end_datetime` > '2024-03-28 21:20:46' AND `shop_discounts`.`deleted` = 0 OR `shop_discounts_mod`.`active` = 1 AND `shop_discounts_mod`.`start_datetime` < '2024-03-28 21:20:46' AND `shop_discounts_mod`.`end_datetime` > '2024-03-28 21:20:46' AND `shop_discounts_mod`.`deleted` = 0 ) AND `shop_items`.`active` = 1 AND ( `shop_items`.`shop_group_id` = 807 AND `shop_items`.`modification_id` = 0 ) AND `shop_items`.`deleted` = 0 AND `shop_items`.`modification_id` = 0 GROUP BY `shop_items`.`id`
35 modules/core/exception.php
654 modules/core/database/mysql.php
60 modules/core/querybuilder/statement.php
1975 modules/extendedfilters/shop.php
542 modules/extendedfilters/shop.php
689 modules/extendedfilters/shop.php
377 modules/extendedfilters/shop.php
504 hostcmsfiles/lib/lib_48/lib_config_48.php
405 modules/core/command/controller/default.php
190 modules/core/router/route.php
245 index.php