SELECT Fiches.Web as webpath,#attributes.table#.Description,#attributes.table#.Attachement_texte, #attributes.table#.Attachement,#attributes.table#.Attachement_Poid,#attributes.table#.Attachement2,#attributes.table#.Attachement2_texte,#attributes.table#.Attachement_Poid2,#attributes.table#.Attachement3,#attributes.table#.Attachement3_texte,#attributes.table#.Attachement_Poid3,#attributes.table#.Attachement4,#attributes.table#.Attachement4_texte,#attributes.table#.Attachement_Poid4,#attributes.table#.Photo_mini,#attributes.table#.Photo_texte,#attributes.table#.Id,#attributes.table#.niveau2
FROM #attributes.table# LEFT JOIN Fiches ON #attributes.table#.Repertoire_No = Fiches.Repertoire_No
WHERE #attributes.table#.Id=#attributes.Id#
ORDER BY #attributes.table#.Tri