E-lissa (decalog) simple db structure extraction

elissa.sql

SELECT notices.Titre, 
	sup1.ISBN, 
	sup1.Qualif_ISBN, 
	stitre.Sous_Titre, 
	para.Titre_Para, 
	t_forme.Titre_Forme, 
	t_uni.Titre_Uniforme, 
	langue.Lib_Langue, 
	langue.Code_Langue, 
	langue_originale.Lib_Langue AS Lib_Langue_Originale, 
	langue_originale.Code_Langue AS Code_Langue_Originale, 
	not_ved.ID_Ved, 
	vedettes.Nom_Ved, 
	vedettes.Prenom_Ved, 
	vedettes.Qualificatif, 
	vedettes.Dates, 
	not_ved2.ID_Ved, 
	vedettes2.Nom_Ved, 
	vedettes2.Prenom_Ved, 
	vedettes2.Qualificatif, 
	vedettes2.Dates, 
	GROUP_CONCAT(matiere.Lib_Matiere SEPARATOR ' ; ') AS matieres, 
	collection.Lib_Coll, 
	not_coll.Num_Coll, 
	not_coll.ISSN_Coll, 
	classification.Lib_Class, 
	classification.Domaine, 
	sup1.Nb_Pages, 
	notices.Format, 
	notices.Mat_Accomp, 
	editeurs.Lib_Edi, 
	not_edi.Lieu_Edit, 
	not_edi.Annee_Edit, 
	not_edi.Mention_Edi, 
	notes.Note, 
	n_contenu.Contenu, 
	resumes.Resume, 
	expl.N_Inventaire, 
	cotes.Lib_Cote, 
	localisation.Lib_Local1, 
	localisation.Lib_Local2, 
	nature_acq.Lib_Nature,
	notices.Prix, 
	notices.Mention1, 
	notices.Mention2, 
	sup1.Illustration 
FROM expl LEFT OUTER JOIN notices ON expl.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN not_class ON not_class.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN classification ON classification.ID_Class = not_class.ID_Class
	 LEFT OUTER JOIN not_coll ON not_coll.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN collection ON collection.ID_Coll = not_coll.ID_Coll
	 LEFT OUTER JOIN not_mat ON not_mat.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN matiere ON matiere.ID_Matiere = not_mat.ID_Matiere
	 LEFT OUTER JOIN not_tforme ON not_tforme.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN t_forme ON t_forme.ID_TForme = not_tforme.ID_TForme
	 LEFT OUTER JOIN not_tuni ON not_tuni.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN t_uni ON t_uni.ID_TUni = not_tuni.ID_TUni
	 LEFT OUTER JOIN para ON para.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN n_contenu ON n_contenu.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN sup1 ON sup1.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN not_ved ON not_ved.ID_Notice = notices.ID_Notice AND not_ved.Pos_Ved =1
	 LEFT OUTER JOIN vedettes ON vedettes.ID_Ved = not_ved.ID_Ved
	 LEFT OUTER JOIN not_ved not_ved2 ON not_ved2.ID_Notice = notices.ID_Notice AND not_ved2.Pos_Ved =2
	 LEFT OUTER JOIN vedettes vedettes2 ON vedettes2.ID_Ved = not_ved2.ID_Ved
	 LEFT OUTER JOIN stitre ON stitre.ID_Notice = notices.Titre
	 LEFT OUTER JOIN resumes ON resumes.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN notes ON notes.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN not_edi ON not_edi.ID_Notice = notices.ID_Notice
	 LEFT OUTER JOIN langue ON langue.ID_Langue = notices.ID_Langue
	 LEFT OUTER JOIN langue langue_originale ON langue_originale.ID_Langue = notices.ID_Langue_Origine
	 LEFT OUTER JOIN editeurs ON editeurs.ID_Edi = not_edi.ID_Edi
	 LEFT OUTER JOIN cotes ON cotes.ID_Cote = expl.ID_Cote
	 LEFT OUTER JOIN nature_acq ON nature_acq.ID_Nature = expl.ID_Nature
	 LEFT OUTER JOIN localisation ON localisation.ID_Local = expl.ID_Local
GROUP BY expl.N_Inventaire