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