select count(*) as "Nombre de lecteurs", type_abt_libelle as 'Type abonnement' from empr join type_abts on type_abt=id_type_abt where(year(empr_date_adhesion)=!!annee!! or year(empr_date_expiration)=!!annee!! or (year(empr_date_expiration)>=!!annee!! and year(empr_date_adhesion)<=!!annee!!)) group by 2 order by 2