SELECT Id, Web, Titre, Description, Lieu, Ville, Presentateur, Web_presentateur, Information, date_debut, date_fin, Photo_mini, Source_Id, Exposant, Sequence_No,periode,salleid,billetterie_info,billetterie_url FROM Agenda3 WHERE Actif='3'#PreserveSingleQuotes(QryPeriode)##PreserveSingleQuotes(DateFiltre)##PreserveSingleQuotes(Var.QUERY)# ORDER BY #triquery#

Date	À l'affiche	DiffuseursProducteursPrésentateurs
#Periode#
#DateFormat("#output.date_debut#","d")# #lsDateFormat("#output.date_debut#","mmm")# - #DateFormat("#output.date_fin#","d")# #lsDateFormat("#output.date_fin#","mmm")#	#output.Titre#	">#output.Presentateur# [#output.Web_presentateur#http://#output.Web_presentateur#" target="_top">Info] #output.Presentateur# 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# 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