select location_libelle as Localisation, count(arc_id) as Nombre from pret_archive left join docs_location on arc_expl_location=idlocation where arc_expl_location in (!!choixloca!!) and year(arc_debut)=!!choixannee!! group by 1 order by 1