select indexint_name as 'Indexation décimale', indexint_comment as 'Commentaire', count(arc_id) as 'Nombre de prêts' from pret_archive left join notices on arc_expl_notice=notice_id left join indexint on indexint=indexint_id where year(arc_debut)=!!choixannee!! group by 1 order by 3 DESC