#output.Titre#

#output.Titre#

SELECT Titre,Extrait,Description FROM Activites WHERE Id=#output.Source_Id# SELECT titre,extrait,description FROM sections_pages WHERE Id=#output.pageid# SELECT Fiches.societe,Fiches.lieu,Fiches.information,technique.billetterie,technique.billetterie_info,technique.billetterie_url FROM fiches LEFT JOIN technique ON fiches.repertoire_no = technique.repertoire_no WHERE fiches.repertoire_no=#output.salleid#

#output.Titre# #output.Titre# #output.Titre# #output.Titre# #Replace("#output.artiste#","#chr(13)##chr(10)#"," ","ALL")# #output.artiste_url#http://#output.artiste_url#" target="_blank"> #Replace("#output.artiste#","#chr(13)##chr(10)#"," ","ALL")# #Replace("#output.artiste#","#chr(13)##chr(10)#"," ","ALL")# #Replace("#output.activite#","#chr(13)##chr(10)#"," ","ALL")# #replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Description#","([[: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")# #output.suggestion#Pour plus d'information #replace("#REReplace("#REReplace("#REReplace("#REReplace("#sections_page.Description#","([[: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")# #output.suggestion#Pour plus d'information Pour plus d'information #replace("#REReplace("#REReplace("#REReplace("#REReplace("#Activites.Description#","([[: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")# #output.suggestion#Pour plus d'information Première partie : #Replace("#output.artiste1#","#chr(13)##chr(10)#"," ","ALL")# #output.artiste1_url#http://#output.artiste1_url#" target="_blank">#Replace("#output.artiste1#","#chr(13)##chr(10)#"," ","ALL")# #Replace("#output.artiste1#","#chr(13)##chr(10)#"," ","ALL")# #Replace("#output.activite1#","#chr(13)##chr(10)#"," ","ALL")# #replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.description1#","([[: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")# Deuxième partie : #Replace("#output.artiste2#","#chr(13)##chr(10)#"," ","ALL")# #output.artiste2_url#http://#output.artiste2_url#" target="_blank">#Replace("#output.artiste2#","#chr(13)##chr(10)#"," ","ALL")# #Replace("#output.artiste2#","#chr(13)##chr(10)#"," ","ALL")# #Replace("#output.activite2#","#chr(13)##chr(10)#"," ","ALL")# #replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.description2#","([[: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")# Quand : #DateFormat("#output.date_debut#","d")# #lsDateFormat("#output.date_debut#","mmm")# #DateFormat("#output.date_debut#","yyyy")##DateFormat("#output.date_debut#","d")# #lsDateFormat("#output.date_debut#","mmm")# #DateFormat("#output.date_debut#","yyyy")# - #DateFormat("#output.date_fin#","d")# #lsDateFormat("#output.date_fin#","mmm")# #DateFormat("#output.date_fin#","yyyy")# Heures : #TimeFormat(Heure_debut, "H")#h#TimeFormat(Heure_debut, "mm")# - #TimeFormat(Heure_fin, "H")#h#TimeFormat(Heure_fin, "mm")# Heure : #TimeFormat(Heure_debut, "H")#h#TimeFormat(Heure_debut, "mm")# Horaire : #Replace("#output.horaire#","#chr(13)##chr(10)#"," ","ALL")# Saison : #Replace("#output.periode#","#chr(13)##chr(10)#"," ","ALL")# Où : #salle.societe# Indication routière : #replace("#REReplace("#REReplace("#REReplace("#REReplace("#salle.lieu#","([[: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")# Où : #replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Lieu#","([[: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")# Ville : #output.Ville# Coût des billets : #replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.cout#","([[: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")# Information : #replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Information#","([[: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")# Information : #replace("#REReplace("#REReplace("#REReplace("#REReplace("#salle.Information#","([[: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")# Billetterie : #replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.billetterie_info#","([[: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")# Billetterie : #replace("#REReplace("#REReplace("#REReplace("#REReplace("#salle.billetterie_info#","([[: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")# Billetterie en ligne : #billetterie_url#http://#billetterie_url#" title="Achat de billet" target="_blank">Achat de billets Achat : #salle.billetterie_url#http://#billetterie_url#" title="Achat de billet en ligne" target="_blank">Achat de billets en ligne DiffuseurProducteurCoordonné parPrésentateur : ">#output.Presentateur# [#output.Web_presentateur#http://#output.Web_presentateur#" target="_top">Web] #output.Presentateur# Tél. : #output.telephone# Crédits : #Replace("#output.credits#","#chr(13)##chr(10)#"," ","ALL")# Commentaires : #Replace("#output.commentaires#","#chr(13)##chr(10)#"," ","ALL")# Événement : #evenement_url#http://#evenement_url#" title="Achat de billet en ligne" target="_blank">#output.evenement# #output.evenement#

« Retour