SELECT count( fotos_id ) as fotocount, babygal_fotos.* , babygal_babys.* FROM `babygal_fotos` LEFT JOIN babygal_babys ON babygal_fotos.babys_id = babygal_babys.babys_id WHERE albumfoto =1 AND deleted =0 AND babygal_babys.verified = 1 GROUP BY babygal_fotos.babys_id ORDER BY `fotocount` DESC
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'babygalerie.babygal_fotos.fotos_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by