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 `shop_items` ON `shop_items`.`id` = `shop_filter1`.`shop_item_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` < '2022-09-30 03:50:25' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2022-09-30 03:50:25' 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`.`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 `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:1317 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:677 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