SELECT Fiches.Web as webpath,Sections_Pages.Id,Sections_Pages.Repertoire_No,Sections_Pages.Categorie_No,Sections_Pages.Sequence_No,Sections_Pages.niveau,Sections_Pages.niveau2,Sections_Pages.niveau5,Sections_Pages.Titre,Sections_Pages.titre2,Sections_Pages.Actif as actif,Sections_Pages.Attachement,Sections_Pages.Attachement_Poid,Sections_Pages.Attachement_Texte,Sections_Pages.Attachement2, Sections_Pages.Attachement2_texte, Sections_Pages.Attachement_Poid2, Sections_Pages.Attachement3, Sections_Pages.Attachement3_texte, Sections_Pages.Attachement_Poid3, Sections_Pages.Attachement4, Sections_Pages.Attachement4_texte, Sections_Pages.Attachement_Poid4, Sections_Pages.Description,Sections_Pages.Extrait,Sections_Pages.Photo,Sections_Pages.Photo_mini,Sections_Pages.Photo_texte,Sections_Pages.Classement,Sections_Pages.Entree,Sections_Pages.Modification,Sections_Pages.Width,Sections_Pages.Height,Sections_Pages.Niveau2, Sections_Pages.Divers1_t, Sections_Pages.Divers1, Sections_Pages.Divers2_t, Sections_Pages.Divers2, Sections_Pages.Divers3_t, Sections_Pages.Divers3, Sections_Pages.Divers4_t, Sections_Pages.Divers4, Sections_Pages.Divers5_t, Sections_Pages.Divers5, Sections_Pages.Divers6_t, Sections_Pages.Divers6, Sections_Pages.Divers7_t, Sections_Pages.Divers7, Sections_Pages.Divers8_t, Sections_Pages.Divers8, Sections_Pages.Divers9_t, Sections_Pages.Divers9, Sections_Pages.Divers10_t, Sections_Pages.Divers10, Sections_Pages.Url1, Sections_Pages.Url2, Sections_Pages.Url3, Sections_Pages.Url4, Sections_Pages.Url5, Sections_Pages.Url6, Sections_Pages.Url7, Sections_Pages.Url8, Sections_Pages.Url9, Sections_Pages.Url10,Sections_Pages.codehaut,Sections_Pages.reference,Sections_Pages.web,Sections_Pages.eventid,Sections_Pages.formid,Sections_Pages.Suggestion,Sections_Pages.pushpage,Sections_Pages.toemail,Sections_Pages.partenaireid,Sections_Pages.albumphoto,Sections_Pages.listdist,Sections_Pages.target,Sections_Pages.style 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# ORDER BY Sections_Pages.Tri, Sections_Pages.Titre