Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shop_items.id' in 'on clause'. Query: SELECT DISTINCT STRAIGHT_JOIN SQL_CALC_FOUND_ROWS `shop_items`.*, IF(`shop_items`.`modification_id` > 0, `shop_items`.`modification_id`, `shop_items`.`id`) AS `dataTmpId`
FROM `shop_filter1`
INNER JOIN `shop_filter_group1` ON `shop_filter1`.`shop_group_id` = `shop_filter_group1`.`child_id` AND `shop_filter_group1`.`shop_group_id` = '1110'
LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_items`.`id`
INNER JOIN `shop_items` ON `shop_items`.`id` = `shop_filter1`.`shop_item_id`
WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2026-04-11 13:44:32' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2026-04-11 13:44:32' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_filter1`.`property490` = 1723 AND `shop_items`.`active` = 1 AND `shop_items`.`closed` = 0 AND `shop_items`.`deleted` = 0
GROUP BY `dataTmpId`
ORDER BY
CASE
WHEN shop_items.price > 0
AND SUM(IFNULL(shop_warehouse_items.count,0)) > 0
AND NOT EXISTS (
SELECT 1
FROM property_value_ints p
WHERE p.entity_id = shop_items.shop_group_id
AND p.property_id = 652
AND p.value = 1
)
THEN 0

WHEN shop_items.price > 0
THEN 1

ELSE 2
END
, `shop_items`.`sorting` ASC
LIMIT 16
OFFSET 0
modules/core/database/pdo.php:679 Core_Exception->__construct
modules/core/querybuilder/statement.php:86 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:1543 Core_Entity->findAll
modules/shop/controller/show.php:1846 Shop_Controller_Show->getShopItems
hostcmsfiles/lib/lib_67/lib_67.php:506 Shop_Controller_Show->show
modules/lib/model.php:389 include
modules/core/page.php:179 Lib_Model->execute
templates/template11/template.htm:194 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:179 Template_Model->execute
templates/template1/template.htm:405 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:179 Template_Model->execute
modules/core/command/controller/default.php:723 Core_Page->execute
modules/core/router/route.php:280 Core_Command_Controller_Default->showAction
modules/core/router/route.php:290 Core_Router_Route->{closure}
index.php:404 Core_Router_Route->execute