Listing des équipements de loisirs

Erreur MySQL.
Requête: SELECT IdAvoir, AfaId, AfaVille, max(IdZoneGeographique) as IdZoneGeographique, AfaNom FROM cdt64_afaire_es LEFT JOIN cdt64_zonegeographique_es ON cdt64_afaire_es.AfaZoneGeographique = cdt64_zonegeographique_es.Insee WHERE cdt64_afaire_es.en_ligne=1 AND AfaType='LOI' AND AfaSport LIKE '%%' GROUP BY AfaId, AfaVille, AfaNom ORDER BY AfaVille, AfaNom ASC
Erreur: (1054) Unknown column 'IdAvoir' in 'field list'