Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'shop_warehouse_items'. Query: SELECT SQL_CALC_FOUND_ROWS `shop_items`.* FROM `shop_items` LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_items`.`id` LEFT OUTER JOIN `shop_items` AS `modifications` ON `modifications`.`modification_id` = `shop_items`.`id` LEFT OUTER JOIN `shop_warehouse_items` AS `modifications_shop_warehouse_items` ON `modifications_shop_warehouse_items`.`shop_item_id` = `modifications`.`id` LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_items`.`id` WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2021-05-14 19:20:23' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2021-05-14 19:20:23' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`modification_id` = 0 AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0 GROUP BY `shop_items`.`id` HAVING ( SUM(`shop_warehouse_items`.`count`) > 0 OR SUM(`modifications_shop_warehouse_items`.`count`) > 0 ) ORDER BY `shop_items`.`name` ASC LIMIT 500 OFFSET 0
36 modules/core/exception.php
597 modules/core/database/pdo.php
80 modules/core/querybuilder/statement.php
518 modules/core/orm.php
531 modules/core/entity.php
1032 modules/shop/controller/show.php
24 hostcmsfiles/lib/lib_11/lib_11.php
278 modules/lib/model.php
166 modules/core/page.php
16 templates/template9/template.htm
103 modules/template/model.php
166 modules/core/page.php
271 templates/template1/template.htm
103 modules/template/model.php
166 modules/core/page.php
545 modules/core/command/controller/default.php
195 modules/core/router/route.php
235 index.php