SELECT MIN( scd.niveau ) AS note_etat_equipement
FROM societe s
INNER JOIN societe_composant sc ON s.id_societe = sc.id_societe
INNER JOIN societe_composant_desordre scd ON scd.id_societe_composant = sc.id_societe_composant
INNER JOIN composant_desordre_fonction cdf ON cdf.id_composant = sc.id_composant
INNER JOIN composant c ON c.id_composant = cdf.id_composant
WHERE s.id_famille =1
OR s.id_famille =20
AND (
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%'
)