Exception: Query error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'yamaha_ko.properties.sorting' which is not in SELECT list; this is incompatible with DISTINCT. Query: SELECT
DISTINCT
`properties`.`id`
FROM `properties`
INNER JOIN `shop_item_properties` ON `shop_item_properties`.`property_id` = `properties`.`id`
INNER JOIN `shop_item_property_for_groups` ON `shop_item_property_id` = `shop_item_properties`.`id`
WHERE `shop_item_property_for_groups`.`shop_group_id` = 3819 AND `properties`.`deleted` = 0
ORDER BY `properties`.`sorting` ASC, `properties`.`name` ASC
34 modules/core/exception.php
641 modules/core/database/mysql.php
60 modules/core/querybuilder/statement.php
20188 modules/hostcms5/shop/shop.class.php
20364 modules/hostcms5/shop/shop.class.php
393 hostcmsfiles/lib/lib_42/lib_42.php
271 modules/lib/model.php
138 modules/core/page.php
154 templates/template30/template.htm
86 modules/template/model.php
138 modules/core/page.php
372 templates/template7/template.htm
86 modules/template/model.php
138 modules/core/page.php
379 modules/core/command/controller/default.php
108 modules/core/command/controller/hostcms5/default.php
190 modules/core/router/route.php
217 index.php