select lender_libelle as Propriétaire, tdoc_libelle as Support, count(arc_id) as Nombre from pret_archive left join lenders on arc_expl_owner=idlender left join docs_type on arc_expl_typdoc=idtyp_doc where arc_expl_typdoc in (!!choixtypdoc!!) and arc_expl_owner in (!!choixproprio!!) and arc_debut between '!!date1!!' and '!!date2!!' group by 1,2 order by 1