select count(distinct expl_id) as "Manuscrits : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc='b';
select count(distinct expl_id) as "Documents cartographiques : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where  expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc in ('e','f');
select count(distinct expl_id) as "Musique imprimée : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc in ('c','d');
select count(distinct expl_id) as "Musique imprimée : Nombre d'unités en libre accès, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_statut on expl_statut=idstatut left join docs_location on expl_location=idlocation where expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc in ('c','d') and pret_flag=1;
select count(distinct notice_id) as "Musique imprimée : Nombre de titres, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where  expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc in ('c','d');
select count(distinct expl_id) as "Documents graphiques : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where  expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc='k';
select count(distinct expl_id) as "Autres documents : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where  expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc in ('r','m','l');
select count(distinct expl_id) as "Documents sonores : musique : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc='j';
select count(distinct expl_id) as "Documents sonores : livres enregistrés : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc='i';
select count(distinct expl_id) as "Documents audiovisuels : Nombre d'unités matérielles, fonds propre" from exemplaires left join notices on expl_notice=notice_id left join lenders on expl_owner=idlender left join docs_location on expl_location=idlocation where expl_location in (!!choixlocation!!) and expl_owner=!!choixproprio!! and typdoc='g';