IMPROVISION, demandez l'programme

0.001 : Connexion BDD sur foa-bdmaster:festival_off_avignon

0.001 : Connexion BDD sur foa-bdslave:festival_off_avignon

0.000 : 46 : SELECT * FROM registry

0.000 : 1 : SELECT * FROM foa_festival WHERE fes_inactif = 0 AND fes_dateDelete is null ORDER BY fes_dateCreation DESC LIMIT 1

0.003 : 1 : SELECT DISTINCT spe_id, spe_nom, spe_nom_en, spe_soutien, spe_mode,spe_idTarifInscriptionCompagnie,spe_papier,spe_publie,spe_duree,spe_age,spe_age_max, spe_accroche,spe_accrocheAnglais, spe_entreeLibre,spe_type_horaire, spe_manif_culturelle, spe_description, spe_descriptionAnglais, spe_descriptionCourte, spe_descriptionCourteAnglais, spe_descriptionCourtePapier, spe_deficienceVisuelle,spe_deficienceAuditive,spe_publicJeune,spe_publicAdulte,sto_ticketOff, spe_urlBandeAnnonce, spe_ecopack,spe_premiereFoisAvignon,spe_anneeCreation,spe_nouvelleCreation,spe_nombreEdition,spe_offLesMurs,spe_invitationSolidaire, spe_entreeLibre,spe_entreeAuChapeau,GROUP_CONCAT(CONCAT(ies_idEtape,',',ies_etat) SEPARATOR ';') as statuts_etape_inscription, spe_accessibleNonFrancophones, spe_idlangue, spe_idLangueSecondaire, spe_idLangueSurtitrage,spe_langueSigneFrancaise, spe_creationCollective, spe_idCompagnieReel,spe_numeroResa, sge_id,sge_nom,stp_nom,stp_id,stp_code_catalogue, c1.com_id,c1.com_no_licence, COALESCE(c2.com_nom,c1.com_nom) as com_nom,COALESCE(c2.com_description,c1.com_description) as com_description, COALESCE(c2.com_licence_affichee,c1.com_licence_affichee) as com_licence_affichee, COALESCE(c2.com_licence_num_recepisse,c1.com_licence_num_recepisse) as com_licence_num_recepisse, lie_id, lie_nom, the_id, the_nom, str_id,spe_sans_duree_papier,spe_idFestival, spl_id,adresse_structure.adr_region,adresse_structure.adr_pays,pays_libelle,spe_tpe,spe_droit_auteur,spe_maison_edition, (SELECT spt_montant_ttc FROM foa_spectacle_tarif WHERE spt_idSpectacle = spe_id AND spt_idTypeTarif = 1 AND spt_dateDelete is null LIMIT 1) as tarif_plein, ( SELECT DATE_FORMAT(rep_dateDebut, '%Hh%i') FROM foa_representation WHERE rep_idSpectacleLieu = spl_id AND rep_dateDelete IS NULL LIMIT 1 ) as horaire, pai_etatPaiement,prg_id as id_programme_valide, SUM(IF(rep_dateAnnulation IS NOT NULL, 1, 0)) = COUNT(*) as annuler, SUM(IFNULL(repp_quota, 0)) as totQuota, adresse_theatre.adr_latitude as latitude_theatre,adresse_theatre.adr_longitude as longitude_theatre, the_id,the_idStructure, sto_tickboss_eventId FROM foa_spectacle JOIN foa_spectacle_ticketoff ON (sto_idSpectacle = spe_id) JOIN foa_spectacle_lieu ON (spl_idSpectacle = spe_id) JOIN foa_lieu ON (lie_id = spl_idLieu) JOIN foa_theatre ON (lie_idTheatre = the_id) JOIN foa_compagnie c1 ON (c1.com_id = spe_idCompagnie) LEFT JOIN foa_compagnie c2 ON (c2.com_id = spe_idCompagnieReel) JOIN foa_representation ON (rep_idSpectacleLieu = spl_id AND rep_dateDelete is null) LEFT JOIN foa_structure ON (str_id = c1.com_idStructure) LEFT JOIN foa_adresse as adresse_structure ON (adresse_structure.adr_id = str_idAdresse) LEFT JOIN foa_adresse as adresse_theatre ON (adresse_theatre.adr_id = the_idAdresse) LEFT JOIN data_pays ON (adresse_structure.adr_pays = pays_iso) LEFT JOIN foa_spectacle_genre ON (spe_genre = sge_id) LEFT JOIN foa_spectacle_type ON (spe_type = stp_id) LEFT JOIN foa_paiement ON (spe_idPaiement = pai_id) LEFT JOIN foa_programme ON (spe_idFestival = prg_idFestival AND prg_valide = 1) LEFT JOIN foa_representation_params ON repp_id = rep_idRepParams LEFT JOIN foa_inscription_etape_spectacle ON (ies_idSpectacle = spe_id) WHERE spe_id = '6893' AND spe_idFestival = '5' GROUP BY spe_id

