select codestat_libelle as 'Code statistique', case when typdoc='a' then 'Imprimées' when typdoc='l' then 'Electroniques' else 'Autres' end as 'Format Publications en série en cours', count(distinct notice_id) as 'Publications en série en cours : Total Titres de Périodiques' from exemplaires left join bulletins on expl_bulletin=bulletin_id left join notices on bulletin_notice=notice_id left join docs_codestat on expl_codestat=idcode 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 expl_bulletin!=0 and niveau_biblio='s' and year(exemplaires.create_date)=!!annee!! group by 1,2 order by 1,2;