SQL error in './266' at line /home/html/domoway.ru/html/engine/containers/metro.php, function $CMetroContainer->getStationDeals():
Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'prostor_domoway_spb.images.image' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)

SELECT
`deal`.`document_guid` as `guid`,
`deal`.`price`,
`priceMin`,
`sobMin`,
`rooms`,
`sob`,
`documents`.alias,
DATE_FORMAT(`deal`.`date`,
'%d.%m.%Y') AS fdate,
`images`.`image` AS `image`,
deal.address AS `address`,
realtyobject,
CONCAT('/',
FLOOR(`images`.`guid`/1000000),
'/',
FLOOR((`images`.`guid`%1000000)/1000),
'/') AS `image_path`
FROM
prostor_domoway_spb.fields_deal as deal
LEFT JOIN
prostor_domoway_spb.documents as documents ON documents.guid = deal.document_guid
LEFT JOIN
`prostor_domoway_spb`.`nested_documents` as `nd` ON nd.from_guid = deal.document_guid AND
nd.to_doctype_guid = 93
LEFT JOIN
`prostor_domoway_spb`.`fields_dealfoto` `foto` ON `foto`.`document_guid` = nd.`to_guid`
LEFT JOIN
`prostor_domoway_spb`.`images` ON `images`.`guid` = `foto`.`picture`
WHERE
deal.metro ='Кировский завод' AND
deal.type = 'sale'
GROUP BY
deal.document_guid
ORDER BY
deal.pic_count DESC
LIMIT
16