Exception: Query error 1054: Unknown column 'shop_discounts.percent' in 'field list'. Query: SELECT SQL_CALC_FOUND_ROWS `shop_items`.*, IF (`shop_items`.`shop_currency_id` = '3', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 32.988253 / 100, shop_items.price * 32.988253), IF (`shop_items`.`shop_currency_id` = '2', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 63.840654 / 100, shop_items.price * 63.840654), IF (`shop_items`.`shop_currency_id` = '1', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 1 / 100, shop_items.price * 1), IF (`shop_items`.`shop_currency_id` = '4', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 4.000064 / 100, shop_items.price * 4.000064), price)))) AS `absolute_price` 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`.`end_datetime` >= '2019-09-18 19:28:53' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' AND `shop_discounts`.`start_datetime` <= '2019-09-18 19:28:53' ) WHERE `shop_items`.`shop_id` = '5' AND ( `shop_items`.`start_datetime` < '2019-09-18 19:28:53' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2019-09-18 19:28:53' 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 AND ( `shop_items`.`shop_group_id` = 1553 AND `shop_items`.`modification_id` = 0 ) AND `shop_items`.`deleted` = 0 ORDER BY `absolute_price` ASC LIMIT 24 OFFSET 0
36 modules/core/exception.php
645 modules/core/database/mysql.php
80 modules/core/querybuilder/statement.php
518 modules/core/orm.php
531 modules/core/entity.php
941 modules/shop/controller/show.php
484 hostcmsfiles/lib/lib_49/lib_49.php
278 modules/lib/model.php
166 modules/core/page.php
49 templates/template22/template.htm
103 modules/template/model.php
166 modules/core/page.php
165 templates/template20/template.htm
103 modules/template/model.php
166 modules/core/page.php
542 modules/core/command/controller/default.php
195 modules/core/router/route.php
240 index.php