SELECT Attachement.Titre, Attachement.Extrait,Attachement.courriel_sommaire,Attachement.niveau2,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,Attachement.Photo_mini,Attachement.Photo_texte,Attachement.Id,Attachement.cout,Attachement.mise_depart,Attachement.source,Attachement.source_web,Attachement.web,Attachement.target,Attachement.Categorie_attach,Attach_Cat.Label_fr,Attach_Cat.Label_en FROM Attachement LEFT JOIN Attach_Cat ON Attachement.Categorie_attach=Attach_Cat.id WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Source_Id=#attributes.Id# AND Module='#attributes.Module#' ORDER BY #attributes.attachtri#