Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'shop_item_discounts'. Query: SELECT SQL_CALC_FOUND_ROWS `shop_items`.*, IF (`shop_items`.`shop_currency_id` = '3', IF (shop_discounts.value, IF(shop_discounts.type, price * 60.6227 - shop_discounts.value, price * (100 - shop_discounts.value) * 60.6227 / 100), shop_items.price * 60.6227), IF (`shop_items`.`shop_currency_id` = '2', IF (shop_discounts.value, IF(shop_discounts.type, price * 69.4494 - shop_discounts.value, price * (100 - shop_discounts.value) * 69.4494 / 100), shop_items.price * 69.4494), IF (`shop_items`.`shop_currency_id` = '1', IF (shop_discounts.value, IF(shop_discounts.type, price * 1 - shop_discounts.value, price * (100 - shop_discounts.value) * 1 / 100), shop_items.price * 1), price))) AS `absolute_price` FROM `shop_items` INNER JOIN `shop_item_discounts` ON `shop_item_discounts`.`shop_item_id` = `shop_items`.`id` INNER JOIN `shop_discounts` ON `shop_discounts`.`id` = `shop_item_discounts`.`shop_discount_id` 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` >= '2024-05-08 07:53:28' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' AND `shop_discounts`.`start_datetime` <= '2024-05-08 07:53:28' ) WHERE `shop_items`.`shop_id` = '2' AND ( `shop_items`.`start_datetime` < '2024-05-08 07:53:28' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-05-08 07:53:28' 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-05-08 07:53:28' AND `shop_discounts`.`end_datetime` > '2024-05-08 07:53:28' AND `shop_discounts`.`deleted` = 0 AND `shop_items`.`modification_id` = 0 AND `modification_id` = 0 AND `shortcut_id` = 0 AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0 ORDER BY `absolute_price` ASC LIMIT 20 OFFSET 0
modules/core/database/pdo.php:630 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/core/orm.php:518 Core_QueryBuilder_Statement->execute
modules/core/entity.php:531 Core_ORM->findAll
modules/shop/controller/show.php:1144 Core_Entity->findAll
hostcmsfiles/lib/lib_54/lib_54.php:582 Shop_Controller_Show->show
modules/lib/model.php:278 include
modules/core/page.php:166 Lib_Model->execute
templates/template15/template.htm:18 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template13/template.htm:144 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/command/controller/hostcms5/default.php:109 Core_Command_Controller_Default->showAction
modules/core/router/route.php:195 Core_Command_Controller_Hostcms5_Default->showAction
index.php:238 Core_Router_Route->execute