Erreur SQL

Erreur de requête
MySQL a répondu : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 4
Requête : SELECT a.nom, a.id, a.genre FROM jap_wallpapers w JOIN jap_articles a WHERE w.id_serie = a.id AND w.nom_wall != 'index.jpg' AND w.nom_wall NOT LIKE 'capture%' GROUP BY a.nom ASC