Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shop_filter14.shop_item_id' in 'on clause'. Query: SELECT
SQL_CALC_FOUND_ROWS
`shop_items`.*, IF(`shop_items`.`modification_id` > 0, `shop_items`.`modification_id`, `shop_items`.`id`) AS `dataTmpId`
FROM `shop_items`
LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_filter14`.`shop_item_id`
LEFT OUTER JOIN `shop_groups` AS `sg` ON `sg`.`id` = `shop_items`.`shop_group_id`
LEFT OUTER JOIN `multiregion_shop_items` ON `multiregion_shop_items`.`entity_id` = IF (shop_items.shortcut_id, shop_items.shortcut_id, shop_items.id) AND `multiregion_shop_items`.`multiregion_id` = 461
WHERE `shop_items`.`shop_id` = '14' AND ( `shop_items`.`start_datetime` < '2025-01-22 13:17:06' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2025-01-22 13:17:06' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_producer_id` = '186' 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`.`closed` = 0 AND ( `multiregion_shop_items`.`active` = 1 OR `multiregion_shop_items`.`id` IS NULL ) AND `shop_items`.`deleted` = 0
GROUP BY `dataTmpId`
ORDER BY SIGN(SUM(`shop_warehouse_items`.`count`)) DESC, `shop_items`.`price` ASC
LIMIT 30
OFFSET 0
modules/core/database/pdo.php:679 Core_Exception->__construct
modules/core/querybuilder/statement.php:87 Core_DataBase_Pdo->query
modules/core/orm.php:551 Core_QueryBuilder_Statement->execute
modules/core/entity.php:620 Core_ORM->findAll
modules/shop/controller/show.php:1502 Core_Entity->findAll
modules/shop/controller/show.php:1802 Shop_Controller_Show->getShopItems
hostcmsfiles/lib/lib_139/lib_139.php:543 Shop_Controller_Show->show
modules/lib/model.php:277 include
modules/core/page.php:176 Lib_Model->execute
templates/template395/template.htm:28 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:176 Template_Model->execute
templates/template391/template.htm:589 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:176 Template_Model->execute
modules/core/command/controller/default.php:621 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:379 Core_Router_Route->execute