Parti Socialiste Neuchâtelois

SELECT contenus.* FROM contenus, contenus_types, contenus_types_categories WHERE contenus.contenus_types_id = contenus_types.id AND contenus_types_categories_id = contenus_types_categories.id AND contenus_types_categories.slug='le-parti' AND contenus.est_publie = 'YES' AND contenus.id NOT IN ( SELECT contenus_id FROM contenus_to_sections ) ORDER BY ABS(contenus.ordre_affichage) NO