SELECT Photo_mini,Photo_texte,Titre2,Date,Volume,Numero,Id,Titre,Entree FROM Publications WHERE Repertoire_No=#Repertoire_No# AND niveau='2' AND Categorie_No=999998 AND (Actif='1' or Actif='3') ORDER BY #JournalTri#

Autres numéros Volume #replace (Journal_select.Volume,chr(10),"
","all")# Numéro #replace (Journal_select.Numero,chr(10),"
","all")# #Journal_select.Date#