Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ( `shop_item_properties`.`property_id` = 151 AND ( ( `property_value_st' at line 6. Query: SELECT `shop_items`.`id`, `shop_items`.`shortcut_id`, `shop_items`.`shop_group_id`, `shop_items`.`shop_seller_id`, `shop_items`.`shop_producer_id`, `shop_items`.`modification_id`, `shop_items`.`length`, `shop_items`.`width`, `shop_items`.`height`, IF (`shop_items`.`shop_currency_id` = '3', `shop_items`.`price` * 35, IF (`shop_items`.`shop_currency_id` = '2', `shop_items`.`price` * 48, IF (`shop_items`.`shop_currency_id` = '1', `shop_items`.`price` * 1, `shop_items`.`price`))) AS `absolute_price` FROM `shop_items` LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id` LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = property_value_strings.property_id WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2020-09-23 07:23:02' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2020-09-23 07:23:02' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`id` IN () AND ( `shop_item_properties`.`property_id` = 151 AND ( ( `property_value_strings`.`value` NOT LIKE '%под заказ%' AND `property_value_strings`.`value` NOT LIKE '%снят с производства%' AND `property_value_strings`.`value` NOT LIKE '%нет в наличии%' ) OR `property_value_strings`.`value` IS NULL ) ) AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0 AND `shop_items`.`modification_id` = 0 GROUP BY `shop_items`.`id` HAVING COUNT(`shop_item_properties`.`id`) = 1
36 modules/core/exception.php
598 modules/core/database/pdo.php
61 modules/core/querybuilder/statement.php
2158 modules/extendedfilters/shop.php
614 modules/extendedfilters/shop.php
757 modules/extendedfilters/shop.php
454 modules/extendedfilters/shop.php
838 hostcmsfiles/lib/lib_57/lib_config_57.php
427 modules/core/command/controller/default.php
193 modules/core/router/route.php
239 index.php