0.000 : 19 : SELECT * FROM foa_spectacle_langue

0.000 : 1 : SELECT foa_inscription_theatre.* FROM foa_inscription_structure JOIN foa_inscription_theatre ON (int_idInscriptionStructure = ins_id) WHERE ins_idFestival = '5' AND int_idTheatre = '122'

0.000 : 6 : SELECT stb_libelle AS label, stb_id AS id FROM foa_spectacle_type_tarif_beneficiaire

0.000 : 9 : SELECT spt_montant_ttc,spt_age,spt_beneficiaire, spt_idTypeTarif FROM foa_spectacle_tarif WHERE spt_idSpectacle = '6893' AND spt_dateDelete is null

0.000 : 17 : SELECT stf_id, stf_id,stf_libelle,stf_tarifAccredite,stf_libelle_catalogue,stf_code_catalogue,stf_description FROM foa_spectacle_type_tarif

0.000 : 2 : SELECT smp_mode FROM foa_spectacle_mode_paiement WHERE smp_idSpectacleLieu = '5742'

0.000 : 1 : SELECT * FROM foa_spectacle_avertissement JOIN foa_avertissement ON (spea_idAvertissement = ave_id) WHERE spea_idSpectacle = '6893'

0.000 : 19 : SELECT rep_dateDebut, rep_dateFin FROM foa_representation WHERE rep_idSpectacleLieu = '5742' AND rep_dateDelete IS NULL ORDER BY rep_dateDebut

0.000 : 10 : SELECT smp_id as id, smp_prenom as prenom, smp_nom as nom, smp_idRole as idRole, rol_libelle as role, rol_code as code, smp_ordre as ordre,smp_encart_papier as encart, rol_ordre_papier FROM foa_spectacle_equipe_artistique LEFT JOIN foa_role ON (rol_id = smp_idRole) WHERE smp_idSpectacle = '6893' ORDER BY smp_encart_papier DESC,rol_ordre_papier, smp_ordre, smp_nom, smp_prenom

0.000 : 10 : SELECT smp_id as id, smp_prenom as prenom, smp_nom as nom, smp_idRole as idRole, rol_libelle as role, rol_code as code, smp_ordre as ordre,smp_encart_papier as encart, rol_ordre_papier FROM foa_spectacle_equipe_artistique LEFT JOIN foa_role ON (rol_id = smp_idRole) WHERE smp_idSpectacle = '6893' AND smp_encart_papier = 1 ORDER BY smp_encart_papier DESC,rol_ordre_papier, smp_ordre, smp_nom, smp_prenom

0.000 : 0 : SELECT spa_id as id, spa_ordre as ordre, aut_nom as nom, aut_prenom as prenom, ap_libelle as prefixe, ap_libelle_en as prefixe_en FROM foa_spectacle_auteur LEFT JOIN foa_auteur ON (aut_id = spa_idAuteur) LEFT JOIN foa_auteur_prefixe ON (ap_id = spa_idPrefixe) WHERE spa_idSpectacle = '6893' ORDER BY spa_ordre

0.000 : 0 : SELECT sct_type_partenariat,str_nom FROM foa_spectacle_structure_tiers JOIN foa_structure ON (sct_idStructureTiers = str_id) WHERE sct_idSpectacle = '6893' ORDER BY sct_type_partenariat, str_nom

0.000 : 0 : SELECT * FROM foa_spectacle_coproduction WHERE scp_idSpectacle = '6893' order by scp_libelle

0.000 : 1 : SELECT * FROM foa_spectacle_corealisation WHERE scr_idSpectacle = '6893' order by scr_libelle

0.000 : 3 : SELECT spi_id id,spi_original_filename original_filename, spi_filename filename, spi_type_file type_file FROM foa_spectacle_image WHERE spi_idSpectacle = '6893' AND spi_dateDelete is null

0.000 : 0 : SELECT spd_id id,spd_original_filename original_filename, spd_filename filename, spd_type type FROM foa_spectacle_document WHERE spd_idSpectacle = '6893' ORDER BY spd_type

