select lender_libelle as Propriétaire, location_libelle as Localisation, tdoc_libelle as Support, count(*) as Nombre from exemplaires left join lenders on expl_owner=idlender left join docs_location on idlocation=expl_location left join docs_type on expl_typdoc=idtyp_doc where expl_typdoc in (!!choixsupport!!) group by lender_libelle,location_libelle,tdoc_libelle order by 1,2,3 