select codestat_libelle as "Code Statistique exemplaire",location_libelle as Localisation, count(arc_id) as Nombre from pret_archive left join docs_location on arc_expl_location=idlocation left join docs_codestat on arc_expl_codestat=idcode where arc_expl_location in (!!choixloca!!) and arc_expl_codestat in (!!choixcodestat!!) and arc_debut between '!!date1!!' and '!!date2!!' group by 1,2 order by 1,2