select location_libelle as Localisation, section_libelle as Section, count(*) as Nombre from exemplaires LEFT JOIN docs_section ON idsection=expl_section LEFT JOIN docs_location ON idlocation=expl_location where idlocation in (!!locationn!!) and create_date LIKE "!!anneeencours!!%" group by location_libelle, section_libelle order by location_libelle, section_libelle 