SELECT Attachement.Titre, Attachement.Extrait,Attachement.Description, Attachement.categorie_attach,Attachement.web,Attachement.photo,Attachement.Photo,Attachement.Photo_texte, Attachement.Attachement_texte, Attachement.Attachement,Attachement.Attachement_Poid,Attachement.Attachement2,Attachement.Attachement2_texte,Attachement.Attachement_Poid2,Attachement.Attachement3,Attachement.Attachement3_texte,Attachement.Attachement_Poid3,Attachement.Attachement4,Attachement.Attachement4_texte,Attachement.Attachement_Poid4,Attachement.Photo_mini,Attachement.Photo_texte,Attachement.Id,Attachement.clic,Attachement.niveau2,Attach_Cat.Label_fr FROM Attachement LEFT JOIN Attach_Cat ON Attachement.Categorie_attach=Attach_Cat.id WHERE Attachement.actif='3' and Attachement.repertoire_no=#attributes.repertoire_no# ORDER BY Label_fr,Titre

#web#"http://#Replace("#getbaseinfo.web#","http://","","ALL")#/#attributes.FicheBase#?#attributes.URLParam#Voir=media&Id=#Id#&Repertoire_No=#attributes.Repertoire_No#"" title="#titre#"> #Photo_texte#

#titre#

Désolé

Aucun album de disponible

#Titre##Titre#

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#QryAttach.Extrait#", "([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#", "([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","all")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#", "#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

#QryAttach.Attachement_texte#

#Right("#QryAttach.Attachement#",3)##Right("#QryAttach.Attachement#",4)##Right("#QryAttach.Attachement#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action1# le document #QryAttach.Attachement_texte#" title="#attributes.Action1# le document #QryAttach.Attachement_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid##attributes.Action1#

#QryAttach.Attachement2_texte#

#Right("#QryAttach.Attachement2#",3)##Right("#QryAttach.Attachement2#",4)##Right("#QryAttach.Attachement2#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action2# le document #QryAttach.Attachement2_texte#" title="#attributes.Action2# le document #QryAttach.Attachement2_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid2##attributes.Action2#

#QryAttach.Attachement3_texte#

#Right("#QryAttach.Attachement3#",3)##Right("#QryAttach.Attachement3#",4)##Right("#QryAttach.Attachement3#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action3# le document #QryAttach.Attachement3_texte#" title="#attributes.Action3# le document #QryAttach.Attachement3_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid3##attributes.Action3#

#QryAttach.Attachement4_texte#

#Right("#QryAttach.Attachement4#",3)##Right("#QryAttach.Attachement4#",4)##Right("#QryAttach.Attachement4#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action4# le document #QryAttach.Attachement4_texte#" title="#attributes.Action4# le document #QryAttach.Attachement4_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid4##attributes.Action4#

--->