shop filter 6SELECT MIN(property108) AS `min`, MAX(property108) AS `max` FROM `shop_filter4`shop filter 6SELECT MIN(property128) AS `min`, MAX(property128) AS `max` FROM `shop_filter4`Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'prop_tmp.value' in 'where clause'. Query: SELECT * FROM (SELECT DISTINCT `shop_filter4`.`property110` FROM `shop_filter4` WHERE `shop_filter4`.`shop_item_id` IN (SELECT DISTINCT `shop_items`.`id` FROM `shop_items` WHERE `shop_items`.`shop_id` = 4 AND `shop_items`.`deleted` = 0 AND `shop_items`.`active` = 1 AND ( `shop_items`.`start_datetime` < '2023-06-10 21:27:43' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2023-06-10 21:27:43' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1)) AND `shop_filter4`.`property110` != 0) AS `prop_tmp`, `list_items` WHERE `list_items`.`list_id` = '212' AND `list_items`.`active` = 1 AND `list_items`.`id` = `prop_tmp`.`value` AND `list_items`.`deleted` = 0 ORDER BY `list_items`.`sorting` ASC, `list_items`.`value` ASC
modules/core/database/pdo.php:604 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/core/orm.php:518 Core_QueryBuilder_Statement->execute
modules/core/entity.php:531 Core_ORM->findAll
modules/property/model.php:614 Core_Entity->findAll
modules/property/model.php:528 Property_Model->_prepareData
modules/core/entity.php:649 Property_Model->getXml
modules/core/xml/entity.php:119 Core_Entity->getXml
modules/core/entity.php:649 Core_Xml_Entity->getXml
modules/shop/model.php:962 Core_Entity->getXml
modules/core/controller.php:210 Shop_Model->getXml
modules/core/controller.php:351 Core_Controller->getXml
modules/nl/shop/controller/shownew.php:1254 Core_Controller->get
templates/template90/template.htm:82 NL_Shop_Controller_ShowNew->show
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template34/template.htm:505 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