SELECT sc.id_societe_composant, c.conclusion, scd.niveau, sc.id_composant
FROM societe_composant sc, societe_composant_desordre scd, composant c
WHERE c.id_composant = sc.id_composant
AND sc.id_societe_composant = scd.id_societe_composant
AND c.conclusion LIKE '%maintien_plan_eau%'
GROUP BY sc.id_composant