Error: Expression #30 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tmgcommu_tmgcommuni937946.i1.imgID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: select *,i1.imgFile from BusinessDirectory p left join BusinessImages i1 on p.projID = i1.projID left join BusinessImages i2 on i1.projID = i2.projID and i1.imgOrder > i2.imgOrder where i2.imgID IS NULL group by p.projID order by projName