Untitled

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                 INNER JOIN jos_atlas_rel_activite AS e ON e.id_manif = b.id_manif                 INNER JOIN jos_atlas_activite AS d ON d.id_activite = e.id_activite WHERE           b.code_commune = '17013'             AND c.lib_jour IN ('lundi','mardi','vendredi','samedi')             AND d.nature = 'non alimentaire'             AND b.type_manif IN (1,2)             AND b.saisonnier IN (2,1) ORDER BY a.nom_commune, b.lib_manif