[Bitrix\Main\DB\SqlQueryException] Mysql query error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hk.price.VALUE_NUM' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (400) SELECT gk_elem.ID as ID, price.VALUE_NUM AS PRICE, MIN(price.VALUE_NUM) AS PRICE FROM (SELECT ID, NAME FROM b_iblock_element WHERE IBLOCK_ID = 12 AND ACTIVE='Y') as iblock_element INNER JOIN b_iblock_element_prop_m12 price ON iblock_element.ID = price.IBLOCK_ELEMENT_ID and price.IBLOCK_PROPERTY_ID = 60 INNER JOIN b_iblock_element_prop_s12 table_prop_s ON iblock_element.ID = table_prop_s.IBLOCK_ELEMENT_ID INNER JOIN b_iblock_element gk_elem ON table_prop_s.PROPERTY_59 = gk_elem.ID WHERE price.VALUE_NUM >= '2300000' and price.VALUE_NUM <= '42500000' GROUP BY gk_elem.ID ORDER BY PRICE ASC LIMIT 0, 10 /var/www/hochukvartiru.ru/bitrix/modules/main/lib/db/mysqliconnection.php:137 #0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL) /var/www/hochukvartiru.ru/bitrix/modules/main/lib/db/connection.php:330 #1: Bitrix\Main\DB\Connection->query(string) /var/www/hochukvartiru.ru/local/components/hk.catalog/new_build_gk.list/class.php:55 #2: NewBuildingGkList->getQuery(object) /var/www/hochukvartiru.ru/local/components/hk.catalog/new_build_gk.list/class.php:143 #3: NewBuildingGkList->executeComponent() /var/www/hochukvartiru.ru/bitrix/modules/main/classes/general/component.php:638 #4: CBitrixComponent->includeComponent(string, array, NULL) /var/www/hochukvartiru.ru/bitrix/modules/main/classes/general/main.php:1038 #5: CAllMain->IncludeComponent(string, string, array) /var/www/hochukvartiru.ru/pereustupki_gk/index.php:39 #6: include_once(string) /var/www/hochukvartiru.ru/bitrix/modules/main/include/urlrewrite.php:159 #7: include_once(string) /var/www/hochukvartiru.ru/bitrix/urlrewrite.php:2