"Individual" Success Stories

Error: Expression #15 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tmgcommu_tmgcommuni937946.i1.imgFile' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: select a.*,i1.imgFile from Properties a left join PropertyPhotos i1 on a.house_id = i1.house_id left join PropertyPhotos i2 on i1.house_id = i2.house_id and i1.imgOrder > i2.imgOrder where i2.imgID IS NULL AND type = 'Individual' group by a.house_id order by house_id desc

There was a problem connecting to the database. Please let us know if you continue to experience problems.