SELECT location_libelle as Localisation, count(id_empr) as "Nombre de lecteurs" FROM empr LEFT JOIN docs_location ON idlocation=empr_location WHERE YEAR(empr_date_expiration)=!!anneee!! GROUP BY Localisation ORDER BY Localisation