SELECT sum(nb_el) AS N, region.fr_region FROM stat LEFT JOIN club on id_club=club.poona_id AND club.niveau=2 LEFT JOIN region ON club.region=region.id WHERE fr_region!='' group by club.region ORDER BY N DESC;

Query failed: Array