Eilat Youth Hostel & Guest House a Eilat

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 = 96 and id_city = 11486 and perma_village != '' group by Geo_Village