SELECT sc.id_societe_composant ,c.conclusion, scd.niveau,sc.id_composant
FROM societe_composant sc 
INNER JOIN composant c ON c.id_composant = sc.id_composant
INNER JOIN societe_composant_desordre scd ON sc.id_societe_composant = scd.id_societe_composant
AND c.conclusion LIKE  '%maintien_plan_eau%'