select *
from GaleriaCategoria c
inner join (
select Imagem, GaleriaCategoriaId
from Galeria
where Situacao = 'ativo'
group by GaleriaCategoriaId
order by Ordem
) g
on g.GaleriaCategoriaId = c.GaleriaCategoriaId
where c.Situacao = 'ativo'
order by c.OrdemFalha: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'site_mat_novo.Galeria.Imagem' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
