select count(distinct n1.notice_id) as 'Nombre total de notices' from notices as n1 left join exemplaires on n1.notice_id=expl_notice left join docs_location on expl_location=idlocation where expl_location in (!!choixlocation!!) and n1.niveau_biblio='m';
select count(distinct n2.notice_id) as "Dont créées dans l'année" from notices as n2 left join exemplaires on n2.notice_id=expl_notice where n2.niveau_biblio='m' and year(n2.create_date)=!!annee!! and expl_location in (!!choixlocation!!);
select count(distinct n3.notice_id) as "Dont importées dans l'année" from notices as n3 left join exemplaires on n3.notice_id=expl_notice left join docs_location on expl_location=idlocation where n3.niveau_biblio='m' and year(n3.create_date)=!!annee!! and n3.origine_catalogage not in (1,3) and expl_location in (!!choixlocation!!);