Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'shop_item_properties'. Query: SELECT SQL_CALC_FOUND_ROWS `shop_items`.* FROM `shop_items` LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id` LEFT OUTER JOIN `property_value_ints` ON `shop_items`.`id` = `property_value_ints`.`entity_id` AND `shop_item_properties`.`property_id` = property_value_ints.property_id LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id` LEFT OUTER JOIN `property_value_ints` ON `shop_items`.`id` = `property_value_ints`.`entity_id` AND `shop_item_properties`.`property_id` = property_value_ints.property_id WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2020-10-24 05:22:53' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2020-10-24 05:22:53' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND ( `shop_item_properties`.`property_id` = '132' AND ( `property_value_ints`.`value` = '374' OR `property_value_ints`.`value` IS NULL ) ) AND `shop_items`.`modification_id` = 0 AND ( `shop_item_properties`.`property_id` = '132' AND ( `property_value_ints`.`value` = 374 OR `property_value_ints`.`value` IS NULL ) ) AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0 GROUP BY `shop_items`.`id` HAVING COUNT(DISTINCT `shop_item_properties`.`property_id`) = 1 ORDER BY `shop_items`.`sorting` ASC, `shop_items`.`name` ASC LIMIT 12 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
1017 modules/shop/controller/show.php
407 hostcmsfiles/lib/lib_59/lib_59.php
278 modules/lib/model.php
166 modules/core/page.php
18 hostcmsfiles/lib/lib_45/lib_45.php
278 modules/lib/model.php
151 modules/template/section/lib/model.php
801 modules/template/model.php
3 templates/template23/template.htm
103 modules/template/model.php
166 modules/core/page.php
18 hostcmsfiles/lib/lib_45/lib_45.php
278 modules/lib/model.php
151 modules/template/section/lib/model.php
801 modules/template/model.php
81 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
Перезвоните мне!

Закажите обратный звонок и мы Вам обязательно перезвоним

Внимание! закрыть и не показывать ×