/ Каталог

Каталог

Exception: Query error 23000: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'shop_group_id' in where clause is ambiguous. Query: SELECT SQL_CALC_FOUND_ROWS `shop_items`.* FROM `shop_items` LEFT OUTER JOIN `shop_items` AS `shortcut_items` ON `shortcut_items`.`id` = `shop_items`.`shortcut_id` WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2020-04-02 21:19:26' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2020-04-02 21:19:26' 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_group_id` NOT IN (613, 614, 615, 616, 617, 618, 619, 620, 621) AND ( `shortcut_items`.`id` IS NULL OR `shortcut_items`.`active` = 1 AND `shortcut_items`.`deleted` = 0 AND ( `shortcut_items`.`start_datetime` < '2020-04-02 21:19:26' OR `shortcut_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shortcut_items`.`end_datetime` > '2020-04-02 21:19:26' OR `shortcut_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shortcut_items`.`siteuser_group_id` IN (0, -1) ) AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0 ORDER BY `shop_items`.`sorting` DESC, `shop_items`.`name` DESC LIMIT 20 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
1013 modules/shop/controller/show.php
516 hostcmsfiles/lib/lib_6/lib_6.php
278 modules/lib/model.php
166 modules/core/page.php
616 templates/template60/template.htm
103 modules/template/model.php
166 modules/core/page.php
261 templates/template48/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
240 index.php