----------------------------------------- note_etat_equipement --------------------------------------------------porte amontSELECT sc.id_societe,scd.niveau as noteFROM societe_composant_desordre scdINNER JOIN societe_composant sc 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_composantINNER JOIN partie p ON c.id_partie=p.id_partieWHERE cdf.fonction LIKE '%fonction_navigation%'AND p.id_famille =1 OR p.id_famille=12AND p.partie LIKE '%porte%amont%'GROUP BY sc.id_societe-- porte avalSELECT sc.id_societe,scd.niveau as noteFROM societe_composant_desordre scdINNER JOIN societe_composant sc 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_composantINNER JOIN partie p ON c.id_partie=p.id_partieWHERE cdf.fonction LIKE '%fonction_navigation%'AND p.id_famille =1 OR p.id_famille=12AND p.partie LIKE '%porte%aval%'GROUP BY sc.id_societe----Systeme de manoeuvre porte amontSELECT sc.id_societe,scd.niveau as noteFROM societe_composant_desordre scdINNER JOIN societe_composant sc 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_composantINNER JOIN partie p ON c.id_partie=p.id_partieWHERE cdf.fonction LIKE '%fonction_navigation%'AND c.composant LIKE '%Système de manoeuvre%'AND p.id_famille =1 OR p.id_famille=12AND p.partie LIKE '%porte%amont%'GROUP BY sc.id_societe----Systeme de manoeuvre porte avalSELECT sc.id_societe,scd.niveau as noteFROM societe_composant_desordre scdINNER JOIN societe_composant sc 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_composantINNER JOIN partie p ON c.id_partie=p.id_partieWHERE cdf.fonction LIKE '%fonction_navigation%'AND c.composant LIKE '%Système de manoeuvre%'AND p.id_famille =1 OR p.id_famille=12AND p.partie LIKE '%porte%aval%'GROUP BY sc.id_societe----poste de commandeSELECT sc.id_societe,scd.niveau as noteFROM societe_composant_desordre scdINNER JOIN societe_composant sc 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 cdf.fonction LIKE '%fonction_navigation%'AND c.composant LIKE '%poste de commande%'GROUP BY sc.id_societe