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 MariaDB server version for the right syntax to use near ') AND ( `shop_item_properties`.`property_id` = 151 AND `property_value_strings`' at line 9. 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', IF (shop_discounts.value, IF(shop_discounts.type, `shop_items`.`price` * 35 - shop_discounts.value, `shop_items`.`price` * (100 - shop_discounts.value) * 35 / 100), `shop_items`.`price` * 35), IF (`shop_items`.`shop_currency_id` = '2', IF (shop_discounts.value, IF(shop_discounts.type, `shop_items`.`price` * 48 - shop_discounts.value, `shop_items`.`price` * (100 - shop_discounts.value) * 48 / 100), `shop_items`.`price` * 48), IF (`shop_items`.`shop_currency_id` = '1', IF (shop_discounts.value, IF(shop_discounts.type, `shop_items`.`price` * 1 - shop_discounts.value, `shop_items`.`price` * (100 - shop_discounts.value) * 1 / 100), `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 LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id` LEFT OUTER JOIN `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` LEFT OUTER JOIN `shop_numbers_active_discounts` ON `shop_numbers_active_discounts`.`n` = `shop_discounts`.`id` WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2018-01-22 03:27:05' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2018-01-22 03:27:05' 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 '%нет в наличии%' ) 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
2130 modules/extendedfilters/shop.php
602 modules/extendedfilters/shop.php
745 modules/extendedfilters/shop.php
442 modules/extendedfilters/shop.php
722 hostcmsfiles/lib/lib_57/lib_config_57.php
427 modules/core/command/controller/default.php
193 modules/core/router/route.php
239 index.php