Erreur SQL

select MC.nom_coupe as NOMC , MM.id_groupe as IDGRP from pokal_coupe MC left join pokal_groupe MG on MG.id_coupe = MC.id_coupe left join pokal_membre MM on MM.id_groupe = MG.id_groupe and MM.id_membre = where MC.id_coupe = 8 order by MM.id_groupe desc limit 1;

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 'where MC.id_coupe = 8 order by MM.id_groupe desc limit 1' at line 8