Casa Mia Suites a San Miguel De Allende

1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'viamundi_viamundis.imp_hotels.perma_village' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select Geo_Village, perma_village from imp_hotels where id_country = 126 and id_city = 5621 and perma_village != '' group by Geo_Village