select location_libelle as Localisation, section_libelle as Section, count(arc_id) as Nombre from pret_archive left join docs_section on arc_expl_section=idsection left join docs_location on arc_expl_location=idlocation where arc_expl_location in (!!choixloca!!) and arc_debut between "!!date1!!" and "!!date2!!" group by 1,2 order by 1,2