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-12-21 16:19:41' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-12-21 16:19:41' 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-06-21' AND '2024-12-21 16:19:41' 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 ('131537', '131577', '131581', '130121', '130145', '130148', '130147', '130150', '130151', '131235', '132795', '132796', '131152', '132757', '131162', '131082', '131090', '131093', '131655', '131657', '130723', '130760', '130761', '132813', '131170', '131110', '131111', '131271', '131274', '130124', '130125', '130965', '131011', '131012', '131034', '131037', '131102', '131106', '131148', '131150', '130168', '130172', '130149', '131275', '130563', '130625', '130627', '129899', '129924', '129925', '131257', '131260', '130152', '130154', '130376', '130462', '130463', '130146', '130892', '130933', '130938', '131720', '131755', '131759', '130295', '130296', '130307', '131261', '130608', '130610', '131094', '130577', '130578', '130138', '130143', '131779', '131781', '130311', '130320', '130389', '130390', '132814', '131169', '131775', '131776', '131486', '131518', '131519', '130670', '130685', '130687', '129808', '129831', '129832', '129912', '129913', '129908', '129909', '130171', '132756', '131161', '131173', '131174', '130767', '130768', '131153', '131156', '130144', '130405', '130406', '131141', '131145', '131553', '131555', '129825', '129826', '130188', '130189', '129820', '129821', '129918', '129919', '129927', '130346', '130347', '130161', '130162', '130871', '130876', '130877', '132903', '130762', '131793', '131830', '131836', '131835', '130327', '130329', '131683', '131685', '131550', '131551', '129623', '129653', '129656', '129686', '129695', '129701', '129700', '129638', '129641', '130574', '130576', '130516', '130521', '130522', '130791', '130818', '130825', '129687', '129689', '132820', '131182', '131808', '131814', '131040', '131041', '131556', '131387', '131399', '131401', '130764', '130765', '130617', '130618', '131658', '129809', '129811', '130580', '130581', '129739', '129741', '129655', '130432', '130433', '130897', '130899', '130597', '130598', '130815', '130816', '130900', '130902', '130937', '131009', '131010', '130802', '130809', '131498', '131500', '129699', '130975', '130979', '130163', '131837', '132907', '132908', '130620', '130621', '131006', '131007', '130418', '130419', '129707', '129711', '131520', '130643', '130647', '130651', '129688', '129740', '129643', '129646', '129734', '129735', '130318', '129902', '129905', '130769', '130808', '130525', '130526', '130438', '130441', '129647', '131251', '131254', '130456', '130457', '130824', '129849', '129850', '130703', '130705', '130657', '130663', '129969', '129972', '130570', '130573', '129712', '130848', '130851', '130941', '130944', '131815', '132823', '130340', '130341', '130862', '130864', '129731', '129732', '129743', '129745', '132912', '130662', '130538', '130550', '130553', '132925', '132926', '129704') 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