SELECT Fiches.Web as webpath,Sections_Pages.Id,Sections_Pages.categorie_no,Sections_Pages.Repertoire_No,Sections_Pages.niveau,Sections_Pages.niveau2,Sections_Pages.niveau5,Sections_Pages.Titre,Sections_Pages.Description,Sections_Pages.Extrait,Sections_Pages.Photo_mini,Sections_Pages.Photo_texte,Sections_Pages.web,Sections_Pages.target FROM Sections_Pages LEFT JOIN Fiches ON Sections_Pages.Repertoire_No = Fiches.Repertoire_No WHERE #PreserveSingleQuotes(SecActifQuery)##PreserveSingleQuotes(SecEntreeQuery)##PreserveSingleQuotes(SecExpirationQuery)#Sections_Pages.niveau5='1' and Sections_Pages.repertoire_no=#attributes.repertoire_no# and Sections_Pages.photo_mini is not Null ORDER BY Sections_Pages.entree desc,Sections_Pages.Tri, Sections_Pages.Titre