SELECT libelle as Catégorie, count(id_empr) as 'Nombre lecteurs' from empr LEFT JOIN empr_categ ON id_categ_empr=empr_categ where empr_categ in (!!categorie!!) AND empr_date_adhesion BETWEEN "!!date1!!" and "!!date2!!" group by 1 ORDER BY 1