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` = '26043'
AND `oim_obs_index` = `obs_index`
AND `img_index` = `obs_index`

AND `oim_date` <= CURRENT_TIMESTAMP

AND ( `img_affichage` = '1' OR `obs_mbr_index` = '' )
;
C-27 J Spartan - 08 | Transporto Eskadrile (Lituanie) | Fairford - 15.07.18 - RIAT 2018 | Julien VILLIERE

Alenia C-27 J Spartan - 08/08 - Lituanie/Transporto Eskadrile

26043
Terrain Date Constructeur Appareil N° constructeur N° de série Immatriculation Etat Pays Opérateur Photographe Actions
Fairford - EGVA plus_16 15.07.18 Alenia C-27 J Spartan plus_16 4143 08 08 OPS LTU Transporto Eskadrile 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

Date Terrain Evénement Actions
15.07.18 Fairford - EGVA RIAT 2018 gestion_16 photos_16

Pedigree : historique des immatriculations et opérateurs

Marque Pays Opérateur(s) Etat Début Fin Commentaire Actions
08 Lituanie Transporto Eskadrile OPS 07/2018 - gestion_16.png photos_16.png

C-27 J Spartan 4143 08

CSX62255

[ gestion.png photos.png ]

© 2009-2020 Delta Base - 86 visiteurs
 Visites :