SELECT count(expl_id) as "Nombre d'exemplaires", lender_libelle as Propriétaire, statut_libelle AS Statut, location_libelle as Localisation,codestat_libelle as Codestat, tdoc_libelle as Support, section_libelle as Section FROM exemplaires JOIN lenders ON idlender=expl_owner 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_section ON idsection=expl_section JOIN docs_statut ON idstatut=expl_statut WHERE expl_location IN (!!locationn!!) AND expl_section IN (!!sectionn!!) AND expl_codestat IN (!!codestatt!!) AND expl_typdoc IN (!!typdocc!!) AND expl_owner IN (!!proprioo!!) AND expl_statut IN (!!statutt!!) GROUP BY Propriétaire, Localisation, Codestat, Support, Section, Statut ORDER BY Propriétaire, Localisation, Codestat, Support, Section, Statut