0.001 : 1 : SELECT the_id, the_nom,lie_nom, CONCAT(adresse_theatre.adr_adresse1, IF(adresse_theatre.adr_adresse2,CONCAT(', ',adresse_theatre.adr_adresse2) ,'')) as adresse, adresse_theatre.adr_codePostal,adresse_theatre.adr_ville,adresse_lieu.adr_latitude as latitude_lieu,adresse_lieu.adr_longitude as longitude_lieu, pim_value as jauge, ( SELECT pim_value FROM foa_pim LEFT JOIN foa_pim_feature ON (pim_idFeature = fea_id) WHERE fea_origine = "theatre" AND fea_solr_field = "tel_reservation_1" AND pim_idTheatre = the_id ) as tel_reservation_1, ( SELECT pim_value FROM foa_pim LEFT JOIN foa_pim_feature ON (pim_idFeature = fea_id) WHERE fea_origine = "theatre" AND fea_solr_field = "tel_reservation_2" AND pim_idTheatre = the_id ) as tel_reservation_2, ( SELECT pim_value FROM foa_pim LEFT JOIN foa_pim_feature ON (pim_idFeature = fea_id) WHERE fea_origine = "theatre" AND fea_solr_field = "tel_billetterie" AND pim_idTheatre = the_id ) as tel_billetterie, ( SELECT pim_value FROM foa_pim LEFT JOIN foa_pim_feature ON (pim_idFeature = fea_id) WHERE fea_origine = "theatre" AND fea_solr_field = "tel_billeterie_2" AND pim_idTheatre = the_id ) as tel_billeterie_2 FROM foa_theatre INNER JOIN foa_lieu ON (lie_idTheatre = the_id) INNER JOIN foa_spectacle_lieu ON (spl_idLieu = lie_id) INNER JOIN foa_adresse as adresse_theatre ON (adr_id = the_idAdresse) LEFT JOIN foa_adresse as adresse_lieu ON (adresse_lieu.adr_id = lie_idAdresse) INNER JOIN foa_pim ON (pim_idLieu = lie_id) INNER JOIN foa_pim_feature ON (fea_id = pim_idFeature) WHERE spl_idSpectacle = '6893' AND fea_libelle_front = 'Jauge'

0.000 : 13 : SELECT fea_solr_field, pim_value FROM foa_pim_feature LEFT JOIN foa_pim ON (fea_id = pim_idFeature AND pim_idCompagnie = '5905') WHERE fea_origine = 'compagnie'

0.000 : 1 : SELECT * FROM foa_compagnie_contact LEFT JOIN foa_role ON (coc_idRole = rol_id) WHERE coc_idCompagnie = '5905'

0.000 : 0 : SELECT traduction FROM i18n_seo WHERE hash = 'a68ed52dcfc63320e47f806ce6af97e5' AND lang = 'fr' AND page = 'IMPROVISION, demandez l\'programme'

0.000 : 0 : SELECT traduction FROM i18n_seo WHERE hash = 'dfbf78b3e9650f82130357f509ebc9fe' AND lang = 'fr' AND page = 'Spectacle'

0.000 : 1 : SELECT * FROM foa_spectacle_questionnaire WHERE spq_idSpectacle = '6893' AND spq_idFestival = '5'

0.000 : 1 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = 'fr') WHERE bribe_code = 'seo' AND bribe_etat = 'VAL'

0.000 : 1 : SELECT * FROM cms_bribes LEFT JOIN cms_bribes_lang ON (lbribe_id = bribe_id AND lang = 'fr') WHERE bribe_code = 'seo-home' AND bribe_etat = 'VAL'

0.001 : 75 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone FROM menus m LEFT JOIN menus_details md ON (md.id_menu = m.id_menu) LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr') WHERE m.code = 'navigation' AND md.actif = 1 ORDER BY ordre_rubrique ASC

0.001 : 95 : SELECT * FROM cms

0.001 : 13 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone FROM menus m LEFT JOIN menus_details md ON (md.id_menu = m.id_menu) LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr') WHERE m.code = 'footer' AND md.actif = 1 ORDER BY ordre_rubrique ASC

0.001 : 4 : SELECT md.id_menu_detail ,md.id_parent ,md.url_type, md.url_data, mdl.lnom_rubrique, md.nom_rubrique, md.class, md.onclick, md.target, md.icone FROM menus m LEFT JOIN menus_details md ON (md.id_menu = m.id_menu) LEFT JOIN menus_details_lang mdl ON (mdl.lid_menu_detail=md.id_menu_detail AND mdl.lang='fr') WHERE m.code = 'acces' AND md.actif = 1 ORDER BY ordre_rubrique ASC

0.001 : 9 : SELECT * FROM rgpd_cookies LEFT JOIN rgpd_cookies_lang lrgpdc ON (rgpdc_code = lrgpdc.lrgpdc_code AND lrgpdc.lang = 'fr') LEFT JOIN rgpd_cookies_details ON (rgpdc_code = rcd_lrgpdc_code) LEFT JOIN rgpd_cookies_details_lang lrcd ON (rcd_id = lrcd.lrcd_id AND lrcd.lang = 'fr') WHERE rgpdc_active = 1 ORDER BY rgpdc_code ASC

0.000 : 1 : SELECT * FROM rgpd_cookies_parametres LEFT JOIN rgpd_cookies_parametres_lang ON (lrcp_id = rcp_id AND lang = 'fr')

0.000 : 1 : SELECT * FROM tracking_analytics WHERE trk_actif = 1