SELECT statut_libelle as Statut,location_libelle as Localisation, codestat_libelle as Codestat, tdoc_libelle as Support, count(expl_id) as "Nombre de documents retirés de l'inventaire" FROM exemplaires LEFT JOIN docs_type on expl_typdoc=idtyp_doc LEFT JOIN docs_location ON idlocation= expl_location LEFT JOIN docs_codestat ON idcode=expl_codestat LEFT JOIN docs_statut ON idstatut=expl_statut  WHERE expl_statut=15 and idlocation IN (!!locationn!!) group by Localisation, Support, Codestat order by Localisation, Support, Codestat