Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1055 'kotleopold_db.shop_items.shortcut_id' isn't in GROUP BY. 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`, GROUP_CONCAT(DISTINCT `shop_item_discounts`.`shop_discount_id`) AS `discounts`, IF (`shop_items`.`shop_currency_id` = '3', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 23.639664 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 23.639664), IF (`shop_items`.`shop_currency_id` = '2', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 36.889479 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 36.889479), IF (`shop_items`.`shop_currency_id` = '1', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 1 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 1), `shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)))) AS `absolute_price` FROM `shop_items` LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id` LEFT OUTER JOIN (SELECT * FROM `shop_discounts` RIGHT OUTER JOIN `shop_numbers_active_discounts` ON `shop_numbers_active_discounts`.`n` = `shop_discounts`.`id`) AS `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` INNER JOIN `shop_numbers_nested_groups` ON `shop_items`.`shop_group_id` = `shop_numbers_nested_groups`.`n` LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_items`.`id` LEFT OUTER JOIN `shop_taxes` ON `shop_taxes`.`id` = `shop_items`.`shop_tax_id` WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2019-07-22 13:39:52' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2019-07-22 13:39:52' 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 `shop_items`.`id` HAVING SUM(shop_warehouse_items.count) > 0 OR shop_items.shortcut_id > 0
36 modules/core/exception.php
571 modules/core/database/pdo.php
80 modules/core/querybuilder/statement.php
2458 modules/extendedfilters/shop.php
693 modules/extendedfilters/shop.php
848 modules/extendedfilters/shop.php
528 modules/extendedfilters/shop.php
477 hostcmsfiles/lib/lib_54/lib_config_54.php
456 modules/core/command/controller/default.php
195 modules/core/router/route.php
240 index.php