select type_abt_libelle as "Type d'abonnement", count(distinct arc_id_empr) as 'Nombre de lecteurs' from pret_archive left join empr on arc_id_empr=id_empr left join type_abts on type_abt=id_type_abt where arc_id_empr!=0 and date_format(arc_debut,'%Y-%m-%d')='!!date1!!' group by 1 order by 1