SELECT DISTINCT(C.id_commune), C.nom_commune, DPT.departement_nom FROM projets AS PJ
LEFT JOIN communes AS C ON (PJ.fk_ville=C.id_commune)
LEFT JOIN departement AS DPT ON (PJ.fk_departements=DPT.departement_id)
LEFT JOIN promoteurs AS PR ON (PJ.id_promoteur=PR.id) WHERE PJ.id>'0' AND PJ.archive='non' AND PJ.actif='oui' AND PJ.nb_produits!='0' AND (
PJ.fk_departements='76' OR
PJ.fk_departements='78' OR
PJ.fk_departements='79' OR
PJ.fk_departements='92' OR
PJ.fk_departements='93' OR
PJ.fk_departements='94' OR
PJ.fk_departements='95' OR
PJ.fk_departements='96'
)
