select lender_libelle as Propriétaire, location_libelle as Localisation, tdoc_libelle as Support, count(arc_id) as Nombre from pret_archive left join lenders on arc_expl_owner=idlender left join docs_location on arc_expl_location=idlocation left join docs_type on arc_expl_typdoc=idtyp_doc where arc_expl_typdoc in (!!choixsupport!!) and arc_expl_location in (!!choixloca!!) and arc_expl_owner in (!!choixlender!!) and year(arc_debut)=!!choixannee!! group by 1,2,3 order by 1,2,3