SELECT Fiches.Tri,Fiches.Web as Webpath,Fiches.niveau7 as intro,Fiches.niveau4 as accueil,Publications.Photo_mini,Publications.Photo_texte,Publications.Titre2,Publications.Date,Publications.Volume,Publications.Numero,Publications.Id,Publications.Titre,Publications.repertoire_no,Publications.entree,Publications.niveau,Publications.tri as Journaltri FROM Publications LEFT JOIN Fiches ON Publications.Repertoire_No = Fiches.Repertoire_No WHERE Publications.db_source='2137985646' AND Publications.Categorie_No=999998 AND Publications.niveau='2' ORDER BY Fiches.Tri,Publications.Tri,Publications.Entree,Publications.Titre; SELECT Fiches.Tri,Fiches.Web as Webpath,Fiches.niveau7 as intro,Fiches.niveau4 as accueil,Publications.Sequence_no,Publications.Photo_mini,Publications.Photo_texte,Publications.Titre2,Publications.Date,Publications.Volume,Publications.Numero,Publications.Id,Publications.Titre,Publications.repertoire_no,Publications.entree,Publications.niveau,Publications.tri as Articletri FROM Publications LEFT JOIN Fiches ON Publications.Repertoire_No = Fiches.Repertoire_No WHERE Publications.db_source='2137985646' AND Publications.Categorie_No=999998 AND Publications.niveau='3' Order By Publications.Volume, Publications.Tri,Publications.Entree,Publications.Numero, Publications.Titre

Liste de #total# articles	Valider	Modifier
Volume #replace (Journal.Volume,chr(10)," ","all")# #Titre2# - Intro		-
Accueil		-
Volume #replace (Journal.Volume,chr(10)," ","all")# Numéro #replace (Journal.Numero,chr(10)," ","all")#.#Journaltri# #Journal.Date# [#LSDateFormat(Journal.entree,'d mmm yyyy')#] #Journal.Titre##Journal.Titre2#
Volume #replace (Article.Volume,chr(10)," ","all")# Numéro #replace (Article.Numero,chr(10)," ","all")#.#Articletri# #Article.Date# [#LSDateFormat(Article.entree,'d mmm yyyy')#] #Article.Titre##Article.Titre2#

Aucune entrée de trouvée