Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1055 'kotleopold_db.shop_items.shop_currency_id' isn't in GROUP BY. Query: SELECT MIN(t.absolute_price) AS `min`, MAX(t.absolute_price) AS `max` FROM (SELECT IF (`shop_items`.`shop_currency_id` = '3', IF (shop_discounts.value, IF(shop_discounts.type, price * 23.639664 - shop_discounts.value, price * (100 - shop_discounts.value) * 23.639664 / 100), shop_items.price * 23.639664), IF (`shop_items`.`shop_currency_id` = '2', IF (shop_discounts.value, IF(shop_discounts.type, price * 36.889479 - shop_discounts.value, price * (100 - shop_discounts.value) * 36.889479 / 100), shop_items.price * 36.889479), IF (`shop_items`.`shop_currency_id` = '1', IF (shop_discounts.value, IF(shop_discounts.type, price * 1 - shop_discounts.value, price * (100 - shop_discounts.value) * 1 / 100), shop_items.price * 1), price))) 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 `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` AND ( `shop_discounts`.`end_datetime` >= '2019-07-22 13:39:55' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' AND `shop_discounts`.`start_datetime` <= '2019-07-22 13:39:55' ) WHERE `shop_items`.`shop_id` = '1' AND `shop_items`.`shop_group_id` IN (0, '835', '964', '967', '963', '960', '961', '954', '1969', '959', '958', '957', '956', '955', '1964', '962', '965', '966', '838', '1935', '1936', '1938', '1937', '948', '921', '923', '1941', '1942', '1943', '1955', '1940', '947', '931', '932', '930', '929', '928', '927', '926', '925', '924', '1939', '920', '918', '919', '917', '916', '908', '915', '914', '913', '911', '912', '909', '910', '907', '904', '906', '905', '903', '1951', '836', '950', '952', '951', '831', '1006', '1007', '1005', '1003', '1004', '1002', '1001', '1000', '998', '999', '1962', '837', '1954', '1967', '1900', '1911', '1928', '1931', '1930', '1929', '946', '938', '943', '942', '941', '940', '939', '945', '933', '935', '937', '1947', '1927', '934', '936', '1897', '1953', '1898', '1933', '1904', '1909', '1924', '1907', '1903', '1925', '1908', '1926', '1906', '1905', '1902', '1952', '1968', '834', '977', '976', '975', '974', '972', '973', '971', '970', '969', '968', '1950', '832', '1966', '1918', '1919', '1920', '1921', '996', '993', '994', '988', '989', '985', '987', '990', '992', '995', '991', '833', '1949', '982', '981', '978', '979', '980', '1970', '1934', '1958', '1956', '1957', '1975', '1973', '1974', '1976', '1977', '1960', '1971', '1978', '1961', '1959', '840', '841', '1946', '1948', '847', '846', '1965', '845', '843', '844', '867', '875', '874', '873', '872', '871', '870', '860', '1922', '1923', '866', '865', '863', '864', '861', '862', '848', '852', '851', '849', '853', '850', '854', '857', '858', '859', '855', '856', '839', '1963', '892', '902', '901', '900', '899', '898', '897', '896', '895', '894', '893', '885', '890', '889', '891', '886', '887', '888', '703', '884', '883', '882', '881', '880', '876', '879', '877', '878') GROUP BY `shop_items`.`id`) AS `t`
36 modules/core/exception.php
571 modules/core/database/pdo.php
80 modules/core/querybuilder/statement.php
220 modules/shop/controller/extend.php
20 templates/template24/template.htm
103 modules/template/model.php
166 modules/core/page.php
157 templates/template1/template.htm
103 modules/template/model.php
166 modules/core/page.php
511 modules/core/command/controller/default.php
195 modules/core/router/route.php
240 index.php