SELECT count(expl_id) as "Nombre d'exemplaires", lender_libelle as Propriétaire, tdoc_libelle as Support, codestat_libelle as Codestat FROM exemplaires JOIN lenders ON idlender=expl_owner left join docs_type on expl_typdoc=idtyp_doc JOIN docs_codestat ON idcode=expl_codestat WHERE expl_codestat IN (!!codestatt!!) AND expl_typdoc IN (!!typdocc!!) AND expl_owner IN (!!proprioo!!) GROUP BY Propriétaire, Codestat, Support ORDER BY Propriétaire, Codestat, Support