Something

SELECT DISTINCT a.nom_commune,                 b.lib_manif,                 b.type_manif FROM jos_atlas_commune AS a      INNER JOIN jos_atlas_manifestation AS b       ON b.code_commune = a.code_commune      INNER JOIN jos_atlas_jour AS c       ON c.id_manif = b.id_manif WHERE b.code_commune = a.code_commune AND b.saisonnier IN (1,4) AND c.jour IN (2,5,6) ORDER BY a.nom_commune, b.lib_manif