8 (812) 612-28-28
Агентство недвижимости —
№1 в клиентском сервисе!
[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1055) Expression #3 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
iblock_element.ID as ID, iblock_element.NAME, price.VALUE_NUM AS PRICE
FROM
b_iblock_element iblock_element
INNER JOIN b_iblock_element_prop_m12 price ON iblock_element.ID = price.IBLOCK_ELEMENT_ID and price.IBLOCK_PROPERTY_ID = 60
WHERE
iblock_element.IBLOCK_ID = 12 and iblock_element.ACTIVE = 'Y' and
price.VALUE_NUM >= '2300000' and price.VALUE_NUM <= '42500000'
GROUP BY iblock_element.ID
ORDER BY price.VALUE_NUM 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.list/class.php:163
#2: NewBuildingList->getQuery(object)
/var/www/hochukvartiru.ru/local/components/hk.pereustupki/list/class.php:73
#3: PereustupkiList->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/index.php:43
#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