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 LEFT OUTER JOIN `shop_groups` AS `sg` ON `sg`.`id` = `shop_items`.`shop_group_id` WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2024-03-28 16:23:11' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-03-28 16:23:11' 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` = '380' 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` = 380 OR `property_value_ints`.`value` IS NULL ) ) AND `shop_items`.`active` = 1 AND `shop_items`.`shortcut_id` = 0 AND ( `sg`.`active` = 1 AND `sg`.`deleted` = 0 AND `sg`.`siteuser_group_id` IN (0, -1) OR `sg`.`id` IS NULL ) 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
modules/core/database/pdo.php:675 Core_Exception->__construct
modules/core/querybuilder/statement.php:78 Core_DataBase_Pdo->query
modules/core/orm.php:522 Core_QueryBuilder_Statement->execute
modules/core/entity.php:581 Core_ORM->findAll
modules/shop/controller/show.php:1178 Core_Entity->findAll
hostcmsfiles/lib/lib_59/lib_59.php:407 Shop_Controller_Show->show
modules/lib/model.php:284 include
modules/core/page.php:166 Lib_Model->execute
hostcmsfiles/lib/lib_45/lib_45.php:18 Core_Page->execute
modules/lib/model.php:284 include
modules/template/section/lib/model.php:167 Lib_Model->execute
modules/template/model.php:794 Template_Section_Lib_Model->execute
templates/template23/template.htm:3 Template_Model->showSection
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
hostcmsfiles/lib/lib_45/lib_45.php:18 Core_Page->execute
modules/lib/model.php:284 include
modules/template/section/lib/model.php:167 Lib_Model->execute
modules/template/model.php:794 Template_Section_Lib_Model->execute
templates/template1/template.htm:81 Template_Model->showSection
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:580 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:234 Core_Router_Route->execute
Перезвоните мне!

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

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