Trombinoscope du CE
Découvrez tous les acteurs de votre Comité d'Entreprise et des Commissions de travail.

Pour faire connaissance, cliquez sur la catégorie de votre choix.
CE SNCF MOBILITES PICARDIE
SELECT s.*, oCE.nom as CE_nomOrgane, oCCE.nom as CCE_nomOrgane, oCG.nom as CG_nomOrgane, oComm1.nom as CE_commission1nomOrgane, oComm2.nom as CE_commission2nomOrgane, oComm3.nom as CE_commission3nomOrgane, oComm4.nom as CE_commission4nomOrgane, oComm5.nom as CE_commission5nomOrgane, oComm6.nom as CE_commission6nomOrgane, oComm7.nom as CE_commission7nomOrgane, oComm8.nom as CE_commission8nomOrgane, oComm9.nom as CE_commission9nomOrgane, oComm10.nom as CE_commission10nomOrgane, oComm11.nom as CCE_commission1nomOrgane, oComm12.nom as CCE_commission2nomOrgane, oComm13.nom as CCE_commission3nomOrgane, oComm14.nom as CCE_commission4nomOrgane, oComm15.nom as CCE_commission5nomOrgane, oComm16.nom as CCE_commission6nomOrgane, oComm17.nom as CCE_commission7nomOrgane, oComm18.nom as CCE_commission8nomOrgane, oComm19.nom as CCE_commission9nomOrgane, oComm20.nom as CCE_commission10nomOrgane, oComm21.nom as CG_commission1nomOrgane, oComm22.nom as CG_commission2nomOrgane, oComm23.nom as CG_commission3nomOrgane, oComm24.nom as CG_commission4nomOrgane, oComm25.nom as CG_commission5nomOrgane, oComm26.nom as CG_commission6nomOrgane, oComm27.nom as CG_commission7nomOrgane, oComm28.nom as CG_commission8nomOrgane, oComm29.nom as CG_commission9nomOrgane, oComm30.nom as CG_commission10nomOrgane, s.vignette1 as vignette1, s.image1 as image1 FROM boutique_salaries s LEFT JOIN boutique_organes oCE FORCE INDEX (PRIMARY) ON s.CE_siege = "1" AND oCE.idProduit = s.CE_idOrgane AND oCE.visible = 1 LEFT JOIN boutique_organes oCCE FORCE INDEX (PRIMARY) ON s.CCE_siege = "1" AND oCCE.idProduit = s.CCE_idOrgane AND oCCE.visible = 1 LEFT JOIN boutique_organes oCG FORCE INDEX (PRIMARY) ON s.CG_siege = "1" AND oCG.idProduit = s.CG_idOrgane AND oCG.visible = 1 LEFT JOIN boutique_organes oComm1 FORCE INDEX (PRIMARY) ON s.CE_commission1membre = "1" AND oComm1.idProduit = s.CE_commission1idOrgane AND oComm1.visible = 1 LEFT JOIN boutique_organes oComm2 FORCE INDEX (PRIMARY) ON s.CE_commission2membre = "1" AND oComm2.idProduit = s.CE_commission2idOrgane AND oComm2.visible = 1 LEFT JOIN boutique_organes oComm3 FORCE INDEX (PRIMARY) ON s.CE_commission3membre = "1" AND oComm3.idProduit = s.CE_commission3idOrgane AND oComm3.visible = 1 LEFT JOIN boutique_organes oComm4 FORCE INDEX (PRIMARY) ON s.CE_commission4membre = "1" AND oComm4.idProduit = s.CE_commission4idOrgane AND oComm4.visible = 1 LEFT JOIN boutique_organes oComm5 FORCE INDEX (PRIMARY) ON s.CE_commission5membre = "1" AND oComm5.idProduit = s.CE_commission5idOrgane AND oComm5.visible = 1 LEFT JOIN boutique_organes oComm6 FORCE INDEX (PRIMARY) ON s.CE_commission6membre = "1" AND oComm6.idProduit = s.CE_commission6idOrgane AND oComm6.visible = 1 LEFT JOIN boutique_organes oComm7 FORCE INDEX (PRIMARY) ON s.CE_commission7membre = "1" AND oComm7.idProduit = s.CE_commission7idOrgane AND oComm7.visible = 1 LEFT JOIN boutique_organes oComm8 FORCE INDEX (PRIMARY) ON s.CE_commission8membre = "1" AND oComm8.idProduit = s.CE_commission8idOrgane AND oComm8.visible = 1 LEFT JOIN boutique_organes oComm9 FORCE INDEX (PRIMARY) ON s.CE_commission9membre = "1" AND oComm9.idProduit = s.CE_commission9idOrgane AND oComm9.visible = 1 LEFT JOIN boutique_organes oComm10 FORCE INDEX (PRIMARY) ON s.CE_commission10membre = "1" AND oComm10.idProduit = s.CE_commission10idOrgane AND oComm10.visible = 1 LEFT JOIN boutique_organes oComm11 FORCE INDEX (PRIMARY) ON s.CCE_commission1membre = "1" AND oComm11.idProduit = s.CCE_commission1idOrgane AND oComm11.visible = 1 LEFT JOIN boutique_organes oComm12 FORCE INDEX (PRIMARY) ON s.CCE_commission2membre = "1" AND oComm12.idProduit = s.CCE_commission2idOrgane AND oComm12.visible = 1 LEFT JOIN boutique_organes oComm13 FORCE INDEX (PRIMARY) ON s.CCE_commission3membre = "1" AND oComm13.idProduit = s.CCE_commission3idOrgane AND oComm13.visible = 1 LEFT JOIN boutique_organes oComm14 FORCE INDEX (PRIMARY) ON s.CCE_commission4membre = "1" AND oComm14.idProduit = s.CCE_commission4idOrgane AND oComm14.visible = 1 LEFT JOIN boutique_organes oComm15 FORCE INDEX (PRIMARY) ON s.CCE_commission5membre = "1" AND oComm15.idProduit = s.CCE_commission5idOrgane AND oComm15.visible = 1 LEFT JOIN boutique_organes oComm16 FORCE INDEX (PRIMARY) ON s.CCE_commission6membre = "1" AND oComm16.idProduit = s.CCE_commission6idOrgane AND oComm16.visible = 1 LEFT JOIN boutique_organes oComm17 FORCE INDEX (PRIMARY) ON s.CCE_commission7membre = "1" AND oComm17.idProduit = s.CCE_commission7idOrgane AND oComm17.visible = 1 LEFT JOIN boutique_organes oComm18 FORCE INDEX (PRIMARY) ON s.CCE_commission8membre = "1" AND oComm18.idProduit = s.CCE_commission8idOrgane AND oComm18.visible = 1 LEFT JOIN boutique_organes oComm19 FORCE INDEX (PRIMARY) ON s.CCE_commission9membre = "1" AND oComm19.idProduit = s.CCE_commission9idOrgane AND oComm19.visible = 1 LEFT JOIN boutique_organes oComm20 FORCE INDEX (PRIMARY) ON s.CCE_commission10membre = "1" AND oComm20.idProduit = s.CCE_commission10idOrgane AND oComm20.visible = 1 LEFT JOIN boutique_organes oComm21 FORCE INDEX (PRIMARY) ON s.CG_commission1membre = "1" AND oComm21.idProduit = s.CG_commission1idOrgane AND oComm21.visible = 1 LEFT JOIN boutique_organes oComm22 FORCE INDEX (PRIMARY) ON s.CG_commission2membre = "1" AND oComm22.idProduit = s.CG_commission2idOrgane AND oComm22.visible = 1 LEFT JOIN boutique_organes oComm23 FORCE INDEX (PRIMARY) ON s.CG_commission3membre = "1" AND oComm23.idProduit = s.CG_commission3idOrgane AND oComm23.visible = 1 LEFT JOIN boutique_organes oComm24 FORCE INDEX (PRIMARY) ON s.CG_commission4membre = "1" AND oComm24.idProduit = s.CG_commission4idOrgane AND oComm24.visible = 1 LEFT JOIN boutique_organes oComm25 FORCE INDEX (PRIMARY) ON s.CG_commission5membre = "1" AND oComm25.idProduit = s.CG_commission5idOrgane AND oComm25.visible = 1 LEFT JOIN boutique_organes oComm26 FORCE INDEX (PRIMARY) ON s.CG_commission6membre = "1" AND oComm26.idProduit = s.CG_commission6idOrgane AND oComm26.visible = 1 LEFT JOIN boutique_organes oComm27 FORCE INDEX (PRIMARY) ON s.CG_commission7membre = "1" AND oComm27.idProduit = s.CG_commission7idOrgane AND oComm27.visible = 1 LEFT JOIN boutique_organes oComm28 FORCE INDEX (PRIMARY) ON s.CG_commission8membre = "1" AND oComm28.idProduit = s.CG_commission8idOrgane AND oComm28.visible = 1 LEFT JOIN boutique_organes oComm29 FORCE INDEX (PRIMARY) ON s.CG_commission9membre = "1" AND oComm29.idProduit = s.CG_commission9idOrgane AND oComm29.visible = 1 LEFT JOIN boutique_organes oComm30 FORCE INDEX (PRIMARY) ON s.CG_commission10membre = "1" AND oComm30.idProduit = s.CG_commission10idOrgane AND oComm30.visible = 1 WHERE s.statutCompte = "Validé" AND s.idParent = 0 AND s.visible = 1 AND s.archiver = 0 AND (s.CE_siege = "1" AND s.CE_idOrgane = 20) ORDER BY s.nom ASC, s.prenom ASC

> BUREAU DU CE SNCF MOBILITES PICARDIE

M. Denis VAL - Secrétaire
Cliquez pour agrandir

CGT

Etablissement : TECHNICENTRE PICARDIE
Unité d'affectation : GROUPE METHODE

M. François VIDAL - Trésorier
Pas de zoom disponible

UNSA


M. Vincent DAILLY - Membre
Cliquez pour agrandir

CGT

Etablissement : EMT HP
Unité d'affectation : Amiens
Tel fixe pro : 0632783852

> MEMBRES DU CE SNCF MOBILITES PICARDIE

Membres suppléants

M. Marc LEVENT - Membre
Cliquez pour agrandir

UNSA

Etablissement : DD TER
Unité d'affectation : Conception
Tel fixe pro : 240835

Moteur de recherche
Rechercher :