Exception: Query error 1054: Unknown column 'shop_filter1.property22' in 'where 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 (SELECT
`original`.`id`
FROM `shop_items` AS `original`
INNER JOIN `shop_items` AS `modif` ON `modif`.`modification_id` = `original`.`id`
WHERE `original`.`modification_id` = 0 AND `original`.`deleted` = 0 AND `modif`.`deleted` = 0
GROUP BY `original`.`id`
HAVING SUM(`modif`.`active`) > 0) AS `tmp` ON `shop_filter1`.`shop_item_id` = `tmp`.`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` < '2024-04-20 03:34:18' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-04-20 03:34:18' 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_items`.`modification_id` = 0 AND ( `shop_filter1`.`property22` = 'sale' OR `shop_filter1`.`property22` IS NULL ) AND `shop_items`.`active` = 1 AND ( `shop_items`.`shop_group_id` IN ('589', '1765', '2302', '2311', '2310', '2312', '6179', '2282', '6012', '2287', '2298', '2289', '2296', '2291', '2290', '2294', '2300', '2292', '2297', '2293', '2288', '2295', '2452', '2453', '2454', '6046', '2259', '5959', '5971', '2320', '2315', '5957', '5951', '2318', '2319', '2317', '6236', '5958', '5952', '6010', '1023', '2303', '6030', '6031', '2370', '2369', '2371', '2458', '1766', '2306', '2308', '6194', '2307', '6178', '2455', '6181', '2309', '2260', '6005', '6229', '6001', '6000', '6003', '6002', '6004', '6006', '2305', '2391', '2375', '2376', '2387', '2261', '6230', '5961', '2381', '2383', '2349', '2348', '2347', '2382', '5949', '2346', '2336', '5956', '2337', '2396', '2339', '2395', '2340', '2342', '2341', '2338') AND `shop_items`.`shortcut_id` = 0 AND `shop_items`.`modification_id` = 0 OR `shop_items`.`id` IN (SELECT
`shop_items`.`shortcut_id`
FROM `shop_items`
INNER JOIN `shop_filter_group1` ON `shop_items`.`shop_group_id` = `shop_filter_group1`.`child_id` AND `shop_filter_group1`.`shop_group_id` = '589'
WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shortcut_id` > 0 AND ( `shop_items`.`start_datetime` < '2024-04-20 03:34:19' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-04-20 03:34:19' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`active` = 1) ) AND `shop_items`.`deleted` = 0
GROUP BY `dataTmpId`
ORDER BY `shop_items`.`datetime` DESC
LIMIT 48
OFFSET 0
modules/core/database/mysql.php:667 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Mysql->query
modules/core/orm.php:524 Core_QueryBuilder_Statement->execute
modules/core/entity.php:553 Core_ORM->findAll
modules/shop/controller/show.php:1166 Core_Entity->findAll
hostcmsfiles/lib/lib_233/lib_233.php:1338 Shop_Controller_Show->show
modules/lib/model.php:284 include
modules/core/page.php:166 Lib_Model->execute
templates/template113/template.htm:1 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template112/template.htm:655 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template93/template.htm:722 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:583 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:238 Core_Router_Route->execute
indexmy.php:16 include
modules/core/database/mysql.php:667 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Mysql->query
modules/core/orm.php:524 Core_QueryBuilder_Statement->execute
modules/core/entity.php:553 Core_ORM->findAll
modules/shop/controller/show.php:1166 Core_Entity->findAll
hostcmsfiles/lib/lib_233/lib_233.php:1338 Shop_Controller_Show->show
modules/lib/model.php:284 include
modules/core/page.php:166 Lib_Model->execute
templates/template113/template.htm:1 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template112/template.htm:655 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template93/template.htm:722 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:583 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:238 Core_Router_Route->execute
indexmy.php:16 include