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 c ON c.id_composant=sc.id_composantWHERE s.societe LIKE '%ecluse%' OR s.societe LIKE '%écluse%'AND ( c.conclusion LIKE '%fonction_navigation%' OR c.conclusion LIKE '%maintien_plan_eau%' OR c.conclusion LIKE '%protection_perennite%' OR c.conclusion 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%' )