SELECT Attachement.Titre, Attachement.Extrait,Attachement.Description, Attachement.Photo_texte, Attachement.Attachement_texte, Attachement.Attachement,Attachement.Attachement_Poid,Attachement.Attachement2,Attachement.Attachement2_texte,Attachement.Attachement_Poid2,Attachement.Attachement3,Attachement.Attachement3_texte,Attachement.Attachement_Poid3,Attachement.Attachement4,Attachement.Attachement4_texte,Attachement.Attachement_Poid4,Attachement.Photo_mini,Attachement.Photo_texte,Attachement.Id,Attachement.cout,Attachement.Categorie_attach,Attachement.Clic,Attach_Cat.Label_fr FROM Attachement LEFT JOIN Attach_Cat ON Attachement.Categorie_attach=Attach_Cat.id WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#niveau5='1' and Attachement.repertoire_no='#attributes.repertoire_no#' ORDER BY #attributes.mediatri#