SELECT MIN( scd.niveau ) AS note_etat_equipementFROM societe sINNER JOIN societe_composant sc ON s.id_societe = sc.id_societeINNER JOIN societe_composant_desordre scd ON scd.id_societe_composant = sc.id_societe_composantINNER JOIN composant_desordre_fonction cdf ON cdf.id_composant = sc.id_composantINNER JOIN composant c ON c.id_composant = cdf.id_composantWHERE s.id_famille =1OR s.id_famille =20AND (fonction LIKE '%fonction_navigation%'OR fonction LIKE '%maintien_plan_eau%'OR fonction LIKE '%protection_perennite%'OR fonction LIKE '% %')AND (composant LIKE '%Musoir%'OR composant LIKE '%bajoyer%'OR composant LIKE '%radier%'OR composant LIKE '%fond amont%'OR composant LIKE '%fond aval%'OR composant LIKE '%mur en retour%'OR composant LIKE '%estacade%')