SELECT `obs_index` , `obs_trn_nom` , T.`trn_pay_code` , `obs_date_info` , `obs_constructeur` , `obs_type` , `obs_numero` , `obs_msn` , `obs_marque` , `obs_etat` , `eta_clair` , `opr_index` , `obs_opr_pay_code` ,
`pay_nom` , `obs_opr_nom` , `obs_mbr_nom` , `obs_mbr_index` , `obs_commentaire` , DATE_FORMAT( `obs_date_ajout` , '%d.%m.%y' ) `obs_date_ajout` , `oim_imm_index` , `oim_date` , `imm_num_index` , `num_commentaire` ,
`mtg_index` , `mtg_nom` , `typ_fam_index` , `fam_famille` , `img_affichage` , `org_nom` , `gen_index` , `gen_nom` ,
S1.`sel_mbr_index` `sel_favori`, S2.`sel_mbr_index` `sel_panier` ,
`opr_date_debut` , `opr_date_fin` , `opr_commentaire` , `pub_index`
FROM ( `dr_spot_observations` , `dr_spot_images` , `dr_spot_observations_immatriculations` )
LEFT OUTER JOIN `dr_spot_ref_terrains` T ON T.`trn_nom` = `obs_trn_nom`
LEFT OUTER JOIN `dr_spot_avions_immatriculations` ON `imm_index` = `oim_imm_index`
LEFT OUTER JOIN `dr_spot_avions_numeros` ON `num_index` = `imm_num_index`
LEFT OUTER JOIN `dr_spot_ref_pays` ON `pay_code` = `obs_opr_pay_code`
LEFT OUTER JOIN ( `dr_spot_meetings_evenements` , `dr_spot_meetings_dates` , `dr_spot_ref_terrains` TM ) ON `mtg_trn_index` = TM.`trn_index` AND TM.`trn_nom` = `obs_trn_nom` AND `mtd_date` = `obs_date_info` AND `mtd_index` = `mtg_index`
LEFT OUTER JOIN `dr_spot_avions_types` ON `typ_nom` = `obs_type`
LEFT OUTER JOIN `dr_spot_avions_familles` ON `fam_index` = `typ_fam_index`
LEFT OUTER JOIN `dr_spot_ref_operateur` ON `opr_index` = `imm_opr_index`
LEFT OUTER JOIN `dr_spot_ref_org_generique` ON `gen_index` = `opr_gen_index`
LEFT OUTER JOIN `dr_spot_ref_organisme` ON ( `org_pay_code` = `opr_pay_code` AND `org_gen_index` = `opr_gen_index` )
LEFT OUTER JOIN `dr_spot_selection` S1 ON ( S1.`sel_type` = '1' AND S1.`sel_img_index` = `obs_index` AND S1.`sel_mbr_index` = '' )
LEFT OUTER JOIN `dr_spot_selection` S2 ON ( S2.`sel_type` = '2' AND S2.`sel_img_index` = `obs_index` AND S2.`sel_mbr_index` = '' )
LEFT OUTER JOIN `dr_spot_ref_etat` ON `eta_code` = `obs_etat`
LEFT OUTER JOIN `dr_spot_publications` ON `pub_img_index` = `obs_index`

WHERE `obs_index` = '26038'
AND `oim_obs_index` = `obs_index`
AND `img_index` = `obs_index`

AND `oim_date` <= CURRENT_TIMESTAMP

AND ( `img_affichage` = '1' OR `obs_mbr_index` = '' )
;
CH-47 D Chinook - 93-00673 - D-106 | 298 Sqn (Pays-Bas) | Fairford - 15.07.18 - RIAT 2018 | Julien VILLIERE

Boeing Vertol CH-47 D Chinook - 93-00673/D-106 - Pays-Bas/298 Sqn

26038
Terrain Date Constructeur Appareil N° constructeur N° de série Immatriculation Etat Pays Opérateur Photographe Actions
Fairford - EGVA plus_16 15.07.18 Boeing Vertol CH-47 D Chinook plus_16 M-4106 93-00673 D-106 OPS NLD 298 Sqn plus_16 Julien VILLIERE recherche_16 dates_16.png message_16 Favorite-gris Cart-gris outils_16_gris

Liens forum :

Icône : - Miniature : - Diapositive : - Grande taille :

| HTML :

|


Autres observations

Pedigree : historique des immatriculations et opérateurs

Marque Pays Opérateur(s) Etat Début Fin Commentaire Actions
D-106 Pays-Bas 298 Sqn OPS 21.06.14 - Luchtmachtdagen 2014 gestion_16.png photos_16.png

CH-47 D Chinook M-4106 93-00673

ML013

[ gestion.png photos.png ]

© 2009-2020 Delta Base - 90 visiteurs
 Visites :