Exception: Query error 42S02: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'j12547966_hs.shop_filter1' doesn't exist. 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`
LEFT OUTER JOIN `property_value_ints` AS `pi_archive` ON `shop_filter1`.`shop_item_id` = `pi_archive`.`entity_id` AND `pi_archive`.`property_id` = '113'
LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_filter1`.`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` < '2026-08-04 04:04:24' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2026-08-04 04:04:24' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_filter1`.`property36` = 1012 AND `shop_items`.`active` = 1 AND ( `shop_items`.`shop_group_id` IN ('1', '3', '183') AND `shop_items`.`shortcut_id` = 0 AND `shop_items`.`modification_id` = 0 OR `shop_items`.`shop_group_id` = 0 AND `shop_items`.`modification_id` IN (SELECT
`shop_items`.`id`
FROM `shop_items`
WHERE `shop_items`.`shop_id` = '1' AND `shop_items`.`deleted` = 0 AND `shop_items`.`shop_group_id` IN ('1', '3', '183') AND ( `shop_items`.`start_datetime` < '2026-08-04 04:04:25' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2026-08-04 04:04:25' 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) OR `shop_items`.`shop_group_id` = 0 AND `shop_items`.`modification_id` IN (SELECT
`shop_items`.`shortcut_id`
FROM `shop_items`
WHERE `shop_items`.`shop_id` = '1' AND `shop_items`.`deleted` = 0 AND `shop_items`.`active` = 1 AND `shop_items`.`shortcut_id` > 0 AND `shop_items`.`shop_group_id` IN ('1', '3', '183')) OR `shop_items`.`id` IN (SELECT
`shop_items`.`shortcut_id`
FROM `shop_items`
WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shortcut_id` > 0 AND `shop_items`.`shop_group_id` IN ('1', '3', '183') AND ( `shop_items`.`start_datetime` < '2026-08-04 04:04:25' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2026-08-04 04:04:25' 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 IF (pi_archive.value > 0, 1, 0) ASC, IF(SUM(shop_warehouse_items.count) > 0, 1, 0 ) DESC, `sorting` ASC
LIMIT 40
OFFSET 0
modules/core/database/pdo.php:680 Core_Exception->__construct
modules/core/querybuilder/statement.php:87 Core_DataBase_Pdo->query
modules/core/orm.php:542 Core_QueryBuilder_Statement->execute
modules/core/entity.php:621 Core_ORM->findAll
modules/shop/controller/show.php:1331 Core_Entity->findAll
hostcmsfiles/lib/lib_51/lib_51.php:1214 Shop_Controller_Show->show
modules/lib/model.php:277 include
modules/core/page.php:177 Lib_Model->execute
templates/template4/template.htm:30 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:177 Template_Model->execute
templates/template2/template.htm:300 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:177 Template_Model->execute
modules/core/command/controller/default.php:613 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:254 Core_Router_Route->execute
