SELECT Fiches.Web as webpath,Sections.Id,Sections.Repertoire_No,Sections.niveau,Sections.niveau2,Sections.niveau5,Sections.Titre,Sections.titre2,Sections.Actif as actif,Sections.Attachement,Sections.Attachement_Poid,Sections.Attachement_Texte,Sections.Attachement2, Sections.Attachement2_texte, Sections.Attachement_Poid2, Sections.Attachement3, Sections.Attachement3_texte, Sections.Attachement_Poid3, Sections.Attachement4, Sections.Attachement4_texte, Sections.Attachement_Poid4, Sections.Description,Sections.Extrait,Sections.Photo,Sections.Photo_mini,Sections.Photo_texte,Sections.Classement,Sections.Entree,Sections.Modification,Sections.Width,Sections.Height,Sections.Niveau2, Sections.Divers1_t, Sections.Divers1, Sections.Divers2_t, Sections.Divers2, Sections.Divers3_t, Sections.Divers3, Sections.Divers4_t, Sections.Divers4, Sections.Divers5_t, Sections.Divers5, Sections.Divers6_t, Sections.Divers6, Sections.Divers7_t, Sections.Divers7, Sections.Divers8_t, Sections.Divers8, Sections.Divers9_t, Sections.Divers9, Sections.Divers10_t, Sections.Divers10, Sections.Url1, Sections.Url2, Sections.Url3, Sections.Url4, Sections.Url5, Sections.Url6, Sections.Url7, Sections.Url8, Sections.Url9, Sections.Url10,Sections.web,Sections.target FROM Sections LEFT JOIN Fiches ON Sections.Repertoire_No = Fiches.Repertoire_No WHERE #PreserveSingleQuotes(SecActifQuery)##PreserveSingleQuotes(SecEntreeQuery)##PreserveSingleQuotes(SecExpirationQuery)#Sections.niveau5='1' and Sections.repertoire_no=#attributes.repertoire_no# and Sections.photo_mini is not Null ORDER BY Sections.Tri, Sections.Titre