Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bccondos.listing.streetaddress' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_bySELECT listing.streetaddress AS geo_address, mainpicurl, thumbnailurl AS location,listing.listprice,listing.slug FROM listing LEFT JOIN condos ON condos.import_id=listing.internal_building_id WHERE listing.internal_building_id <> '' AND listing.status='Active' AND listing.streetaddress <> '' AND listing.reciprocity = 'Yes' AND thumbnailurl!='' AND realter_id='2' GROUP BY listing.street_number ORDER BY thumbnailurl DESC LIMIT 15