select esp_typ.typ_lib, liv_cla.cla_pla, liv_cla.cla_qui, liv_cla.cla_ban, liv_nag.nag_rel, ktp_ctg.ctg_id, liv_cla.cla_iuf, liv_cla.cla_psg, liv_cla.cla_tps, liv_cla.cla_pts, esp_typ.typ_id, liv_cla.cla_cat, ktp_ctg.ctg_lib, liv_cla.cla_ord, liv_cla.cla_rct, liv_cla.cla_com, ktp_ctg.ctg_maxi, ktp_ctg.ctg_mini, esp_rec.rec_lon, ktp_epr.epr_lib, esp_sty.sty_lib, esp_gen.gen_lib, ktp_epr.epr_tri from liv_cla, liv_nag, esp_typ, ktp_ctg, esp_sty, esp_gen, ktp_epr, esp_rec where liv_cla.cla_nag = liv_nag.nag_nag and liv_cla.cla_typ = esp_typ.typ_cod and liv_nag.nag_nag = ktp_epr.epr_tri and ktp_epr.epr_idcpt = ktp_ctg.ctg_idcpt and ktp_epr.epr_idsty = esp_sty.sty_id and ktp_epr.epr_idgen = esp_gen.gen_id and ktp_ctg.ctg_id = liv_cla.cla_cat and liv_nag.nag_cod = liv_cla.cla_cod and esp_rec.rec_cod = liv_cla.cla_com and ktp_ctg.ctg_idcpt = liv_cla.cla_cod and liv_cla.cla_cod = 6071706051 and liv_cla.cla_ban = 'CN MARSEILLE' and liv_cla.cla_qui = 'MERDY Alizée' order by ktp_epr.epr_tri asc, esp_typ.typ_id asc, liv_cla.cla_cat asc, liv_cla.cla_ord asc ;

T.L.D. = Tiempo limita sobrepasado - H.C. = Fuera de concurso - N.C. = No clasificado