Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status.value' in 'where clause'. Query: SELECT DISTINCT SQL_CALC_FOUND_ROWS `shop_items`.* FROM `shop_items` LEFT OUTER JOIN `property_value_datetimes` AS `pvdd` ON `shop_items`.`id` = `pvdd`.`entity_id` AND `pvdd`.`property_id` = 207 INNER JOIN `shop_items` AS `m` ON `shop_items`.`id` = `m`.`modification_id` LEFT OUTER JOIN `property_value_ints` AS `hide_item` ON `hide_item`.`entity_id` = `shop_items`.`id` AND `hide_item`.`property_id` = 252 LEFT OUTER JOIN `shop_groups` AS `sg` ON `sg`.`id` = `shop_items`.`shop_group_id` WHERE `shop_items`.`shop_id` = '7' AND ( `shop_items`.`start_datetime` < '2024-09-18 11:27:53' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-09-18 11:27:53' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND ( ( `pvdd`.`value` BETWEEN '2024-03-18' AND '2024-09-18 11:27:53' AND `status`.`value` = 1974 AND `pvdd`.`value` IS NOT NULL AND `hide_item`.`value` = 0 ) OR ( `pvdd`.`value` IS NULL AND `status`.`value` = 1972 AND `hide_item`.`value` = 0 ) ) AND `shop_items`.`shop_group_id` IN (130791, 132930, 132931, 132928, 132929, 130792, 130793, 130794, 130795, 130796, 130797, 130798, 130799, 130800, 130801, 130802, 130803, 130804, 130805, 130806, 130807, 130808, 130809, 130810, 130811, 130812, 130813, 130814, 130815, 130816, 130817, 130818, 130819, 130820, 130821, 130822, 130823, 130824, 130825, 130826, 130827, 130828, 130829, 130830, 130831, 130832, 130833, 130834, 130835, 130836, 130837, 130838, 130839, 130840, 130841, 130842, 130843, 130844, 130845, 130846, 130847, 130848, 130849, 130850, 130851, 130852, 130853, 130854, 130855, 130856, 130857, 130858, 130859, 130860, 130861, 130862, 130863, 130864, 130865, 130866, 130867, 130868, 130869, 130870, 131922, 131923, 132601, 132602, 132624, 132625, 134367, 134368, 134369) AND `hide_item`.`value` = 0 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 ORDER BY `sli`.`sorting` ASC, `shop_items`.`datetime` DESC, `shop_items`.`name` ASC LIMIT 20 OFFSET 0
modules/core/database/pdo.php:675 Core_Exception->__construct
modules/core/querybuilder/statement.php:78 Core_DataBase_Pdo->query
modules/core/orm.php:522 Core_QueryBuilder_Statement->execute
modules/core/entity.php:581 Core_ORM->findAll
modules/shop/controller/show.php:1178 Core_Entity->findAll
libs/modules/pezhon/module/shop/controller/show.php:443 Shop_Controller_Show->show
hostcmsfiles/lib/lib_103/lib_103.php:501 Pezhon_Shop_Controller_Show->show
modules/lib/model.php:284 include
modules/core/page.php:166 Lib_Model->execute
templates/template31/template.htm:75 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template13/template.htm:198 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:580 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:236 Core_Router_Route->execute