SELECT Fiches.Web, Attachement.Titre, Attachement.Extrait, Attachement.Photo_mini, Attachement.Photo_texte, Attachement.Categorie_attach, Attachement.Id FROM Attachement LEFT JOIN Fiches ON Attachement.Repertoire_No = Fiches.Repertoire_No WHERE #PreserveSingleQuotes(GlobalQuery)##PreserveSingleQuotes(ClassQuery)##PreserveSingleQuotes(AlphaSearch)##PreserveSingleQuotes(ItineraireQuery)##PreserveSingleQuotes(SecteurQuery)##PreserveSingleQuotes(DomaineQuery)##PreserveSingleQuotes(NatureQuery)##PreserveSingleQuotes(PeriodeQuery)##PreserveSingleQuotes(LieuQuery)##PreserveSingleQuotes(VilleQuery)##PreserveSingleQuotes(RegionQuery)##PreserveSingleQuotes(DBSearch)#(Attachement.Actif='1' or Attachement.Actif='3') and Attachement.nature = 90 ORDER BY Attachement.Tri,Attachement.Titre

]*>", "", "ALL")# #attributes.Action#" title="#REReplace("#Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" BORDER="1" ALIGN="LEFT" HSPACE="3" VSPACE="3">

]*>", "", "ALL")#" title="#REReplace("#Titre#", "<[^>]*>", "", "ALL")#" BORDER="1" ALIGN="LEFT" HSPACE="3" VSPACE="3">

#Titre#
#QryAttach.Extrait#