|
SELECT SQL_BIG_RESULT distinct Groupe_1.ID as ID_Champ_0_0,7328 as ID_ResChamp_0_0,Groupe_1.ID as ID_Champ_1_0,7328 as ID_ResChamp_1_0,Data_8.ID as ID_Champ_12_0,225 as ID_ResChamp_12_0,Data_6.ID as ID_Champ_12_1,9 as ID_ResChamp_12_1,Data_4.ID as ID_Champ_12_10,267 as ID_ResChamp_12_10,Evt_5.ID as ID_Champ_12_11,9 as ID_ResChamp_12_11,Groupe_1.ID as ID_Champ_15_0,7328 as ID_ResChamp_15_0,EvtFiltre.ID as Evt_ID_Champ_0_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Champ_0_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Champ_0_0,EvtFiltre.ID as Evt_ID_Date_Deb_Champ_1_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Date_Deb_Champ_1_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Date_Deb_Champ_1_0,EvtFiltre.ID as Evt_ID_Date_TDeb_Champ_1_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Date_TDeb_Champ_1_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Date_TDeb_Champ_1_0,EvtFiltre.ID as Evt_ID_Date_SDeb_Champ_1_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Date_SDeb_Champ_1_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Date_SDeb_Champ_1_0,EvtFiltre.ID as Evt_ID_Date_Fin_Champ_1_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Date_Fin_Champ_1_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Date_Fin_Champ_1_0,EvtFiltre.ID as Evt_ID_Date_SFin_Champ_1_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Date_SFin_Champ_1_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Date_SFin_Champ_1_0,EvtFiltre.ID as Evt_ID_Date_TFin_Champ_1_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Date_TFin_Champ_1_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Date_TFin_Champ_1_0,Evt_7.ID as Evt_ID_Champ_12_0,Evt_7.ID_EvtData as Evt_ID_EvtData_Champ_12_0,Evt_7.ID_ResEvtData as Evt_ID_ResEvtData_Champ_12_0,Evt_5.ID as Evt_ID_Champ_12_1,Evt_5.ID_EvtData as Evt_ID_EvtData_Champ_12_1,Evt_5.ID_ResEvtData as Evt_ID_ResEvtData_Champ_12_1,Evt_3.ID as Evt_ID_Champ_12_10,Evt_3.ID_EvtData as Evt_ID_EvtData_Champ_12_10,Evt_3.ID_ResEvtData as Evt_ID_ResEvtData_Champ_12_10,Evt_5.ID as Evt_ID_Date_Deb_Champ_12_11,Evt_5.ID_EvtData as Evt_ID_EvtData_Date_Deb_Champ_12_11,Evt_5.ID_ResEvtData as Evt_ID_ResEvtData_Date_Deb_Champ_12_11,Evt_5.ID as Evt_ID_Date_TDeb_Champ_12_11,Evt_5.ID_EvtData as Evt_ID_EvtData_Date_TDeb_Champ_12_11,Evt_5.ID_ResEvtData as Evt_ID_ResEvtData_Date_TDeb_Champ_12_11,Evt_5.ID as Evt_ID_Date_SDeb_Champ_12_11,Evt_5.ID_EvtData as Evt_ID_EvtData_Date_SDeb_Champ_12_11,Evt_5.ID_ResEvtData as Evt_ID_ResEvtData_Date_SDeb_Champ_12_11,Evt_5.ID as Evt_ID_Date_Fin_Champ_12_11,Evt_5.ID_EvtData as Evt_ID_EvtData_Date_Fin_Champ_12_11,Evt_5.ID_ResEvtData as Evt_ID_ResEvtData_Date_Fin_Champ_12_11,Evt_5.ID as Evt_ID_Date_SFin_Champ_12_11,Evt_5.ID_EvtData as Evt_ID_EvtData_Date_SFin_Champ_12_11,Evt_5.ID_ResEvtData as Evt_ID_ResEvtData_Date_SFin_Champ_12_11,Evt_5.ID as Evt_ID_Date_TFin_Champ_12_11,Evt_5.ID_EvtData as Evt_ID_EvtData_Date_TFin_Champ_12_11,Evt_5.ID_ResEvtData as Evt_ID_ResEvtData_Date_TFin_Champ_12_11,EvtFiltre.ID as Evt_ID_Champ_15_0,EvtFiltre.ID_EvtData as Evt_ID_EvtData_Champ_15_0,EvtFiltre.ID_ResEvtData as Evt_ID_ResEvtData_Champ_15_0,Groupe_1.Nom as Champ_0_0,Groupe_1.Date_Deb as Date_Deb_Champ_1_0,Groupe_1.Date_TDeb as Date_TDeb_Champ_1_0,Groupe_1.Date_SDeb as Date_SDeb_Champ_1_0,Groupe_1.Date_Fin as Date_Fin_Champ_1_0,Groupe_1.Date_SFin as Date_SFin_Champ_1_0,Groupe_1.Date_TFin as Date_TFin_Champ_1_0,Data_8.CP as Champ_12_0,Data_6.Commune as Champ_12_1,Data_4.Insee as Champ_12_10,Evt_5.Date_Deb as Date_Deb_Champ_12_11,Evt_5.Date_TDeb as Date_TDeb_Champ_12_11,Evt_5.Date_SDeb as Date_SDeb_Champ_12_11,Evt_5.Date_Fin as Date_Fin_Champ_12_11,Evt_5.Date_SFin as Date_SFin_Champ_12_11,Evt_5.Date_TFin as Date_TFin_Champ_12_11,Groupe_1.ID as Champ_15_0 from FF_Evenement as EvtFiltre left join FF_Data_7328 as Groupe_1 on EvtFiltre.ID_Enfant=Groupe_1.ID and EvtFiltre.ID_ResEnfant=7328 left join FF_Evenement as Evt_3 on (Evt_3.ID_Enfant=Groupe_1.ID and Evt_3.ID_ResEnfant=7328 ) and ( (Evt_3.ID_Ressource=234 and Evt_3.ID_ResParent=267) ) left join FF_Data_267 as Data_4 on Evt_3.ID_Parent=Data_4.ID and Evt_3.ID_ResParent=267 left join FF_Evenement as Evt_5 on (Evt_5.ID_Parent=Data_4.ID and Evt_5.ID_ResParent=267 ) and ( (Evt_5.ID_Ressource=268 and Evt_5.ID_ResEnfant=9) ) left join FF_Data_9 as Data_6 on Evt_5.ID_Enfant=Data_6.ID and Evt_5.ID_ResEnfant=9 left join FF_Evenement as Evt_7 on (Evt_7.ID_Parent=Data_4.ID and Evt_7.ID_ResParent=267 ) and ( (Evt_7.ID_Ressource=233 and Evt_7.ID_ResEnfant=225) ) left join FF_Data_225 as Data_8 on Evt_7.ID_Enfant=Data_8.ID and Evt_7.ID_ResEnfant=225 Where EvtFiltre.ID=38642417 Order by Groupe_1.Nom ASC Unknown column 'Groupe_1.Date_Deb' in 'field list' List : Resource id #6 Standard :Resource id #5 -> Resource id #5 Requete générée en 0.001 secondes
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lieux |
|
|
|
|
Gares / Ouvrage |
|
|
|
|
Lignes |
|
|
|
|
Compagnies |
|
|
|
|
Personnes |
|
|
|
|
Mat. Roulant |
|
|
|
|
Petit Matériel |
|
|
|
|
Références |
|
|
|
|
|
©DR - France Ferroviaire tous droits réservés
|
|
|