SELECT * FROM Fiches WHERE Repertoire_No=#attributes.art# SELECT Fiches.societe,Fiches.repertoire_no,Fiches.lieu,technique.billetterie,technique.billetterie_info,technique.billetterie_url FROM fiches LEFT JOIN technique ON fiches.repertoire_no = technique.repertoire_no WHERE fiches.repertoire_no IN (#GetFicheInfo.salleid#)

#Titre#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

Contact :
#Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

 Contact :
#Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Prenom# #Nom#

 #Fonction#
 #Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

#Titre#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

Contact :
#Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

 Contact :
#Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Prenom# #Nom#

 #Fonction#
 #Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

#Titre#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

 #Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

 Contact :
#Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Prenom# #Nom#

 #Fonction#
 #Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

#Titre#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

 #Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

Contact :
#Prenom# #Nom##Prenom# #Nom#, #Fonction#

#Prenom# #Nom#

 #Fonction#
 #Societe# (#Sigle#)

Année de fondation :
#replace (Annee,chr(10),"
","all")#

Adresse :
#Division#
 #replace (Adresse ,chr(10),"
","all")#
 #adresse_line2#
 #adresse_line3#
 #Ville# ()  #Code_postal#

Téléphone :
#Telephone# • #TelephoneA#
 #TelephoneB_desc# : #TelephoneB#
 #TelephoneC_desc# : #TelephoneC#

Télécopieur :
#Telecopieur# #Telecopieur_desc#

Courriel :
#Courriel#

Sites : #Web#

Site : • #Web_anglais#

Lieu d'origine :
#replace (Origine,chr(10),"
","all")#

Lieux de diffusion

#equipe_t# :
#replace("#REReplace("#REReplace("#equipe#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Nombre d'employés :
#replace (nbemployes,chr(10),"
","all")#

Mandat : Démarche artistiqueMission et mandat
#replace("#REReplace("#REReplace("#Mission#","([[: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")#","#chr(13)##chr(10)#","
","all")#

#experience_t# :
#replace("#REReplace("#REReplace("#experience#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Produits :
#replace("#REReplace("#REReplace("#Service_t#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Services :
#replace("#REReplace("#REReplace("#Services#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Activités :
#replace("#REReplace("#REReplace("#activites#","([[: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")#","#chr(13)##chr(10)#","
","all")#

#inventions_t# :
#replace("#REReplace("#REReplace("#inventions#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Projets :

Réalisations :

Exportation :
#replace("#REReplace("#REReplace("#Exportation#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Nouveautés :
#replace("#REReplace("#REReplace("#nouveautes#","([[: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")#","#chr(13)##chr(10)#","
","all")#

#divers12_t# :
#replace("#REReplace("#REReplace("#divers12#","([[: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")#","#chr(13)##chr(10)#","
","all")#

#divers16_t# :
#replace("#REReplace("#REReplace("#divers16#","([[: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")#","#chr(13)##chr(10)#","
","all")#

#divers17_t# :
#replace("#REReplace("#REReplace("#divers17#","([[: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")#","#chr(13)##chr(10)#","
","all")#

À vendre :
#replace("#REReplace("#REReplace("#vendre#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Nous cherchons :
#replace("#REReplace("#REReplace("#recherche#","([[: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")#","#chr(13)##chr(10)#","
","all")#

Pour nous joindre :
#replace("#REReplace("#REReplace("#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")#","#chr(13)##chr(10)#","
","all")#



Services en français : #langue_service#
 Secteur :
Thème : #replace (Classement,"#chr(13)##chr(10)#",", ","all")#
 Services offerts : #replace (Domaine_details,",",", ","all")#

Modification : #LSDateFormat('#Modification#','d mmmm yyyy')#

« Retour