select gbr_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, gbr_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, gbr_rec.rec_lon, ktp_epr.epr_lib, gbr_sty.sty_lib, gbr_gen.gen_lib, ktp_epr.epr_tri from liv_cla, liv_nag, gbr_typ, ktp_ctg, gbr_sty, gbr_gen, ktp_epr, gbr_rec where liv_cla.cla_nag = liv_nag.nag_nag and liv_cla.cla_typ = gbr_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 = gbr_sty.sty_id and ktp_epr.epr_idgen = gbr_gen.gen_id and ktp_ctg.ctg_id = liv_cla.cla_cat and liv_nag.nag_cod = liv_cla.cla_cod and gbr_rec.rec_cod = liv_cla.cla_com and ktp_ctg.ctg_idcpt = liv_cla.cla_cod and liv_cla.cla_cod = 206042345031 and liv_cla.cla_ban = 'MILNGAVIE ' and liv_cla.cla_qui = 'AVERELL Lauren' order by ktp_epr.epr_tri asc, gbr_typ.typ_id asc, liv_cla.cla_cat asc, liv_cla.cla_ord asc ;

T.L.D. = Exceeded limit time - H.C. = Outside the competition - N.C. = Out of the competition