1
3.13 ms
SELECT d0_ . slug AS slug_0 , d0_ . libelle AS libelle_1 , d0_ . onglets AS onglets_2 , d0_ . id AS id_3 , d0_ . maj AS maj_4 , d1_ . latitude AS latitude_5 , d1_ . longitude AS longitude_6 , d1_ . id AS id_7 , d0_ . ancienne_region_id AS ancienne_region_id_8 , d0_ . region_id AS region_id_9 , d1_ . departement_id AS departement_id_10 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_ . id = d1_ . departement_id
SELECT d0_ . slug AS slug_0 , d0_ . libelle AS libelle_1 , d0_ . onglets AS onglets_2 , d0_ . id AS id_3 , d0_ . maj AS maj_4 , d1_ . latitude AS latitude_5 , d1_ . longitude AS longitude_6 , d1_ . id AS id_7 , d0_ . ancienne_region_id AS ancienne_region_id_8 , d0_ . region_id AS region_id_9 , d1_ . departement_id AS departement_id_10 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_ . id = d1_ . departement_id ;
Copy
2
14.00 ms
SELECT e0_ . type AS type_0 , e0_ . nombre_eleves AS nombre_eleves_1 , e0_ . url AS url_2 , e0_ . video AS video_3 , e0_ . mots_cles AS mots_cles_4 , e0_ . denomination AS denomination_5 , e0_ . denomination_sigle AS denomination_sigle_6 , e0_ . denomination_extension AS denomination_extension_7 , e0_ . denomination_abregee AS denomination_abregee_8 , e0_ . droit_page_web AS droit_page_web_9 , e0_ . droit_actualite AS droit_actualite_10 , e0_ . adresse1 AS adresse1_11 , e0_ . adresse2 AS adresse2_12 , e0_ . adresse3 AS adresse3_13 , e0_ . code_postal AS code_postal_14 , e0_ . cedex AS cedex_15 , e0_ . latitude AS latitude_16 , e0_ . longitude AS longitude_17 , e0_ . telephone_principal AS telephone_principal_18 , e0_ . fax AS fax_19 , e0_ . email_principal AS email_principal_20 , e0_ . logo_liste AS logo_liste_21 , e0_ . logo_fiche AS logo_fiche_22 , e0_ . diaporama_actif AS diaporama_actif_23 , e0_ . images_diaporama AS images_diaporama_24 , e0_ . participant AS participant_25 , e0_ . catholique AS catholique_26 , e0_ . age_admission AS age_admission_27 , e0_ . actif AS actif_28 , e0_ . internat AS internat_29 , e0_ . has_internat AS has_internat_30 , e0_ . types_internat AS types_internat_31 , e0_ . sous_contrat AS sous_contrat_32 , e0_ . alternance AS alternance_33 , e0_ . type_client AS type_client_34 , e0_ . bloque_txt_ref AS bloque_txt_ref_35 , e0_ . facebook AS facebook_36 , e0_ . bloque_bac2021 AS bloque_bac2021_37 , e0_ . presence_web AS presence_web_38 , e0_ . video_plus AS video_plus_39 , e0_ . diapo_plus AS diapo_plus_40 , e0_ . jpo_plus AS jpo_plus_41 , e0_ . doc_plus AS doc_plus_42 , e0_ . diplome_plus AS diplome_plus_43 , e0_ . refus AS refus_44 , e0_ . path AS path_45 , e0_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_46 , e0_ . lva AS lva_47 , e0_ . lvb AS lvb_48 , e0_ . numero_administratif_uai AS numero_administratif_uai_49 , e0_ . siret AS siret_50 , e0_ . chiffres AS chiffres_51 , e0_ . id AS id_52 , e0_ . maj AS maj_53 , v1_ . slug AS slug_54 , v1_ . libelle AS libelle_55 , v1_ . code_postal AS code_postal_56 , v1_ . email_delegue AS email_delegue_57 , v1_ . onglets AS onglets_58 , v1_ . id AS id_59 , v1_ . maj AS maj_60 , v2_ . latitude AS latitude_61 , v2_ . longitude AS longitude_62 , v2_ . id AS id_63 , d3_ . slug AS slug_64 , d3_ . libelle AS libelle_65 , d3_ . onglets AS onglets_66 , d3_ . id AS id_67 , d3_ . maj AS maj_68 , d4_ . latitude AS latitude_69 , d4_ . longitude AS longitude_70 , d4_ . id AS id_71 , a5_ . slug AS slug_72 , a5_ . libelle AS libelle_73 , a5_ . id AS id_74 , a5_ . maj AS maj_75 , r6_ . libelle AS libelle_76 , r6_ . slug AS slug_77 , r6_ . region_adm AS region_adm_78 , r6_ . ancienne AS ancienne_79 , r6_ . onglets AS onglets_80 , r6_ . id AS id_81 , r6_ . maj AS maj_82 , p7_ . libelle AS libelle_83 , p7_ . id AS id_84 , p7_ . maj AS maj_85 , c8_ . libelle AS libelle_86 , c8_ . id AS id_87 , c8_ . maj AS maj_88 , t9_ . actif AS actif_89 , t9_ . contenu AS contenu_90 , t9_ . id AS id_91 , d10_ . id AS id_92 , d10_ . titre AS titre_93 , d10_ . texte AS texte_94 , d10_ . actif AS actif_95 , d10_ . position AS position_96 , d10_ . principal AS principal_97 , d10_ . date_crea AS date_crea_98 , d10_ . date_maj AS date_maj_99 , d11_ . id AS id_100 , d11_ . titre AS titre_101 , d11_ . legende AS legende_102 , d11_ . actif AS actif_103 , d11_ . position AS position_104 , d11_ . file_name AS file_name_105 , d11_ . file_size AS file_size_106 , d11_ . updated_at AS updated_at_107 , d11_ . file_name_source AS file_name_source_108 , d11_ . file_size_source AS file_size_source_109 , v12_ . id AS id_110 , v12_ . titre AS titre_111 , v12_ . url AS url_112 , v12_ . actif AS actif_113 , v12_ . position AS position_114 , v12_ . texte AS texte_115 , v12_ . file_name AS file_name_116 , v12_ . file_size AS file_size_117 , v12_ . updated_at AS updated_at_118 , v12_ . file_name_source AS file_name_source_119 , v12_ . file_size_source AS file_size_source_120 , v12_ . date_crea AS date_crea_121 , v12_ . date_maj AS date_maj_122 , l13_ . id AS id_123 , l13_ . file_name AS file_name_124 , l13_ . file_size AS file_size_125 , l13_ . updated_at AS updated_at_126 , l13_ . file_name_source AS file_name_source_127 , l13_ . file_size_source AS file_size_source_128 , l13_ . date_crea AS date_crea_129 , l13_ . date_maj AS date_maj_130 , e0_ . gestionnaire_id AS gestionnaire_id_131 , e0_ . ville_id AS ville_id_132 , e0_ . categorie_primaire_id AS categorie_primaire_id_133 , e0_ . region_id AS region_id_134 , e0_ . departement_id AS departement_id_135 , e0_ . categorie_organisme_id AS categorie_organisme_id_136 , e0_ . rubrique AS rubrique_137 , e0_ . internat2_id AS internat2_id_138 , e0_ . etablissement_lie_id AS etablissement_lie_id_139 , e0_ . logo_id AS logo_id_140 , e0_ . diapo_principal_id AS diapo_principal_id_141 , v1_ . departement_id AS departement_id_142 , v2_ . ville_id AS ville_id_143 , d3_ . ancienne_region_id AS ancienne_region_id_144 , d3_ . region_id AS region_id_145 , d4_ . departement_id AS departement_id_146 , a5_ . region_id AS region_id_147 , r6_ . pays_id AS pays_id_148 , t9_ . etablissement_id AS etablissement_id_149 , t9_ . template_id AS template_id_150 , d11_ . diaporama_id AS diaporama_id_151 FROM etablissement e0_ LEFT JOIN ville v1_ ON e0_ . ville_id = v1_ . id LEFT JOIN ville_coordonnees v2_ ON v1_ . id = v2_ . ville_id LEFT JOIN departement d3_ ON v1_ . departement_id = d3_ . id LEFT JOIN departement_coordonnees d4_ ON d3_ . id = d4_ . departement_id LEFT JOIN ancienne_region a5_ ON d3_ . ancienne_region_id = a5_ . id LEFT JOIN region r6_ ON a5_ . region_id = r6_ . id LEFT JOIN pays p7_ ON r6_ . pays_id = p7_ . id LEFT JOIN categorie c8_ ON e0_ . categorie_primaire_id = c8_ . id LEFT JOIN texte_referencement t9_ ON e0_ . id = t9_ . etablissement_id LEFT JOIN diaporama_etablissement d14_ ON e0_ . id = d14_ . etablissement_id LEFT JOIN diaporama d10_ ON d10_ . id = d14_ . diaporama_id LEFT JOIN diaporama_photo d11_ ON d10_ . id = d11_ . diaporama_id LEFT JOIN video_etablissement v15_ ON e0_ . id = v15_ . etablissement_id LEFT JOIN video v12_ ON v12_ . id = v15_ . video_id LEFT JOIN logo l13_ ON e0_ . logo_id = l13_ . id WHERE e0_ . id IN (? ) ORDER BY d11_ . position ASC
Parameters :
[
[
"ET013-500 "
"ET013-281 "
"ET013-174 "
"ET013-201 "
"ET013-199 "
"ET013-414 "
"ET013-217 "
"ET013-49 "
"ET013-416 "
"ET013-405 "
"ET013-158 "
"ET013-9 "
"ET013-129 "
"ET013-424 "
"ET013-212 "
"ET013-51 "
"ET013-160 "
"ET013-453 "
"ET013-130 "
"ET013-288 "
"ET013-157 "
"ET013-213 "
"ET013-499 "
"ET013-40 "
"ET013-169 "
"ET013-163 "
"ET013-80 "
"ET013-69 "
"ET013-20 "
"ET013-256 "
"ET013-222 "
"IN013-98 "
"ET013-52 "
"ET013-34 "
"ET013-284 "
"ET013-134 "
"IN013-293 "
"ET013-127 "
"ET013-501 "
"ET013-154 "
"ET013-61 "
"ET013-264 "
"ET013-289 "
"ET013-247 "
"ET013-48 "
"ET013-118 "
"ET013-7 "
"ET013-98 "
"IN013-294 "
"ET013-450 "
"ET013-47 "
"ET013-85 "
"ET013-94 "
"ET013-72 "
"ET013-253 "
"ET013-4 "
"ET013-65 "
"ET013-152 "
"ET013-54 "
"ET013-478 "
]
]
SELECT
e0_ . type AS type_0 ,
e0_ . nombre_eleves AS nombre_eleves_1 ,
e0_ . url AS url_2 ,
e0_ . video AS video_3 ,
e0_ . mots_cles AS mots_cles_4 ,
e0_ . denomination AS denomination_5 ,
e0_ . denomination_sigle AS denomination_sigle_6 ,
e0_ . denomination_extension AS denomination_extension_7 ,
e0_ . denomination_abregee AS denomination_abregee_8 ,
e0_ . droit_page_web AS droit_page_web_9 ,
e0_ . droit_actualite AS droit_actualite_10 ,
e0_ . adresse1 AS adresse1_11 ,
e0_ . adresse2 AS adresse2_12 ,
e0_ . adresse3 AS adresse3_13 ,
e0_ . code_postal AS code_postal_14 ,
e0_ . cedex AS cedex_15 ,
e0_ . latitude AS latitude_16 ,
e0_ . longitude AS longitude_17 ,
e0_ . telephone_principal AS telephone_principal_18 ,
e0_ . fax AS fax_19 ,
e0_ . email_principal AS email_principal_20 ,
e0_ . logo_liste AS logo_liste_21 ,
e0_ . logo_fiche AS logo_fiche_22 ,
e0_ . diaporama_actif AS diaporama_actif_23 ,
e0_ . images_diaporama AS images_diaporama_24 ,
e0_ . participant AS participant_25 ,
e0_ . catholique AS catholique_26 ,
e0_ . age_admission AS age_admission_27 ,
e0_ . actif AS actif_28 ,
e0_ . internat AS internat_29 ,
e0_ . has_internat AS has_internat_30 ,
e0_ . types_internat AS types_internat_31 ,
e0_ . sous_contrat AS sous_contrat_32 ,
e0_ . alternance AS alternance_33 ,
e0_ . type_client AS type_client_34 ,
e0_ . bloque_txt_ref AS bloque_txt_ref_35 ,
e0_ . facebook AS facebook_36 ,
e0_ . bloque_bac2021 AS bloque_bac2021_37 ,
e0_ . presence_web AS presence_web_38 ,
e0_ . video_plus AS video_plus_39 ,
e0_ . diapo_plus AS diapo_plus_40 ,
e0_ . jpo_plus AS jpo_plus_41 ,
e0_ . doc_plus AS doc_plus_42 ,
e0_ . diplome_plus AS diplome_plus_43 ,
e0_ . refus AS refus_44 ,
e0_ . path AS path_45 ,
e0_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_46 ,
e0_ . lva AS lva_47 ,
e0_ . lvb AS lvb_48 ,
e0_ . numero_administratif_uai AS numero_administratif_uai_49 ,
e0_ . siret AS siret_50 ,
e0_ . chiffres AS chiffres_51 ,
e0_ . id AS id_52 ,
e0_ . maj AS maj_53 ,
v1_ . slug AS slug_54 ,
v1_ . libelle AS libelle_55 ,
v1_ . code_postal AS code_postal_56 ,
v1_ . email_delegue AS email_delegue_57 ,
v1_ . onglets AS onglets_58 ,
v1_ . id AS id_59 ,
v1_ . maj AS maj_60 ,
v2_ . latitude AS latitude_61 ,
v2_ . longitude AS longitude_62 ,
v2_ . id AS id_63 ,
d3_ . slug AS slug_64 ,
d3_ . libelle AS libelle_65 ,
d3_ . onglets AS onglets_66 ,
d3_ . id AS id_67 ,
d3_ . maj AS maj_68 ,
d4_ . latitude AS latitude_69 ,
d4_ . longitude AS longitude_70 ,
d4_ . id AS id_71 ,
a5_ . slug AS slug_72 ,
a5_ . libelle AS libelle_73 ,
a5_ . id AS id_74 ,
a5_ . maj AS maj_75 ,
r6_ . libelle AS libelle_76 ,
r6_ . slug AS slug_77 ,
r6_ . region_adm AS region_adm_78 ,
r6_ . ancienne AS ancienne_79 ,
r6_ . onglets AS onglets_80 ,
r6_ . id AS id_81 ,
r6_ . maj AS maj_82 ,
p7_ . libelle AS libelle_83 ,
p7_ . id AS id_84 ,
p7_ . maj AS maj_85 ,
c8_ . libelle AS libelle_86 ,
c8_ . id AS id_87 ,
c8_ . maj AS maj_88 ,
t9_ . actif AS actif_89 ,
t9_ . contenu AS contenu_90 ,
t9_ . id AS id_91 ,
d10_ . id AS id_92 ,
d10_ . titre AS titre_93 ,
d10_ . texte AS texte_94 ,
d10_ . actif AS actif_95 ,
d10_ . position AS position_96 ,
d10_ . principal AS principal_97 ,
d10_ . date_crea AS date_crea_98 ,
d10_ . date_maj AS date_maj_99 ,
d11_ . id AS id_100 ,
d11_ . titre AS titre_101 ,
d11_ . legende AS legende_102 ,
d11_ . actif AS actif_103 ,
d11_ . position AS position_104 ,
d11_ . file_name AS file_name_105 ,
d11_ . file_size AS file_size_106 ,
d11_ . updated_at AS updated_at_107 ,
d11_ . file_name_source AS file_name_source_108 ,
d11_ . file_size_source AS file_size_source_109 ,
v12_ . id AS id_110 ,
v12_ . titre AS titre_111 ,
v12_ . url AS url_112 ,
v12_ . actif AS actif_113 ,
v12_ . position AS position_114 ,
v12_ . texte AS texte_115 ,
v12_ . file_name AS file_name_116 ,
v12_ . file_size AS file_size_117 ,
v12_ . updated_at AS updated_at_118 ,
v12_ . file_name_source AS file_name_source_119 ,
v12_ . file_size_source AS file_size_source_120 ,
v12_ . date_crea AS date_crea_121 ,
v12_ . date_maj AS date_maj_122 ,
l13_ . id AS id_123 ,
l13_ . file_name AS file_name_124 ,
l13_ . file_size AS file_size_125 ,
l13_ . updated_at AS updated_at_126 ,
l13_ . file_name_source AS file_name_source_127 ,
l13_ . file_size_source AS file_size_source_128 ,
l13_ . date_crea AS date_crea_129 ,
l13_ . date_maj AS date_maj_130 ,
e0_ . gestionnaire_id AS gestionnaire_id_131 ,
e0_ . ville_id AS ville_id_132 ,
e0_ . categorie_primaire_id AS categorie_primaire_id_133 ,
e0_ . region_id AS region_id_134 ,
e0_ . departement_id AS departement_id_135 ,
e0_ . categorie_organisme_id AS categorie_organisme_id_136 ,
e0_ . rubrique AS rubrique_137 ,
e0_ . internat2_id AS internat2_id_138 ,
e0_ . etablissement_lie_id AS etablissement_lie_id_139 ,
e0_ . logo_id AS logo_id_140 ,
e0_ . diapo_principal_id AS diapo_principal_id_141 ,
v1_ . departement_id AS departement_id_142 ,
v2_ . ville_id AS ville_id_143 ,
d3_ . ancienne_region_id AS ancienne_region_id_144 ,
d3_ . region_id AS region_id_145 ,
d4_ . departement_id AS departement_id_146 ,
a5_ . region_id AS region_id_147 ,
r6_ . pays_id AS pays_id_148 ,
t9_ . etablissement_id AS etablissement_id_149 ,
t9_ . template_id AS template_id_150 ,
d11_ . diaporama_id AS diaporama_id_151
FROM
etablissement e0_
LEFT JOIN ville v1_ ON e0_ . ville_id = v1_ . id
LEFT JOIN ville_coordonnees v2_ ON v1_ . id = v2_ . ville_id
LEFT JOIN departement d3_ ON v1_ . departement_id = d3_ . id
LEFT JOIN departement_coordonnees d4_ ON d3_ . id = d4_ . departement_id
LEFT JOIN ancienne_region a5_ ON d3_ . ancienne_region_id = a5_ . id
LEFT JOIN region r6_ ON a5_ . region_id = r6_ . id
LEFT JOIN pays p7_ ON r6_ . pays_id = p7_ . id
LEFT JOIN categorie c8_ ON e0_ . categorie_primaire_id = c8_ . id
LEFT JOIN texte_referencement t9_ ON e0_ . id = t9_ . etablissement_id
LEFT JOIN diaporama_etablissement d14_ ON e0_ . id = d14_ . etablissement_id
LEFT JOIN diaporama d10_ ON d10_ . id = d14_ . diaporama_id
LEFT JOIN diaporama_photo d11_ ON d10_ . id = d11_ . diaporama_id
LEFT JOIN video_etablissement v15_ ON e0_ . id = v15_ . etablissement_id
LEFT JOIN video v12_ ON v12_ . id = v15_ . video_id
LEFT JOIN logo l13_ ON e0_ . logo_id = l13_ . id
WHERE
e0_ . id IN (? )
ORDER BY
d11_ . position ASC
Copy
SELECT e0_ . type AS type_0 , e0_ . nombre_eleves AS nombre_eleves_1 , e0_ . url AS url_2 , e0_ . video AS video_3 , e0_ . mots_cles AS mots_cles_4 , e0_ . denomination AS denomination_5 , e0_ . denomination_sigle AS denomination_sigle_6 , e0_ . denomination_extension AS denomination_extension_7 , e0_ . denomination_abregee AS denomination_abregee_8 , e0_ . droit_page_web AS droit_page_web_9 , e0_ . droit_actualite AS droit_actualite_10 , e0_ . adresse1 AS adresse1_11 , e0_ . adresse2 AS adresse2_12 , e0_ . adresse3 AS adresse3_13 , e0_ . code_postal AS code_postal_14 , e0_ . cedex AS cedex_15 , e0_ . latitude AS latitude_16 , e0_ . longitude AS longitude_17 , e0_ . telephone_principal AS telephone_principal_18 , e0_ . fax AS fax_19 , e0_ . email_principal AS email_principal_20 , e0_ . logo_liste AS logo_liste_21 , e0_ . logo_fiche AS logo_fiche_22 , e0_ . diaporama_actif AS diaporama_actif_23 , e0_ . images_diaporama AS images_diaporama_24 , e0_ . participant AS participant_25 , e0_ . catholique AS catholique_26 , e0_ . age_admission AS age_admission_27 , e0_ . actif AS actif_28 , e0_ . internat AS internat_29 , e0_ . has_internat AS has_internat_30 , e0_ . types_internat AS types_internat_31 , e0_ . sous_contrat AS sous_contrat_32 , e0_ . alternance AS alternance_33 , e0_ . type_client AS type_client_34 , e0_ . bloque_txt_ref AS bloque_txt_ref_35 , e0_ . facebook AS facebook_36 , e0_ . bloque_bac2021 AS bloque_bac2021_37 , e0_ . presence_web AS presence_web_38 , e0_ . video_plus AS video_plus_39 , e0_ . diapo_plus AS diapo_plus_40 , e0_ . jpo_plus AS jpo_plus_41 , e0_ . doc_plus AS doc_plus_42 , e0_ . diplome_plus AS diplome_plus_43 , e0_ . refus AS refus_44 , e0_ . path AS path_45 , e0_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_46 , e0_ . lva AS lva_47 , e0_ . lvb AS lvb_48 , e0_ . numero_administratif_uai AS numero_administratif_uai_49 , e0_ . siret AS siret_50 , e0_ . chiffres AS chiffres_51 , e0_ . id AS id_52 , e0_ . maj AS maj_53 , v1_ . slug AS slug_54 , v1_ . libelle AS libelle_55 , v1_ . code_postal AS code_postal_56 , v1_ . email_delegue AS email_delegue_57 , v1_ . onglets AS onglets_58 , v1_ . id AS id_59 , v1_ . maj AS maj_60 , v2_ . latitude AS latitude_61 , v2_ . longitude AS longitude_62 , v2_ . id AS id_63 , d3_ . slug AS slug_64 , d3_ . libelle AS libelle_65 , d3_ . onglets AS onglets_66 , d3_ . id AS id_67 , d3_ . maj AS maj_68 , d4_ . latitude AS latitude_69 , d4_ . longitude AS longitude_70 , d4_ . id AS id_71 , a5_ . slug AS slug_72 , a5_ . libelle AS libelle_73 , a5_ . id AS id_74 , a5_ . maj AS maj_75 , r6_ . libelle AS libelle_76 , r6_ . slug AS slug_77 , r6_ . region_adm AS region_adm_78 , r6_ . ancienne AS ancienne_79 , r6_ . onglets AS onglets_80 , r6_ . id AS id_81 , r6_ . maj AS maj_82 , p7_ . libelle AS libelle_83 , p7_ . id AS id_84 , p7_ . maj AS maj_85 , c8_ . libelle AS libelle_86 , c8_ . id AS id_87 , c8_ . maj AS maj_88 , t9_ . actif AS actif_89 , t9_ . contenu AS contenu_90 , t9_ . id AS id_91 , d10_ . id AS id_92 , d10_ . titre AS titre_93 , d10_ . texte AS texte_94 , d10_ . actif AS actif_95 , d10_ . position AS position_96 , d10_ . principal AS principal_97 , d10_ . date_crea AS date_crea_98 , d10_ . date_maj AS date_maj_99 , d11_ . id AS id_100 , d11_ . titre AS titre_101 , d11_ . legende AS legende_102 , d11_ . actif AS actif_103 , d11_ . position AS position_104 , d11_ . file_name AS file_name_105 , d11_ . file_size AS file_size_106 , d11_ . updated_at AS updated_at_107 , d11_ . file_name_source AS file_name_source_108 , d11_ . file_size_source AS file_size_source_109 , v12_ . id AS id_110 , v12_ . titre AS titre_111 , v12_ . url AS url_112 , v12_ . actif AS actif_113 , v12_ . position AS position_114 , v12_ . texte AS texte_115 , v12_ . file_name AS file_name_116 , v12_ . file_size AS file_size_117 , v12_ . updated_at AS updated_at_118 , v12_ . file_name_source AS file_name_source_119 , v12_ . file_size_source AS file_size_source_120 , v12_ . date_crea AS date_crea_121 , v12_ . date_maj AS date_maj_122 , l13_ . id AS id_123 , l13_ . file_name AS file_name_124 , l13_ . file_size AS file_size_125 , l13_ . updated_at AS updated_at_126 , l13_ . file_name_source AS file_name_source_127 , l13_ . file_size_source AS file_size_source_128 , l13_ . date_crea AS date_crea_129 , l13_ . date_maj AS date_maj_130 , e0_ . gestionnaire_id AS gestionnaire_id_131 , e0_ . ville_id AS ville_id_132 , e0_ . categorie_primaire_id AS categorie_primaire_id_133 , e0_ . region_id AS region_id_134 , e0_ . departement_id AS departement_id_135 , e0_ . categorie_organisme_id AS categorie_organisme_id_136 , e0_ . rubrique AS rubrique_137 , e0_ . internat2_id AS internat2_id_138 , e0_ . etablissement_lie_id AS etablissement_lie_id_139 , e0_ . logo_id AS logo_id_140 , e0_ . diapo_principal_id AS diapo_principal_id_141 , v1_ . departement_id AS departement_id_142 , v2_ . ville_id AS ville_id_143 , d3_ . ancienne_region_id AS ancienne_region_id_144 , d3_ . region_id AS region_id_145 , d4_ . departement_id AS departement_id_146 , a5_ . region_id AS region_id_147 , r6_ . pays_id AS pays_id_148 , t9_ . etablissement_id AS etablissement_id_149 , t9_ . template_id AS template_id_150 , d11_ . diaporama_id AS diaporama_id_151 FROM etablissement e0_ LEFT JOIN ville v1_ ON e0_ . ville_id = v1_ . id LEFT JOIN ville_coordonnees v2_ ON v1_ . id = v2_ . ville_id LEFT JOIN departement d3_ ON v1_ . departement_id = d3_ . id LEFT JOIN departement_coordonnees d4_ ON d3_ . id = d4_ . departement_id LEFT JOIN ancienne_region a5_ ON d3_ . ancienne_region_id = a5_ . id LEFT JOIN region r6_ ON a5_ . region_id = r6_ . id LEFT JOIN pays p7_ ON r6_ . pays_id = p7_ . id LEFT JOIN categorie c8_ ON e0_ . categorie_primaire_id = c8_ . id LEFT JOIN texte_referencement t9_ ON e0_ . id = t9_ . etablissement_id LEFT JOIN diaporama_etablissement d14_ ON e0_ . id = d14_ . etablissement_id LEFT JOIN diaporama d10_ ON d10_ . id = d14_ . diaporama_id LEFT JOIN diaporama_photo d11_ ON d10_ . id = d11_ . diaporama_id LEFT JOIN video_etablissement v15_ ON e0_ . id = v15_ . etablissement_id LEFT JOIN video v12_ ON v12_ . id = v15_ . video_id LEFT JOIN logo l13_ ON e0_ . logo_id = l13_ . id WHERE e0_ . id IN ('ET013-500' , 'ET013-281' , 'ET013-174' , 'ET013-201' , 'ET013-199' , 'ET013-414' , 'ET013-217' , 'ET013-49' , 'ET013-416' , 'ET013-405' , 'ET013-158' , 'ET013-9' , 'ET013-129' , 'ET013-424' , 'ET013-212' , 'ET013-51' , 'ET013-160' , 'ET013-453' , 'ET013-130' , 'ET013-288' , 'ET013-157' , 'ET013-213' , 'ET013-499' , 'ET013-40' , 'ET013-169' , 'ET013-163' , 'ET013-80' , 'ET013-69' , 'ET013-20' , 'ET013-256' , 'ET013-222' , 'IN013-98' , 'ET013-52' , 'ET013-34' , 'ET013-284' , 'ET013-134' , 'IN013-293' , 'ET013-127' , 'ET013-501' , 'ET013-154' , 'ET013-61' , 'ET013-264' , 'ET013-289' , 'ET013-247' , 'ET013-48' , 'ET013-118' , 'ET013-7' , 'ET013-98' , 'IN013-294' , 'ET013-450' , 'ET013-47' , 'ET013-85' , 'ET013-94' , 'ET013-72' , 'ET013-253' , 'ET013-4' , 'ET013-65' , 'ET013-152' , 'ET013-54' , 'ET013-478' ) ORDER BY d11_ . position ASC ;
Copy
3
3.16 ms
SELECT t0 . type AS type_1 , t0 . nombre_eleves AS nombre_eleves_2 , t0 . url AS url_3 , t0 . video AS video_4 , t0 . mots_cles AS mots_cles_5 , t0 . denomination AS denomination_6 , t0 . denomination_sigle AS denomination_sigle_7 , t0 . denomination_extension AS denomination_extension_8 , t0 . denomination_abregee AS denomination_abregee_9 , t0 . droit_page_web AS droit_page_web_10 , t0 . droit_actualite AS droit_actualite_11 , t0 . adresse1 AS adresse1_12 , t0 . adresse2 AS adresse2_13 , t0 . adresse3 AS adresse3_14 , t0 . code_postal AS code_postal_15 , t0 . cedex AS cedex_16 , t0 . latitude AS latitude_17 , t0 . longitude AS longitude_18 , t0 . telephone_principal AS telephone_principal_19 , t0 . fax AS fax_20 , t0 . email_principal AS email_principal_21 , t0 . logo_liste AS logo_liste_22 , t0 . logo_fiche AS logo_fiche_23 , t0 . diaporama_actif AS diaporama_actif_24 , t0 . images_diaporama AS images_diaporama_25 , t0 . participant AS participant_26 , t0 . catholique AS catholique_27 , t0 . age_admission AS age_admission_28 , t0 . actif AS actif_29 , t0 . internat AS internat_30 , t0 . has_internat AS has_internat_31 , t0 . types_internat AS types_internat_32 , t0 . sous_contrat AS sous_contrat_33 , t0 . alternance AS alternance_34 , t0 . type_client AS type_client_35 , t0 . bloque_txt_ref AS bloque_txt_ref_36 , t0 . facebook AS facebook_37 , t0 . bloque_bac2021 AS bloque_bac2021_38 , t0 . presence_web AS presence_web_39 , t0 . video_plus AS video_plus_40 , t0 . diapo_plus AS diapo_plus_41 , t0 . jpo_plus AS jpo_plus_42 , t0 . doc_plus AS doc_plus_43 , t0 . diplome_plus AS diplome_plus_44 , t0 . refus AS refus_45 , t0 . path AS path_46 , t0 . composition_ensemble_scolaire AS composition_ensemble_scolaire_47 , t0 . lva AS lva_48 , t0 . lvb AS lvb_49 , t0 . numero_administratif_uai AS numero_administratif_uai_50 , t0 . siret AS siret_51 , t0 . chiffres AS chiffres_52 , t0 . id AS id_53 , t0 . maj AS maj_54 , t0 . gestionnaire_id AS gestionnaire_id_55 , t56 . type AS type_57 , t56 . nombre_eleves AS nombre_eleves_58 , t56 . url AS url_59 , t56 . video AS video_60 , t56 . mots_cles AS mots_cles_61 , t56 . denomination AS denomination_62 , t56 . denomination_sigle AS denomination_sigle_63 , t56 . denomination_extension AS denomination_extension_64 , t56 . denomination_abregee AS denomination_abregee_65 , t56 . droit_page_web AS droit_page_web_66 , t56 . droit_actualite AS droit_actualite_67 , t56 . adresse1 AS adresse1_68 , t56 . adresse2 AS adresse2_69 , t56 . adresse3 AS adresse3_70 , t56 . code_postal AS code_postal_71 , t56 . cedex AS cedex_72 , t56 . latitude AS latitude_73 , t56 . longitude AS longitude_74 , t56 . telephone_principal AS telephone_principal_75 , t56 . fax AS fax_76 , t56 . email_principal AS email_principal_77 , t56 . logo_liste AS logo_liste_78 , t56 . logo_fiche AS logo_fiche_79 , t56 . diaporama_actif AS diaporama_actif_80 , t56 . images_diaporama AS images_diaporama_81 , t56 . participant AS participant_82 , t56 . catholique AS catholique_83 , t56 . age_admission AS age_admission_84 , t56 . actif AS actif_85 , t56 . internat AS internat_86 , t56 . has_internat AS has_internat_87 , t56 . types_internat AS types_internat_88 , t56 . sous_contrat AS sous_contrat_89 , t56 . alternance AS alternance_90 , t56 . type_client AS type_client_91 , t56 . bloque_txt_ref AS bloque_txt_ref_92 , t56 . facebook AS facebook_93 , t56 . bloque_bac2021 AS bloque_bac2021_94 , t56 . presence_web AS presence_web_95 , t56 . video_plus AS video_plus_96 , t56 . diapo_plus AS diapo_plus_97 , t56 . jpo_plus AS jpo_plus_98 , t56 . doc_plus AS doc_plus_99 , t56 . diplome_plus AS diplome_plus_100 , t56 . refus AS refus_101 , t56 . path AS path_102 , t56 . composition_ensemble_scolaire AS composition_ensemble_scolaire_103 , t56 . lva AS lva_104 , t56 . lvb AS lvb_105 , t56 . numero_administratif_uai AS numero_administratif_uai_106 , t56 . siret AS siret_107 , t56 . chiffres AS chiffres_108 , t56 . id AS id_109 , t56 . maj AS maj_110 , t56 . gestionnaire_id AS gestionnaire_id_111 , t56 . ville_id AS ville_id_112 , t56 . categorie_primaire_id AS categorie_primaire_id_113 , t56 . region_id AS region_id_114 , t56 . departement_id AS departement_id_115 , t56 . categorie_organisme_id AS categorie_organisme_id_116 , t56 . rubrique AS rubrique_117 , t56 . internat2_id AS internat2_id_118 , t56 . etablissement_lie_id AS etablissement_lie_id_119 , t56 . logo_id AS logo_id_120 , t56 . diapo_principal_id AS diapo_principal_id_121 , t0 . ville_id AS ville_id_122 , t123 . actif AS actif_124 , t123 . contenu AS contenu_125 , t123 . id AS id_126 , t123 . etablissement_id AS etablissement_id_127 , t123 . template_id AS template_id_128 , t0 . categorie_primaire_id AS categorie_primaire_id_129 , t0 . region_id AS region_id_130 , t0 . departement_id AS departement_id_131 , t0 . categorie_organisme_id AS categorie_organisme_id_132 , t0 . rubrique AS rubrique_133 , t0 . internat2_id AS internat2_id_134 , t0 . etablissement_lie_id AS etablissement_lie_id_135 , t0 . logo_id AS logo_id_136 , t0 . diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0 . gestionnaire_id = t56 . id LEFT JOIN texte_referencement t123 ON t123 . etablissement_id = t0 . id WHERE t0 . id IN (? )
Parameters :
[
[
"GE013-75 "
"GE013-30 "
"GE013-34 "
"GE013-27 "
"GE013-35 "
"GE013-36 "
"GE013-57 "
"GE013-24 "
"GE013-18 "
"GE013-56 "
"GE013-25 "
"GE013-13 "
"GE013-94 "
"GE013-97 "
"GE013-3 "
"GE013-1 "
"GE013-86 "
"GE013-9 "
"GE013-78 "
"GE013-31 "
"GE013-83 "
]
]
SELECT
t0 . type AS type_1 ,
t0 . nombre_eleves AS nombre_eleves_2 ,
t0 . url AS url_3 ,
t0 . video AS video_4 ,
t0 . mots_cles AS mots_cles_5 ,
t0 . denomination AS denomination_6 ,
t0 . denomination_sigle AS denomination_sigle_7 ,
t0 . denomination_extension AS denomination_extension_8 ,
t0 . denomination_abregee AS denomination_abregee_9 ,
t0 . droit_page_web AS droit_page_web_10 ,
t0 . droit_actualite AS droit_actualite_11 ,
t0 . adresse1 AS adresse1_12 ,
t0 . adresse2 AS adresse2_13 ,
t0 . adresse3 AS adresse3_14 ,
t0 . code_postal AS code_postal_15 ,
t0 . cedex AS cedex_16 ,
t0 . latitude AS latitude_17 ,
t0 . longitude AS longitude_18 ,
t0 . telephone_principal AS telephone_principal_19 ,
t0 . fax AS fax_20 ,
t0 . email_principal AS email_principal_21 ,
t0 . logo_liste AS logo_liste_22 ,
t0 . logo_fiche AS logo_fiche_23 ,
t0 . diaporama_actif AS diaporama_actif_24 ,
t0 . images_diaporama AS images_diaporama_25 ,
t0 . participant AS participant_26 ,
t0 . catholique AS catholique_27 ,
t0 . age_admission AS age_admission_28 ,
t0 . actif AS actif_29 ,
t0 . internat AS internat_30 ,
t0 . has_internat AS has_internat_31 ,
t0 . types_internat AS types_internat_32 ,
t0 . sous_contrat AS sous_contrat_33 ,
t0 . alternance AS alternance_34 ,
t0 . type_client AS type_client_35 ,
t0 . bloque_txt_ref AS bloque_txt_ref_36 ,
t0 . facebook AS facebook_37 ,
t0 . bloque_bac2021 AS bloque_bac2021_38 ,
t0 . presence_web AS presence_web_39 ,
t0 . video_plus AS video_plus_40 ,
t0 . diapo_plus AS diapo_plus_41 ,
t0 . jpo_plus AS jpo_plus_42 ,
t0 . doc_plus AS doc_plus_43 ,
t0 . diplome_plus AS diplome_plus_44 ,
t0 . refus AS refus_45 ,
t0 . path AS path_46 ,
t0 . composition_ensemble_scolaire AS composition_ensemble_scolaire_47 ,
t0 . lva AS lva_48 ,
t0 . lvb AS lvb_49 ,
t0 . numero_administratif_uai AS numero_administratif_uai_50 ,
t0 . siret AS siret_51 ,
t0 . chiffres AS chiffres_52 ,
t0 . id AS id_53 ,
t0 . maj AS maj_54 ,
t0 . gestionnaire_id AS gestionnaire_id_55 ,
t56 . type AS type_57 ,
t56 . nombre_eleves AS nombre_eleves_58 ,
t56 . url AS url_59 ,
t56 . video AS video_60 ,
t56 . mots_cles AS mots_cles_61 ,
t56 . denomination AS denomination_62 ,
t56 . denomination_sigle AS denomination_sigle_63 ,
t56 . denomination_extension AS denomination_extension_64 ,
t56 . denomination_abregee AS denomination_abregee_65 ,
t56 . droit_page_web AS droit_page_web_66 ,
t56 . droit_actualite AS droit_actualite_67 ,
t56 . adresse1 AS adresse1_68 ,
t56 . adresse2 AS adresse2_69 ,
t56 . adresse3 AS adresse3_70 ,
t56 . code_postal AS code_postal_71 ,
t56 . cedex AS cedex_72 ,
t56 . latitude AS latitude_73 ,
t56 . longitude AS longitude_74 ,
t56 . telephone_principal AS telephone_principal_75 ,
t56 . fax AS fax_76 ,
t56 . email_principal AS email_principal_77 ,
t56 . logo_liste AS logo_liste_78 ,
t56 . logo_fiche AS logo_fiche_79 ,
t56 . diaporama_actif AS diaporama_actif_80 ,
t56 . images_diaporama AS images_diaporama_81 ,
t56 . participant AS participant_82 ,
t56 . catholique AS catholique_83 ,
t56 . age_admission AS age_admission_84 ,
t56 . actif AS actif_85 ,
t56 . internat AS internat_86 ,
t56 . has_internat AS has_internat_87 ,
t56 . types_internat AS types_internat_88 ,
t56 . sous_contrat AS sous_contrat_89 ,
t56 . alternance AS alternance_90 ,
t56 . type_client AS type_client_91 ,
t56 . bloque_txt_ref AS bloque_txt_ref_92 ,
t56 . facebook AS facebook_93 ,
t56 . bloque_bac2021 AS bloque_bac2021_94 ,
t56 . presence_web AS presence_web_95 ,
t56 . video_plus AS video_plus_96 ,
t56 . diapo_plus AS diapo_plus_97 ,
t56 . jpo_plus AS jpo_plus_98 ,
t56 . doc_plus AS doc_plus_99 ,
t56 . diplome_plus AS diplome_plus_100 ,
t56 . refus AS refus_101 ,
t56 . path AS path_102 ,
t56 . composition_ensemble_scolaire AS composition_ensemble_scolaire_103 ,
t56 . lva AS lva_104 ,
t56 . lvb AS lvb_105 ,
t56 . numero_administratif_uai AS numero_administratif_uai_106 ,
t56 . siret AS siret_107 ,
t56 . chiffres AS chiffres_108 ,
t56 . id AS id_109 ,
t56 . maj AS maj_110 ,
t56 . gestionnaire_id AS gestionnaire_id_111 ,
t56 . ville_id AS ville_id_112 ,
t56 . categorie_primaire_id AS categorie_primaire_id_113 ,
t56 . region_id AS region_id_114 ,
t56 . departement_id AS departement_id_115 ,
t56 . categorie_organisme_id AS categorie_organisme_id_116 ,
t56 . rubrique AS rubrique_117 ,
t56 . internat2_id AS internat2_id_118 ,
t56 . etablissement_lie_id AS etablissement_lie_id_119 ,
t56 . logo_id AS logo_id_120 ,
t56 . diapo_principal_id AS diapo_principal_id_121 ,
t0 . ville_id AS ville_id_122 ,
t123 . actif AS actif_124 ,
t123 . contenu AS contenu_125 ,
t123 . id AS id_126 ,
t123 . etablissement_id AS etablissement_id_127 ,
t123 . template_id AS template_id_128 ,
t0 . categorie_primaire_id AS categorie_primaire_id_129 ,
t0 . region_id AS region_id_130 ,
t0 . departement_id AS departement_id_131 ,
t0 . categorie_organisme_id AS categorie_organisme_id_132 ,
t0 . rubrique AS rubrique_133 ,
t0 . internat2_id AS internat2_id_134 ,
t0 . etablissement_lie_id AS etablissement_lie_id_135 ,
t0 . logo_id AS logo_id_136 ,
t0 . diapo_principal_id AS diapo_principal_id_137
FROM
etablissement t0
LEFT JOIN etablissement t56 ON t0 . gestionnaire_id = t56 . id
LEFT JOIN texte_referencement t123 ON t123 . etablissement_id = t0 . id
WHERE
t0 . id IN (? )
Copy
SELECT t0 . type AS type_1 , t0 . nombre_eleves AS nombre_eleves_2 , t0 . url AS url_3 , t0 . video AS video_4 , t0 . mots_cles AS mots_cles_5 , t0 . denomination AS denomination_6 , t0 . denomination_sigle AS denomination_sigle_7 , t0 . denomination_extension AS denomination_extension_8 , t0 . denomination_abregee AS denomination_abregee_9 , t0 . droit_page_web AS droit_page_web_10 , t0 . droit_actualite AS droit_actualite_11 , t0 . adresse1 AS adresse1_12 , t0 . adresse2 AS adresse2_13 , t0 . adresse3 AS adresse3_14 , t0 . code_postal AS code_postal_15 , t0 . cedex AS cedex_16 , t0 . latitude AS latitude_17 , t0 . longitude AS longitude_18 , t0 . telephone_principal AS telephone_principal_19 , t0 . fax AS fax_20 , t0 . email_principal AS email_principal_21 , t0 . logo_liste AS logo_liste_22 , t0 . logo_fiche AS logo_fiche_23 , t0 . diaporama_actif AS diaporama_actif_24 , t0 . images_diaporama AS images_diaporama_25 , t0 . participant AS participant_26 , t0 . catholique AS catholique_27 , t0 . age_admission AS age_admission_28 , t0 . actif AS actif_29 , t0 . internat AS internat_30 , t0 . has_internat AS has_internat_31 , t0 . types_internat AS types_internat_32 , t0 . sous_contrat AS sous_contrat_33 , t0 . alternance AS alternance_34 , t0 . type_client AS type_client_35 , t0 . bloque_txt_ref AS bloque_txt_ref_36 , t0 . facebook AS facebook_37 , t0 . bloque_bac2021 AS bloque_bac2021_38 , t0 . presence_web AS presence_web_39 , t0 . video_plus AS video_plus_40 , t0 . diapo_plus AS diapo_plus_41 , t0 . jpo_plus AS jpo_plus_42 , t0 . doc_plus AS doc_plus_43 , t0 . diplome_plus AS diplome_plus_44 , t0 . refus AS refus_45 , t0 . path AS path_46 , t0 . composition_ensemble_scolaire AS composition_ensemble_scolaire_47 , t0 . lva AS lva_48 , t0 . lvb AS lvb_49 , t0 . numero_administratif_uai AS numero_administratif_uai_50 , t0 . siret AS siret_51 , t0 . chiffres AS chiffres_52 , t0 . id AS id_53 , t0 . maj AS maj_54 , t0 . gestionnaire_id AS gestionnaire_id_55 , t56 . type AS type_57 , t56 . nombre_eleves AS nombre_eleves_58 , t56 . url AS url_59 , t56 . video AS video_60 , t56 . mots_cles AS mots_cles_61 , t56 . denomination AS denomination_62 , t56 . denomination_sigle AS denomination_sigle_63 , t56 . denomination_extension AS denomination_extension_64 , t56 . denomination_abregee AS denomination_abregee_65 , t56 . droit_page_web AS droit_page_web_66 , t56 . droit_actualite AS droit_actualite_67 , t56 . adresse1 AS adresse1_68 , t56 . adresse2 AS adresse2_69 , t56 . adresse3 AS adresse3_70 , t56 . code_postal AS code_postal_71 , t56 . cedex AS cedex_72 , t56 . latitude AS latitude_73 , t56 . longitude AS longitude_74 , t56 . telephone_principal AS telephone_principal_75 , t56 . fax AS fax_76 , t56 . email_principal AS email_principal_77 , t56 . logo_liste AS logo_liste_78 , t56 . logo_fiche AS logo_fiche_79 , t56 . diaporama_actif AS diaporama_actif_80 , t56 . images_diaporama AS images_diaporama_81 , t56 . participant AS participant_82 , t56 . catholique AS catholique_83 , t56 . age_admission AS age_admission_84 , t56 . actif AS actif_85 , t56 . internat AS internat_86 , t56 . has_internat AS has_internat_87 , t56 . types_internat AS types_internat_88 , t56 . sous_contrat AS sous_contrat_89 , t56 . alternance AS alternance_90 , t56 . type_client AS type_client_91 , t56 . bloque_txt_ref AS bloque_txt_ref_92 , t56 . facebook AS facebook_93 , t56 . bloque_bac2021 AS bloque_bac2021_94 , t56 . presence_web AS presence_web_95 , t56 . video_plus AS video_plus_96 , t56 . diapo_plus AS diapo_plus_97 , t56 . jpo_plus AS jpo_plus_98 , t56 . doc_plus AS doc_plus_99 , t56 . diplome_plus AS diplome_plus_100 , t56 . refus AS refus_101 , t56 . path AS path_102 , t56 . composition_ensemble_scolaire AS composition_ensemble_scolaire_103 , t56 . lva AS lva_104 , t56 . lvb AS lvb_105 , t56 . numero_administratif_uai AS numero_administratif_uai_106 , t56 . siret AS siret_107 , t56 . chiffres AS chiffres_108 , t56 . id AS id_109 , t56 . maj AS maj_110 , t56 . gestionnaire_id AS gestionnaire_id_111 , t56 . ville_id AS ville_id_112 , t56 . categorie_primaire_id AS categorie_primaire_id_113 , t56 . region_id AS region_id_114 , t56 . departement_id AS departement_id_115 , t56 . categorie_organisme_id AS categorie_organisme_id_116 , t56 . rubrique AS rubrique_117 , t56 . internat2_id AS internat2_id_118 , t56 . etablissement_lie_id AS etablissement_lie_id_119 , t56 . logo_id AS logo_id_120 , t56 . diapo_principal_id AS diapo_principal_id_121 , t0 . ville_id AS ville_id_122 , t123 . actif AS actif_124 , t123 . contenu AS contenu_125 , t123 . id AS id_126 , t123 . etablissement_id AS etablissement_id_127 , t123 . template_id AS template_id_128 , t0 . categorie_primaire_id AS categorie_primaire_id_129 , t0 . region_id AS region_id_130 , t0 . departement_id AS departement_id_131 , t0 . categorie_organisme_id AS categorie_organisme_id_132 , t0 . rubrique AS rubrique_133 , t0 . internat2_id AS internat2_id_134 , t0 . etablissement_lie_id AS etablissement_lie_id_135 , t0 . logo_id AS logo_id_136 , t0 . diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0 . gestionnaire_id = t56 . id LEFT JOIN texte_referencement t123 ON t123 . etablissement_id = t0 . id WHERE t0 . id IN ('GE013-75' , 'GE013-30' , 'GE013-34' , 'GE013-27' , 'GE013-35' , 'GE013-36' , 'GE013-57' , 'GE013-24' , 'GE013-18' , 'GE013-56' , 'GE013-25' , 'GE013-13' , 'GE013-94' , 'GE013-97' , 'GE013-3' , 'GE013-1' , 'GE013-86' , 'GE013-9' , 'GE013-78' , 'GE013-31' , 'GE013-83' );
Copy
4
2.36 ms
SELECT r0_ . libelle AS libelle_0 , r0_ . slug AS slug_1 , r0_ . region_adm AS region_adm_2 , r0_ . ancienne AS ancienne_3 , r0_ . onglets AS onglets_4 , r0_ . id AS id_5 , r0_ . maj AS maj_6 FROM region r0_ WHERE r0_ . ancienne IS NULL AND r0_ . libelle IS NOT NULL AND r0_ . slug IS NOT NULL ORDER BY r0_ . pays_id DESC , r0_ . libelle ASC
SELECT r0_ . libelle AS libelle_0 , r0_ . slug AS slug_1 , r0_ . region_adm AS region_adm_2 , r0_ . ancienne AS ancienne_3 , r0_ . onglets AS onglets_4 , r0_ . id AS id_5 , r0_ . maj AS maj_6 FROM region r0_ WHERE r0_ . ancienne IS NULL AND r0_ . libelle IS NOT NULL AND r0_ . slug IS NOT NULL ORDER BY r0_ . pays_id DESC , r0_ . libelle ASC ;
Copy
5
7.25 ms
SELECT d0_ . slug AS slug_0 , d0_ . libelle AS libelle_1 , d0_ . onglets AS onglets_2 , d0_ . id AS id_3 , d0_ . maj AS maj_4 , d1_ . latitude AS latitude_5 , d1_ . longitude AS longitude_6 , d1_ . id AS id_7 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_ . id = d1_ . departement_id WHERE d0_ . region_id = ? AND d0_ . id < > ? ORDER BY d0_ . libelle ASC
Parameters :
[
"PROV "
"BE "
]
SELECT d0_ . slug AS slug_0 , d0_ . libelle AS libelle_1 , d0_ . onglets AS onglets_2 , d0_ . id AS id_3 , d0_ . maj AS maj_4 , d1_ . latitude AS latitude_5 , d1_ . longitude AS longitude_6 , d1_ . id AS id_7 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_ . id = d1_ . departement_id WHERE d0_ . region_id = 'PROV' AND d0_ . id < > 'BE' ORDER BY d0_ . libelle ASC ;
Copy
6
0.42 ms
SELECT v0_ . slug AS slug_0 , v0_ . libelle AS libelle_1 , v0_ . code_postal AS code_postal_2 , v0_ . email_delegue AS email_delegue_3 , v0_ . onglets AS onglets_4 , v0_ . id AS id_5 , v0_ . maj AS maj_6 , v1_ . latitude AS latitude_7 , v1_ . longitude AS longitude_8 , v1_ . id AS id_9 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_ . id = v1_ . ville_id WHERE v0_ . libelle IS NOT NULL AND v0_ . departement_id = ? AND v0_ . id IN (? ) ORDER BY v0_ . libelle ASC
Parameters :
[
"13 "
[
"13001 "
"13206 "
"13213 "
"13208 "
"13204 "
"13209 "
"13212 "
"13205 "
"13201 "
"13214 "
"13215 "
"13103 "
"13211 "
"13004 "
"13207 "
"13005 "
"13203 "
"13063 "
"13202 "
"13210 "
"13040 "
"13216 "
"13056 "
"13071 "
"13117 "
"13015 "
"13043 "
"13097 "
"13108 "
"13010 "
"13027 "
"13028 "
"13032 "
"13047 "
"13050 "
"13054 "
"13078 "
"13079 "
"13083 "
"13106 "
"13119 "
"13014 "
"13018 "
"13019 "
"13022 "
"13036 "
"13037 "
"13041 "
"13042 "
"13045 "
"13052 "
"13053 "
"13060 "
"13066 "
"13069 "
"13087 "
"13100 "
]
]
SELECT v0_ . slug AS slug_0 , v0_ . libelle AS libelle_1 , v0_ . code_postal AS code_postal_2 , v0_ . email_delegue AS email_delegue_3 , v0_ . onglets AS onglets_4 , v0_ . id AS id_5 , v0_ . maj AS maj_6 , v1_ . latitude AS latitude_7 , v1_ . longitude AS longitude_8 , v1_ . id AS id_9 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_ . id = v1_ . ville_id WHERE v0_ . libelle IS NOT NULL AND v0_ . departement_id = '13' AND v0_ . id IN ('13001' , '13206' , '13213' , '13208' , '13204' , '13209' , '13212' , '13205' , '13201' , '13214' , '13215' , '13103' , '13211' , '13004' , '13207' , '13005' , '13203' , '13063' , '13202' , '13210' , '13040' , '13216' , '13056' , '13071' , '13117' , '13015' , '13043' , '13097' , '13108' , '13010' , '13027' , '13028' , '13032' , '13047' , '13050' , '13054' , '13078' , '13079' , '13083' , '13106' , '13119' , '13014' , '13018' , '13019' , '13022' , '13036' , '13037' , '13041' , '13042' , '13045' , '13052' , '13053' , '13060' , '13066' , '13069' , '13087' , '13100' ) ORDER BY v0_ . libelle ASC ;
Copy
7
5.09 ms
SELECT t0 . slug AS slug_1 , t0 . libelle AS libelle_2 , t0 . code_postal AS code_postal_3 , t0 . email_delegue AS email_delegue_4 , t0 . onglets AS onglets_5 , t0 . id AS id_6 , t0 . maj AS maj_7 , t0 . departement_id AS departement_id_8 , t9 . latitude AS latitude_10 , t9 . longitude AS longitude_11 , t9 . id AS id_12 , t9 . ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9 . ville_id = t0 . id WHERE t0 . id IN (? ) ORDER BY t0 . libelle ASC
Parameters :
[
[
"13001 "
"13206 "
"13213 "
"13208 "
"13204 "
"13209 "
"13212 "
"13205 "
"13201 "
"13214 "
"13215 "
"13103 "
"13211 "
"13004 "
"13207 "
"13005 "
"13203 "
"13063 "
"13202 "
"13210 "
"13040 "
"13216 "
"13056 "
"13071 "
"13117 "
"13015 "
"13043 "
"13097 "
"13108 "
"13010 "
"13027 "
"13028 "
"13032 "
"13047 "
"13050 "
"13054 "
"13078 "
"13079 "
"13083 "
"13106 "
"13119 "
"13014 "
"13018 "
"13019 "
"13022 "
"13036 "
"13037 "
"13041 "
"13042 "
"13045 "
"13052 "
"13053 "
"13060 "
"13066 "
"13069 "
"13087 "
"13100 "
]
]
SELECT t0 . slug AS slug_1 , t0 . libelle AS libelle_2 , t0 . code_postal AS code_postal_3 , t0 . email_delegue AS email_delegue_4 , t0 . onglets AS onglets_5 , t0 . id AS id_6 , t0 . maj AS maj_7 , t0 . departement_id AS departement_id_8 , t9 . latitude AS latitude_10 , t9 . longitude AS longitude_11 , t9 . id AS id_12 , t9 . ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9 . ville_id = t0 . id WHERE t0 . id IN ('13001' , '13206' , '13213' , '13208' , '13204' , '13209' , '13212' , '13205' , '13201' , '13214' , '13215' , '13103' , '13211' , '13004' , '13207' , '13005' , '13203' , '13063' , '13202' , '13210' , '13040' , '13216' , '13056' , '13071' , '13117' , '13015' , '13043' , '13097' , '13108' , '13010' , '13027' , '13028' , '13032' , '13047' , '13050' , '13054' , '13078' , '13079' , '13083' , '13106' , '13119' , '13014' , '13018' , '13019' , '13022' , '13036' , '13037' , '13041' , '13042' , '13045' , '13052' , '13053' , '13060' , '13066' , '13069' , '13087' , '13100' ) ORDER BY t0 . libelle ASC ;
Copy
8
7.78 ms
SELECT i0_ . libelle AS libelle_0 , i0_ . libelle_mep AS libelle_mep_1 , i0_ . texte_defaut AS texte_defaut_2 , i0_ . onglet AS onglet_3 , i0_ . niveau AS niveau_4 , i0_ . formation AS formation_5 , i0_ . options AS options_6 , i0_ . libelle_web AS libelle_web_7 , i0_ . id AS id_8 , i0_ . maj AS maj_9 FROM items i0_ INNER JOIN items_insertion i1_ ON (i0_ . id = i1_ . pere ) WHERE i0_ . formation = 'oui' AND i0_ . niveau = 3 AND i0_ . id LIKE ? AND i0_ . id IN (? ) GROUP BY i0_ . id ORDER BY i0_ . libelle ASC
Parameters :
[
"annuaire-enseignement-prive-% "
[
"LYC-LANG "
"LYC-LANG-LV1 "
"LYC-LANG-LV1-ANG "
"LYC-LANG-LV2 "
"LYC-LANG-LV2-ESP "
"LYC-FORMA2021-SPEC "
"PBAC-COORD "
"PBAC-COORD-ADR "
"PBAC-COORD-MAIL "
"PBAC-COORD-TEL "
"PBAC-COORD-WEB "
"LYC-LANG-LV2-ITA "
"ECOLE-COORD "
"ECOLE-COORD-ADR "
"ECOLE-COORD-MAIL "
"ECOLE-COORD-TEL "
"ECOLE-PRES "
"ECOLE-CLA "
"ECOLE-COORD-WEB "
"ECOLE-CLA-PRIM "
"COLL-COORD "
"COLL-COORD-ADR "
"COLL-COORD-MAIL "
"COLL-COORD-TEL "
"COLL-COORD-WEB "
"COLL-LANG "
"COLL-PRES "
"COLL-LANG-LV1 "
"COLL-LANG-LV1-ANG "
"COLL-LANG-LV2 "
"COLL-SPEC "
"LYC-COORD "
"LYC-COORD-ADR "
"LYC-COORD-MAIL "
"LYC-COORD-TEL "
"LYC-COORD-WEB "
"ECOLE-CLA-MAT "
"LYC-PRES "
"COLL-LANG-LV2-ESP "
"COLL-SPEC-ART "
"ECOLE-ACCU "
"COLL-ACCU "
"ECOLE-SPEC "
"LYC-SPEC "
"PBAC-PRES "
"COLL-CLA "
"COLL-SPEC-EDU "
"COLL-SPEC-SORT "
"ECOLE-ACCU-PERI "
"LYC-FORMA2021-SPEC-SPECLANG "
"COLL-CLA-DNB "
"COLL-PRES-CHE "
"LYC-LANG-LV2-ALL "
"COLL-SPEC-ANC_MT "
"COLL-SPEC-ANC_MT-LAT "
"COLL-SPEC-ASPO "
"ECOLE-PRES-NBE "
"COLL-PRES-SCO "
"ECOLE-ACCU-CANT "
"ECOLE-PRES-SCO "
"COLL-ACCU-CANT "
"COLL-LANG-LV2-ITA "
"COLL-PRES-NBE "
"COLL-SPEC-CDI "
"ECOLE-ACCU-ADM "
"ECOLE-COORD-FAX "
"ECOLE-SPEC-CDEC "
"ECOLE-SPEC-INI "
"LYC-ACCU "
"LYC-FORMA2021-SPEC-SPECARTS "
"PBAC-COORD-FAX "
"COLL-SPEC-VOY "
"LYC-PRES-CHE "
"COLL-ACCU-PERI "
"COLL-LANG-LV2-ALL "
"ECOLE-PRES-CHE "
"ECOLE-PRES-TUT "
"ECOLE-SPEC-ART "
"LYC-COORD-FAX "
"LYC-SPEC-CDI "
"LYCPRO-COORD "
"LYCPRO-COORD-ADR "
"LYCPRO-COORD-MAIL "
"LYCPRO-COORD-TEL "
"LYCPRO-COORD-WEB "
"PBAC-BAC2-CDV "
"COLL-ACCU-MIXT "
"COLL-COORD-FAX "
"COLL-PRES-NBC "
"ECOLE-ACCU-MIXT "
"LYC-FORMA2021-SPEC-SPECLLCA "
"LYC-PRES-SCO "
"COLL-PRES-NID "
"COLL-PRES-TUT "
"COLL-SPEC-ASSR1 "
"COLL-SPEC-ASSR2 "
"COLL-SPEC-PIX "
"ECOLE-PRES-NBC "
"ECOLE-SPEC-SORT "
"ECOLE-SPEC-SPOR "
"LYC-FORMA2021-SPEC-SPECPHY "
"LYC-SPEC-ASPO "
"LYC-SPEC-SLIN "
"LYC-SPEC-VOY "
"LYCPRO-PRES "
"COLL-ACCU-ACCE "
"COLL-ACCU-BOUR "
"COLL-ACCU-EXT "
"COLL-SPEC-CUL "
"COLL-SPEC-REPA "
"COLL-SPEC-SPOR "
"COLL-SPEC-TICE "
"ECOLE-PRES-NID "
"ECOLE-SPEC-PERI "
"LYC-SPEC-CUL "
"PBAC-ACCU "
"ECOLE-ACCU-ADM-3ANS "
"ECOLE-ACCU-EXT "
"ECOLE-ACCU-ORGA "
"LYC-FORMA2021 "
"LYC-FORMA2021-SPEC-SPECHIST "
"LYC-FORMA2021-SPEC-SPECMAT "
"LYC-FORMA2021-SPEC-SPECSES "
"LYC-FORMA2021-SPEC-SPECSVT "
"LYC-PRES-NBE "
"COLL-ACCU-ORGA "
"COLL-SPEC-BDI "
"COLL-SPEC-PAST "
"ECOLE-SPEC-EDD "
"ECOLE-SPEC-TICE "
"LYC-LANG-LV2-ANG "
"PBAC-BAC2-CDV-BTSMA "
"COLL-CLA-CLA "
"COLL-TARIFS "
"COLL-TARIFS-INSC "
"COLL-TARIFS-MODAL "
"COLL-TARIFS-SCOLA "
"ECOLE-ACCU-ORGA-S4J "
"ECOLE-SPEC-EDU "
"LYC-ACCU-ACCE "
"LYC-ACCU-CANT "
"LYC-ACCU-MIXT "
"LYC-FORMA2021-GFACU "
"LYC-SPEC-BDI "
"LYC-SPEC-EDU "
"COLL-ACCU-HAND_MT "
"COLL-SPEC-ANC_MT-GRE "
"COLL-SPEC-CDEC "
"COLL-TARIFS-RCOMPL "
"ECOLE-SPEC-REPA "
"ECOLE-TARIFS "
"LYC-ACCU-EXT "
"LYC-FORMA2021-GFACU-GFACUMATC "
"LYC-FORMA2021-SPEC-SPECHUM "
"LYC-LANG-ANC_MT "
"LYC-LANG-ANC_MT-LAT "
"LYC-PRES-NBC "
"LYC-PRES-NID "
"LYC-SPEC-REPA "
"LYCPRO-LANG "
"LYCPRO-LANG-LV1 "
"LYCPRO-SPEC "
"PBAC-PRES-CHE "
"PBAC-PRES-SCO "
"ECOLE-SPEC-ACC "
"ECOLE-TARIFS-MODAL "
"ECOLE-TARIFS-SCOLA-MATER "
"ECOLE-TARIFS-SCOLA-PRIM "
"LYC-ACCU-BOUR "
"LYC-FORMA2021-GFACU-GFACUARTS "
"LYC-FORMA2021-GFACU-GFACULANG "
"LYC-FORMA2021-GFACU-GFACUMATE "
"LYC-LANG-LV1-ALL "
"LYC-PRES-TUT "
"LYC-SPEC-PIX "
"LYC-TARIFS "
"LYC-TARIFS-MODAL "
"LYC-TARIFS-SCOLA "
"LYCPRO-ACCU "
"LYCPRO-LANG-LV1-ANG "
"PBAC-PRES-NBE "
"COLL-CLA-CFG "
"COLL-SPEC-ACC "
"COLL-SPEC-BILA_MT "
"COLL-SPEC-EDD "
"COLL-SPEC-PSC1 "
"ECOLE-ACCU-ACCE "
"ECOLE-PRES-DTRICE "
"ECOLE-TARIFS-INSC "
"ECOLE-TARIFS-RCOMPL "
"LYC-LANG-CERT "
"LYC-LANG-LV3 "
"LYC-SPEC-ART "
"LYC-TARIFS-INSC "
"LYCPRO-COORD-FAX "
"PBAC-BAC2-GADF "
"PBAC-BAC3-CDV "
"PBAC-BAC3-GADF "
"PBAC-PRES-NID "
"PBAC-SPEC "
"COLL-SPEC-B2I "
"ECOLE-SPEC-B2I "
"ECOLE-TARIFS-SCOLA-3EE "
"LYC-ACCU-HAND_MT "
"LYC-BACTEC-GADF "
"LYC-TARIFS-RCOMPL "
"LYCPRO-LANG-LV2 "
"PBAC-ACCU-MIXT "
"PBAC-PRES-DTEUR "
"COLL-SPEC-SLIN "
"COLL-TARIFS-SCOLA-3EE "
"ECOLE-ACCU-HOR_MT "
"LYC-ACCU-CAF "
"LYC-FORMA2021-GFACU-GFACULV3 "
"LYC-FORMA2021-SPEC-SPECNUM "
"LYC-LANG-LV1-ESP "
"LYC-LANG-LV3-ITA "
"LYC-SPEC-EXP "
"LYC-SPEC-SPOR "
"LYC-SPEC-TICE "
"LYCPRO-BACP-DISTRI "
"LYCPRO-LANG-LV2-ESP "
"LYCPRO-PRES-SCO "
"PBAC-ACCU-ACCE "
"PBAC-ACCU-HAND_MT "
"PBAC-BAC45-GADF "
"PBAC-TARIFS-INSC "
"COLL-SPEC-EFF "
"COLL-SPEC-JUM "
"COLL-SPEC-PERI "
"COLL-SPEC-RENF "
"COLL-SPEC-SCI "
"COLL-SPEC-STA_MT "
"COLL-TARIFS-SCOLA-2EE "
"ECOLE-SPEC-VOY "
"ECOLE-TARIFS-SCOLA-2EE "
"LYC-FORMA2021-GFACU-GFACUDROI "
"LYC-FORMA2021-GFACU-GFACUEPS "
"LYC-FORMA2021-SPEC-SPECING "
"LYC-LANG-EUR "
"LYC-SPEC-MULT "
"LYC-TARIFS-SCOLA-2EE "
"LYC-TARIFS-SCOLA-3EE "
"LYCPRO-ACCU-MIXT "
"LYCPRO-BACP-DISTRI-BACPR3 "
"LYCPRO-PRES-TEUR "
"PBAC "
"PBAC-TARIFS "
"PBAC-TARIFS-MODAL "
"PBAC-TARIFS-RCOMPL "
"COLL-ACCU-ORGA-S5J "
"COLL-LANG-LV1-ALL "
"COLL-SPEC-ACC-ULIS "
"COLL-SPEC-CFG "
"COLL-SPEC-PARC "
"COLL-SPEC-PREC "
"COLL-SPEC-PRO "
"COLL-SPEC-SPO_MT "
"ECOLE-ACCU-HAND_MT "
"ECOLE-SPEC-EFF "
"ECOLE-SPEC-PAST "
"LYC-ACCU-ORGA "
"LYC-FORMA2021-SPEC-SPORT "
"LYC-LANG-ANC_MT-GRE "
"LYC-LANG-LV1-ITA "
"LYC-PRES-DTEUR "
"LYC-SPEC-2SGT "
"LYC-SPEC-JUM "
"LYC-SPEC-PREP "
"LYC-SPEC-TPE "
"LYC-SPEC-TXTS31 "
"LYCPRO-PRES-CHE "
"LYCPRO-PRES-NBE "
"PBAC-ACCU-BOUR "
"PBAC-ACCU-CANT "
"PBAC-BAC2-CDV-BTSNE "
"PBAC-BAC2-GADF-BTSGE "
"PBAC-BAC2-TRAN "
"PBAC-BAC2-TRAN-BTSGE "
"COLL-SPEC-EDUC "
"COLL-SPEC-TXTS27 "
"ECOLE-SPEC-ACP "
"LYC "
"LYC-BACTEC-CDV "
"LYC-BACTEC-CDV-STMG "
"LYC-BACTEC-GADF-STMGRHC "
"LYC-PRES-TXTS "
"LYCPRO "
"LYCPRO-BACP-DISTRI-BACPR2 "
"LYCPRO-BACP-GADF "
"LYCPRO-BACP-GADF-BACPR1 "
"LYCPRO-PRES-NBC "
"LYCPRO-PRES-TXTS "
"LYCPRO-SPEC-PMET "
"LYCPRO-TARIFS "
"LYCPRO-TARIFS-INSC "
"LYCPRO-TARIFS-MODAL "
"LYCPRO-TARIFS-RCOMPL "
"LYCPRO-TARIFS-SCOLA "
"PBAC-ACCU-EXT "
"PBAC-BAC2-BAI "
"PBAC-BAC2-GADF-BTSCO "
"PBAC-BAC45-CDV "
"PBAC-LOGO "
"PBAC-PRES-HCO "
"PBAC-PRES-TUT "
"PBAC-PRES-TXTS "
"PBAC-TARIFS-INSC-BAC+2 "
"COLL-ACCU-ORGA-SDJ "
"COLL-SPEC-EPI "
"COLL-SPEC-MULT "
"ECOLE-PRES-HCO "
"ECOLE-SPEC-ACC-RA "
"ECOLE-SPEC-ACC-ULIS "
"ECOLE-SPEC-EDUC "
"ECOLE-SPEC-TXTS "
"INTERNAT-ACCSCO "
"INTERNAT-ACTPER "
"INTERNAT-COORD "
"INTERNAT-COORD-ADR "
"INTERNAT-COORD-MAIL "
"INTERNAT-COORD-TEL "
"INTERNAT-COORD-WEB "
"INTERNAT-HEB "
"INTERNAT-INFO "
"INTERNAT-INFO-ACCES "
"INTERNAT-INFO-CAPACC "
"LYC-ACCU-INTA "
"LYC-BACTEC "
"LYC-BACTEC-GADF-STMGGF "
"LYC-BACTEC-SASO "
"LYC-BACTEC-SASO-ST2S "
"LYC-BACTEC-TFACU "
"LYC-SPEC-EFF "
"LYC-SPEC-OPTE "
"LYC-SPEC-PAST "
"LYCPRO-ACCU-ACCE "
"LYCPRO-ACCU-BOUR "
"LYCPRO-ACCU-HAND_MT "
"LYCPRO-BACP-TRAN "
"LYCPRO-PRES-NID "
"PBAC-ACCU-CAF "
"PBAC-BAC2-SASO "
"PBAC-SPEC-TXTS51 "
"COLL-ACCU-HORA_MT "
"COLL-PRES-DTEUR "
"COLL-SPEC-BIA "
"COLL-SPEC-BIL_MT "
"COLL-SPEC-CERT "
"COLL-SPEC-CSPE_MT "
"COLL-SPEC-OPTL "
"COLL-SPEC-TXTS21 "
"COLL-SPEC-TXTS23 "
"ECOLE-PRES-DTEUR "
"ECOLE-SPEC-ACC-ASH "
"ECOLE-SPEC-ASSR "
"ECOLE-SPEC-BIL_MT "
"ECOLE-SPEC-ELANG "
"ECOLE-SPEC-PREC "
"ECOLE-SPEC-TXTS12 "
"INTERNAT-ACCSCO-ETSURV "
"INTERNAT-ACCSCO-SOUSCO "
"INTERNAT-ACTPER-ACTSPO "
"INTERNAT-ACTPER-SOITHE "
"INTERNAT-ACTPER-TXTS "
"INTERNAT-HEB-CHAMB "
"INTERNAT-INFO-INTSEM "
"LYC-BACTEC-ELEC "
"LYC-BACTEC-ELEC-STI2D "
"LYC-BACTEC-ENEX "
"LYC-BACTEC-ENEX-STI2D "
"LYC-BACTEC-TFACU-ARTS "
"LYC-LANG-BEUR "
"LYC-LANG-TXTS "
"LYC-LOGO "
"LYC-PRES-HCO "
"LYC-SPEC-B2I "
"LYC-SPEC-PREC "
"LYC-SPEC-SCI "
"LYC-SPEC-TXTS "
"LYCPRO-BACP-INF "
"LYCPRO-BACP-TEXT "
"LYCPRO-BACP-TRAN-BPRLOG "
"LYCPRO-LOGO "
"LYCPRO-PRES-HCO "
"LYCPRO-PRESLIBRE-TXTS_IS "
"LYCPRO-PRESLIBRE_IS "
"LYCPRO-SPEC-ACC "
"LYCPRO-SPEC-BDI "
"LYCPRO-SPEC-CDI "
"LYCPRO-SPEC-EDU "
"LYCPRO-SPEC-PRE "
"LYCPRO-SPEC-TXTS42 "
"LYCPRO-SPEC-VOY "
"LYCPRO-TARIFS-SCOLA-2EE "
"LYCPRO-TARIFS-SCOLA-3EE "
"PBAC-ACCU-HEB "
"PBAC-ACCU-INTA "
"PBAC-BAC2-BAI-BTSAS "
"PBAC-BAC2-WEB "
"PBAC-BAC2-WEB-BTSCI "
"PBAC-BAC2-WEB-BTSCI0 "
"PBAC-BAC3-PUB "
"PBAC-PRES-DTRICE "
"COLL-ACCU-INTA "
"COLL-ACCU-ORGA-S4J "
"COLL-PRES-AUTR1_MT "
"COLL-PRES-DTRICE "
"COLL-PRES-HCO "
"COLL-PRES-TXTS "
"COLL-SPEC-ACC-SEGPA "
"COLL-SPEC-EUR "
"COLL-SPEC-INI "
"COLL-SPEC-TXTS "
"ECOLE-ACCU-ADM-2ANS "
"ECOLE-ACCU-ADM-2ANSD "
"INTERNAT-ACCSCO-TXTS "
"INTERNAT-PRES "
"INTERNAT-PRES-TXTS "
"INTERNAT-TARIFS "
"INTERNAT-TARIFS-TXTS "
"LYC-ACCU-HORA_MT "
"LYC-BACTEC-CHI "
"LYC-BACTEC-CHI-STLBIO "
"LYC-BACTEC-MAUT "
"LYC-BACTEC-MAUT-STI2D "
"LYC-COORD-TXTS "
"LYC-FORMA2021-GFACU-TXTS2021 "
"LYC-LANG-LV2-CHI "
"LYC-LANG-LV3-ESP "
"LYC-LANG-RENF "
"LYC-SPEC-ACC "
"LYC-SPEC-BIA "
"LYC-SPEC-EDUC "
"LYC-SPEC-EMPL "
"LYC-SPEC-PERI "
"LYC-SPEC-TXTS35 "
"LYCPRO-ACCU-APP "
"LYCPRO-ACCU-CANT "
"LYCPRO-ACCU-HORA_MT "
"LYCPRO-ACCU-INTA "
"LYCPRO-ACCU-ORGA "
"LYCPRO-BACP-HOT "
"LYCPRO-BACP-MAINT "
"LYCPRO-BACP-SANT "
"LYCPRO-BACP-TEXT-BPRCOS "
"LYCPRO-CAP-COM "
"LYCPRO-CAP-COM-CAPEQ "
"LYCPRO-CAP-ELE "
"LYCPRO-CAP-MOD "
"LYCPRO-LANG-LV1-ESP "
"LYCPRO-LANG-LV2-ANG "
"LYCPRO-LANG-LV2-ITA "
"LYCPRO-PRES-TRICE "
"LYCPRO-SPEC-ACC-ULIS "
"LYCPRO-SPEC-ASPO "
"LYCPRO-SPEC-PIX "
"LYCPRO-SPEC-SPOR "
"PBAC-BAC2 "
"PBAC-BAC2-BAI-BTSPRI "
"PBAC-BAC2-CHI "
"PBAC-BAC2-ENT "
"PBAC-BAC2-ENT-BTSMA "
"PBAC-BAC2-GADF-BTSSU "
"PBAC-BAC2-HOT "
"PBAC-BAC2-PUB "
"PBAC-BAC2-PUB-BTSCOM "
"PBAC-BAC2-TXTS0 "
"PBAC-BAC3-GADF-DCG "
"PBAC-BAC45 "
"PBAC-BAC45-GADF-DSCG "
"PBAC-BAC45-GADF-MANAG "
"PBAC-PREPA-COM "
"PBAC-SPEC-ADMI "
"PBAC-SPEC-ENTR "
"PBAC-SPEC-IGEN "
"PBAC-SPEC-TXTS "
"PBAC-TARIFS-INSC-BAC+3 "
"COLL-ACCU-TXTS "
"COLL-ACCU-TXTS26 "
"COLL-CLA-TXTS "
"COLL-LANG-LV1-ARA "
"COLL-LANG-LV2-CHI "
"COLL-LANG-LV3 "
"COLL-LANG-LV3-ESP "
"COLL-LANG-TXTS "
"COLL-SPEC-FLE "
"COLL-SPEC-OPTAS "
"COLL-SPEC-PED "
"ECOLE-ACCU-TXTS16 "
"ECOLE-CLA-TXTS "
"ECOLE-SPEC-ACC-ASED "
"ECOLE-SPEC-TXTS11 "
"ECOLE-SPEC-TXTS13 "
"ECOLE-SPEC-TXTS14 "
"ECOLE-SPEC-TXTS15 "
"INTERNAT-ACTPER-SORTEDU "
"INTERNAT-COORD-FAX "
"INTERNAT-EQCOMP "
"INTERNAT-EQCOMP-SALETU "
"INTERNAT-EQCOMP-TXTS "
"INTERNAT-INFO-INTPERM "
"INTERNAT-INFO-NIVENSACC "
"INTERNAT-INFO-OUVPVAC "
"LYC-ACCU-TXTS36 "
"LYC-BACTEC-CHI-STLPHY "
"LYC-BACTEC-TFACU-EPS "
"LYC-BACTEC-WEB "
"LYC-BACTEC-WEB-STMGSIG "
"LYC-LANG-BILA_MT "
"LYC-LANG-BIL_MT "
"LYC-LANG-FLE "
"LYC-LANG-LV2-HEB "
"LYC-LANG-LV3-CHI "
"LYC-LANG-LV3-RUS "
"LYC-LANG-REG_MT "
"LYC-PRES-DTRICE "
"LYC-SPEC-ACC-ULIS "
"LYC-SPEC-PASS_MT "
"LYC-SPEC-PSC1 "
"LYC-SPEC-SPO_MT "
"LYC-SPEC-TXTS36 "
"LYCPRO-ACCU-EXT "
"LYCPRO-BACP-DISTRI-BACPR "
"LYCPRO-BACP-ELEC "
"LYCPRO-BACP-ELEC-BACPR1 "
"LYCPRO-BACP-HOT-BPRCUI "
"LYCPRO-BACP-HOT-BPRRES "
"LYCPRO-BACP-INF-BACPR0 "
"LYCPRO-BACP-MAINT-BPREQI "
"LYCPRO-BACP-PUB "
"LYCPRO-BACP-PUB-BPRCOV "
"LYCPRO-CAP-BOI "
"LYCPRO-CAP-BOI-MENF "
"LYCPRO-CAP-BTP "
"LYCPRO-CAP-COP "
"LYCPRO-CAP-ELE-CAPEL "
"LYCPRO-CAP-HOT "
"LYCPRO-CAP-HOT-CUI "
"LYCPRO-CAP-MOD-EST "
"LYCPRO-CAP-SANT "
"LYCPRO-SPEC-B2I "
"LYCPRO-SPEC-CUL "
"LYCPRO-SPEC-EDUC "
"LYCPRO-SPEC-EMPL "
"LYCPRO-SPEC-MULT "
"LYCPRO-SPEC-PAST "
"LYCPRO-SPEC-SLIN "
"LYCPRO-SPEC-SPO_MT "
"LYCPRO-SPEC-STA_MT "
"LYCPRO-SPEC-TICE "
"LYCPRO-SPEC-TXTS47 "
"LYCPRO-SPEC-TXTS48 "
"LYCPRO-TEXTC1_MT "
"PBAC-BAC2-CDV-BTSCO "
"PBAC-BAC2-CDV-BTSCOMI "
"PBAC-BAC2-CHI-BTSABM "
"PBAC-BAC2-GADF-TITRE "
"PBAC-BAC2-GADF-TITRE6 "
"PBAC-BAC2-HOT-BTSMA "
"PBAC-BAC2-HOT-BTSMA0 "
"PBAC-BAC2-SPOR "
"PBAC-BAC2-SPOR-BTSTOU "
"PBAC-BAC2-TEXT "
"PBAC-BAC3 "
"PBAC-BAC3-CDV-BRESDEVC "
"PBAC-BAC3-CDV-DEESMA "
"PBAC-BAC3-CDV-RESPO0 "
"PBAC-BAC3-CDV-RESPO3 "
"PBAC-BAC3-GADF-CERTI0 "
"PBAC-BAC3-GADF-CHARG0 "
"PBAC-BAC3-GADF-CONTR "
"PBAC-BAC3-SASO "
"PBAC-BAC3-TXTS0 "
"PBAC-BAC45-CDV-MANAG "
"PBAC-BAC45-GADF-MANAG0 "
"PBAC-BAC45-PUB "
"PBAC-BAC45-PUB-MANAG "
"PBAC-BAC45-TXTS0 "
"PBAC-FPC-DISTRI "
"PBAC-PREPA-MAUT "
"PBAC-SPEC-TXTS52 "
"PBAC-TARIFS-INSC-PREPA "
"PBAC-TEXTC1_MT "
"COLL "
"COLL-COORD-TXTS "
"COLL-LANG-LV1-CHI "
"COLL-LANG-LV1-ESP "
"COLL-LANG-LV1-ITA "
"COLL-LANG-LV1-NEE "
"COLL-LANG-LV1-RUS "
"COLL-LANG-LV2-ANG "
"COLL-LANG-LV2-ARA "
"COLL-LANG-LV2-HEB "
"COLL-LANG-LV2-JAP "
"COLL-LANG-LV2-NEE "
"COLL-LANG-LV2-RUS "
"COLL-LANG-LV3-CHI "
"COLL-LANG-LV3-ITA "
"COLL-SPEC-ALTE "
"COLL-SPEC-ANC_MT-TXTS "
"COLL-SPEC-PMET "
"COLL-SPEC-REG_MT "
"COLL-SPEC-REG_MT-PRO "
"COLL-SPEC-TXTS25 "
"COLL-SPEC-TXTS28 "
"COLL-SPEC-TXTS29 "
"COLL-SPEC-TXTS32 "
"ECOLE "
"ECOLE-ACCU-INTA "
"ECOLE-ACCU-ORGA-SDJ "
"ECOLE-ACCU-TXTS18 "
"ECOLE-COORD-TXTS "
"ECOLE-LOGO "
"ECOLE-PRES-TXTS "
"ECOLE-SPEC-ACC-MAI "
"ECOLE-SPEC-ACC-RAS "
"ECOLE-SPEC-ASPO "
"ECOLE-SPEC-PED "
"ECOLE-SPEC-PED-FRE "
"ECOLE-SPEC-PED-MON "
"ECOLE-SPEC-PED-TXTS "
"ECOLE-SPEC-PIX "
"ECOLE-SPEC-SLIN "
"ECOLE-SPEC-TXTS16 "
"INTERNAT "
"INTERNAT-ACCSCO-SOUSPEC "
"INTERNAT-EQCOMP-EQSPO "
"INTERNAT-EQCOMP-FOYER "
"INTERNAT-EQCOMP-SALINFO "
"INTERNAT-HEB-TXTS "
"INTERNAT-INFO-ENC "
"INTERNAT-INFO-TXTS "
"INTERNAT-LOGO "
"INTERNAT-PHOTO "
"LYC-ACCU-TXTS "
"LYC-BACTEC-CHI-BACST4 "
"LYC-BACTEC-GADF-BACST "
"LYC-BACTEC-PUB "
"LYC-BACTEC-PUB-STD2A "
"LYC-FORMA2021-SPEC-SPECECO "
"LYC-LANG-LSF "
"LYC-LANG-LV1-ARA "
"LYC-LANG-LV1-CHI "
"LYC-LANG-LV1-HEB "
"LYC-LANG-LV1-NEE "
"LYC-LANG-LV1-RUS "
"LYC-LANG-LV2-ARA "
"LYC-LANG-LV2-JAP "
"LYC-LANG-LV2-NEE "
"LYC-LANG-LV2-RUS "
"LYC-LANG-LV3-ALL "
"LYC-LANG-LV3-TXTS "
"LYC-LANG-OPTL "
"LYC-LANG-REG_MT-COR "
"LYC-LANG-REG_MT-PRO "
"LYC-PRES-AUTR1_MT "
"LYC-SPEC-ACC-TXTS "
"LYC-SPEC-OPTAS "
"LYC-SPEC-PED "
"LYC-SPEC-TXTS32 "
"LYC-SPEC-TXTS37 "
"LYC-SPEC-TXTS40 "
"LYC-TEXTC1_MT "
"LYCPRO-ACCU-CAF "
"LYCPRO-ACCU-TXTS "
"LYCPRO-ACCU-TXTS47 "
"LYCPRO-BACP-AGRI "
"LYCPRO-BACP-AGRI-BACPR7 "
"LYCPRO-BACP-BOI "
"LYCPRO-BACP-BOI-BPMAG "
"LYCPRO-BACP-BTPARC "
"LYCPRO-BACP-BTPARC-TBORGO "
"LYCPRO-BACP-CULT "
"LYCPRO-BACP-CULT-BPRMES "
"LYCPRO-BACP-DEF "
"LYCPRO-BACP-DEF-BPPRV "
"LYCPRO-BACP-DISTRI-VCOCOM "
"LYCPRO-BACP-ENERG "
"LYCPRO-BACP-ENERG-BACPR0 "
"LYCPRO-BACP-ENV "
"LYCPRO-BACP-ENV-BPRPAY "
"LYCPRO-BACP-HOT-BPCUI "
"LYCPRO-BACP-INF-BACPR "
"LYCPRO-BACP-INF-TITRE "
"LYCPRO-BACP-MAINT-BACPR0 "
"LYCPRO-BACP-MAINT-BACPR4 "
"LYCPRO-BACP-MEC "
"LYCPRO-BACP-MEC-BPRPIN "
"LYCPRO-BACP-PUB-BMAGDDSV "
"LYCPRO-BACP-PUB-BMAGDGLD "
"LYCPRO-BACP-SANT-BACPR "
"LYCPRO-BACP-SANT-BPRSAPD "
"LYCPRO-BACP-SANT-BPRSAPS "
"LYCPRO-BACP-SANT-SPT "
"LYCPRO-BACP-TEXT-BPCOF "
"LYCPRO-BACP-TEXT-BPCOS "
"LYCPRO-BACP-TEXT-BPRVET "
"LYCPRO-BACP-TRAN-BACPR0 "
"LYCPRO-BACP-TRAN-BPRTRM "
"LYCPRO-CAP-BTP-CAPME "
"LYCPRO-CAP-BTP-ETAN "
"LYCPRO-CAP-BTP-MAC "
"LYCPRO-CAP-BTP-PEIN "
"LYCPRO-CAP-COP-DEC "
"LYCPRO-CAP-COP-SIG "
"LYCPRO-CAP-DEF "
"LYCPRO-CAP-DEF-AGS "
"LYCPRO-CAP-ELE-TITRE "
"LYCPRO-CAP-ENE "
"LYCPRO-CAP-ENE-ISTHAC "
"LYCPRO-CAP-HOT-CAPCO "
"LYCPRO-CAP-MET "
"LYCPRO-CAP-MET-CAPME0 "
"LYCPRO-CAP-MOD-CAPME0 "
"LYCPRO-CAP-MOD-VTA "
"LYCPRO-CAP-SANT-CAPAC "
"LYCPRO-CAP-SANT-MCAD "
"LYCPRO-CAP-SANT-MFC "
"LYCPRO-CAP-TRAN "
"LYCPRO-CAP-TRAN-CAPOP "
"LYCPRO-CAP-TRAN-LIV "
"LYCPRO-CAP-TRAN-ROMA "
"LYCPRO-COORD-TXTS "
"LYCPRO-FPC "
"LYCPRO-FPC-DISTRI "
"LYCPRO-FPC-DISTRI-BTSCC "
"LYCPRO-FPC-DISTRI-BTSMC "
"LYCPRO-FPC-DISTRI-BTSND "
"LYCPRO-FPC-HOT "
"LYCPRO-FPC-HOT-TITRE1 "
"LYCPRO-FPC-SANT "
"LYCPRO-FPC-SANT-BPJEP "
"LYCPRO-FPC-SANT-CAPAC "
"LYCPRO-FPC-SANT-CERTI "
"LYCPRO-FPC-SANT-CERTI0 "
"LYCPRO-FPC-SANT-DIPLO10 "
"LYCPRO-FPC-SANT-DIPLO11 "
"LYCPRO-FPC-SANT-DIPLO12 "
"LYCPRO-FPC-SANT-DIPLO2 "
"LYCPRO-FPC-SANT-DIPLO3 "
"LYCPRO-FPC-SANT-DIPLO5 "
"LYCPRO-FPC-SANT-DIPLO6 "
"LYCPRO-FPC-SANT-DIPLO7 "
"LYCPRO-FPC-SANT-DIPLO8 "
"LYCPRO-FPC-SANT-DIPLO9 "
"LYCPRO-FPC-SANT-DIRIG "
"LYCPRO-FPC-SANT-PREPA10 "
"LYCPRO-FPC-SANT-TITRE "
"LYCPRO-FPC-SANT-TITRE0 "
"LYCPRO-FPC-SANT-TITRE1 "
"LYCPRO-FPC-SANT-TITRE2 "
"LYCPRO-FPC-SANT-TITRE3 "
"LYCPRO-FPC-SANT-TITRE4 "
"LYCPRO-FPC-SANT-TITRE5 "
"LYCPRO-FPC-TXTS "
"LYCPRO-LANG-LV2-ALL "
"LYCPRO-LANG-LV2-HEB "
"LYCPRO-LANG-LV3 "
"LYCPRO-LANG-TXTS "
"LYCPRO-PRES-TUT "
"LYCPRO-SPEC-ACC-TXTS "
"LYCPRO-SPEC-PASS_MT "
"LYCPRO-SPEC-PREP "
"LYCPRO-SPEC-PSC1 "
"LYCPRO-SPEC-SCI "
"LYCPRO-SPEC-TXTS "
"LYCPRO-SPEC-TXTS43 "
"LYCPRO-TEXTC2_MT "
"PBAC-ACCU-TXTS53 "
"PBAC-BAC2-AGRI "
"PBAC-BAC2-AGRI-ANASTRENA "
"PBAC-BAC2-ART "
"PBAC-BAC2-ART-CERTI "
"PBAC-BAC2-CDV-ATCOM "
"PBAC-BAC2-CDV-GESTI "
"PBAC-BAC2-CDV-TITRE2 "
"PBAC-BAC2-CHI-BTSBIOC "
"PBAC-BAC2-CHI-BTSBIOT "
"PBAC-BAC2-CHI-BTSME "
"PBAC-BAC2-CHI-BTSME0 "
"PBAC-BAC2-CULT "
"PBAC-BAC2-CULT-BTSPHOT "
"PBAC-BAC2-ELEC "
"PBAC-BAC2-ELEC-BTSELEC "
"PBAC-BAC2-ENS "
"PBAC-BAC2-ENS-TPFOR "
"PBAC-BAC2-ENT-BTSMA0 "
"PBAC-BAC2-ENV "
"PBAC-BAC2-ENV-BTSAEAU "
"PBAC-BAC2-GADF-BTSCO0 "
"PBAC-BAC2-GADF-TITRE0 "
"PBAC-BAC2-GADF-TITRE1 "
"PBAC-BAC2-HOT-ASSIS "
"PBAC-BAC2-PUB-BTSER "
"PBAC-BAC2-PUB-BTSER0 "
"PBAC-BAC2-SASO-BTSDIE "
"PBAC-BAC2-SASO-BTSDTS "
"PBAC-BAC2-SASO-BTSESF "
"PBAC-BAC2-SASO-BTSOPT "
"PBAC-BAC2-SASO-BTSSASO "
"PBAC-BAC2-SASO-TITRE0 "
"PBAC-BAC2-TEXT-BTSMARQ "
"PBAC-BAC2-TEXT-BTSVET "
"PBAC-BAC2-TXTS "
"PBAC-BAC2-WEB-BTSINFR "
"PBAC-BAC2-WEB-BTSSLAM "
"PBAC-BAC2-WEB-CERTI "
"PBAC-BAC2-WEB-CERTI1 "
"PBAC-BAC2-WEB-TITRE "
"PBAC-BAC3-AGRI "
"PBAC-BAC3-AGRI-DIMA "
"PBAC-BAC3-ART "
"PBAC-BAC3-ART-DESIG0 "
"PBAC-BAC3-BAN "
"PBAC-BAC3-BAN-BACHE2 "
"PBAC-BAC3-BTP "
"PBAC-BAC3-BTP-CERTI0 "
"PBAC-BAC3-CDV-BACHE6 "
"PBAC-BAC3-CDV-BGB "
"PBAC-BAC3-CDV-BGMC "
"PBAC-BAC3-CDV-COMMU "
"PBAC-BAC3-CDV-LICEN2 "
"PBAC-BAC3-CDV-RESPO10 "
"PBAC-BAC3-CDV-RESPO13 "
"PBAC-BAC3-CDV-RESPO15 "
"PBAC-BAC3-CDV-RESPO19 "
"PBAC-BAC3-CDV-RESPO7 "
"PBAC-BAC3-CDV-RESPO8 "
"PBAC-BAC3-CDV-RESPO9 "
"PBAC-BAC3-CDV-TITRE4 "
"PBAC-BAC3-CULT "
"PBAC-BAC3-CULT-IHTM "
"PBAC-BAC3-GADF-BACHE "
"PBAC-BAC3-GADF-BACHE1 "
"PBAC-BAC3-GADF-CHARG "
"PBAC-BAC3-GADF-CHARG1 "
"PBAC-BAC3-GADF-DEESARH "
"PBAC-BAC3-GADF-LICEN12 "
"PBAC-BAC3-GADF-LP5 "
"PBAC-BAC3-GADF-RESPO0 "
"PBAC-BAC3-GADF-RESPO1 "
"PBAC-BAC3-GADF-RESPO2 "
"PBAC-BAC3-PUB-BACHE2 "
"PBAC-BAC3-PUB-BACHE7 "
"PBAC-BAC3-PUB-CERTI "
"PBAC-BAC3-PUB-DEES2 "
"PBAC-BAC3-PUB-DEESCOM "
"PBAC-BAC3-SASO-CESF "
"PBAC-BAC3-SASO-LICEN "
"PBAC-BAC3-WEB "
"PBAC-BAC3-WEB-BRCDSM "
"PBAC-BAC3-WEB-TITRE0 "
"PBAC-BAC3-WEB-TITRE2 "
"PBAC-BAC45-CDV-MANAG0 "
"PBAC-BAC45-CDV-MANAG1 "
"PBAC-BAC45-CDV-MANAG10 "
"PBAC-BAC45-CDV-MANAG11 "
"PBAC-BAC45-CDV-MANAG12 "
"PBAC-BAC45-CDV-MANAG14 "
"PBAC-BAC45-CDV-MANAG15 "
"PBAC-BAC45-CDV-MANAG2 "
"PBAC-BAC45-CDV-MANAG3 "
"PBAC-BAC45-CDV-MANAG4 "
"PBAC-BAC45-CDV-MANAG5 "
"PBAC-BAC45-CDV-MANAG9 "
"PBAC-BAC45-CDV-MASTE3 "
"PBAC-BAC45-CDV-MASTE7 "
"PBAC-BAC45-CDV-RESPO1 "
"PBAC-BAC45-ENS "
"PBAC-BAC45-ENS-ENS "
"PBAC-BAC45-GADF-EXPER "
"PBAC-BAC45-GADF-MANAG1 "
"PBAC-BAC45-GADF-MANAG2 "
"PBAC-BAC45-GADF-MASTE0 "
"PBAC-BAC45-GADF-MEMRH "
"PBAC-BAC45-INF "
"PBAC-BAC45-INF-MANAG0 "
"PBAC-BAC45-SPOR "
"PBAC-BAC45-SPOR-MANAG "
"PBAC-BAC45-TXTS "
"PBAC-FPC-DISTRI-BACPR "
"PBAC-FPC-DISTRI-BACPR0 "
"PBAC-FPC-DISTRI-GESTI "
"PBAC-FPC-TRAN "
"PBAC-FPC-TRAN-BACPR "
"PBAC-PREPA-CHI "
"PBAC-PREPA-CHI-CGPEMP "
"PBAC-PREPA-COM-CGPEECE "
"PBAC-PREPA-COM-CGPEECS "
"PBAC-PREPA-COM-CGPEECT "
"PBAC-PREPA-CUL "
"PBAC-PREPA-CUL-MANAA "
"PBAC-PREPA-GADF "
"PBAC-PREPA-GADF-PREPA "
"PBAC-PREPA-MAUT-CPATS "
"PBAC-PREPA-MAUT-CPGEMPSI "
"PBAC-PREPA-SASO "
"PBAC-PREPA-SASO-CEINF "
"PBAC-PRES-AUTR1_MT "
"PBAC-SPEC-CAMP "
"PBAC-SPEC-INTE "
"PBAC-TARIFS-INSC-BAC+4-5 "
]
]
SELECT i0_ . libelle AS libelle_0 , i0_ . libelle_mep AS libelle_mep_1 , i0_ . texte_defaut AS texte_defaut_2 , i0_ . onglet AS onglet_3 , i0_ . niveau AS niveau_4 , i0_ . formation AS formation_5 , i0_ . options AS options_6 , i0_ . libelle_web AS libelle_web_7 , i0_ . id AS id_8 , i0_ . maj AS maj_9 FROM items i0_ INNER JOIN items_insertion i1_ ON (i0_ . id = i1_ . pere ) WHERE i0_ . formation = 'oui' AND i0_ . niveau = 3 AND i0_ . id LIKE 'annuaire-enseignement-prive-%' AND i0_ . id IN ('LYC-LANG' , 'LYC-LANG-LV1' , 'LYC-LANG-LV1-ANG' , 'LYC-LANG-LV2' , 'LYC-LANG-LV2-ESP' , 'LYC-FORMA2021-SPEC' , 'PBAC-COORD' , 'PBAC-COORD-ADR' , 'PBAC-COORD-MAIL' , 'PBAC-COORD-TEL' , 'PBAC-COORD-WEB' , 'LYC-LANG-LV2-ITA' , 'ECOLE-COORD' , 'ECOLE-COORD-ADR' , 'ECOLE-COORD-MAIL' , 'ECOLE-COORD-TEL' , 'ECOLE-PRES' , 'ECOLE-CLA' , 'ECOLE-COORD-WEB' , 'ECOLE-CLA-PRIM' , 'COLL-COORD' , 'COLL-COORD-ADR' , 'COLL-COORD-MAIL' , 'COLL-COORD-TEL' , 'COLL-COORD-WEB' , 'COLL-LANG' , 'COLL-PRES' , 'COLL-LANG-LV1' , 'COLL-LANG-LV1-ANG' , 'COLL-LANG-LV2' , 'COLL-SPEC' , 'LYC-COORD' , 'LYC-COORD-ADR' , 'LYC-COORD-MAIL' , 'LYC-COORD-TEL' , 'LYC-COORD-WEB' , 'ECOLE-CLA-MAT' , 'LYC-PRES' , 'COLL-LANG-LV2-ESP' , 'COLL-SPEC-ART' , 'ECOLE-ACCU' , 'COLL-ACCU' , 'ECOLE-SPEC' , 'LYC-SPEC' , 'PBAC-PRES' , 'COLL-CLA' , 'COLL-SPEC-EDU' , 'COLL-SPEC-SORT' , 'ECOLE-ACCU-PERI' , 'LYC-FORMA2021-SPEC-SPECLANG' , 'COLL-CLA-DNB' , 'COLL-PRES-CHE' , 'LYC-LANG-LV2-ALL' , 'COLL-SPEC-ANC_MT' , 'COLL-SPEC-ANC_MT-LAT' , 'COLL-SPEC-ASPO' , 'ECOLE-PRES-NBE' , 'COLL-PRES-SCO' , 'ECOLE-ACCU-CANT' , 'ECOLE-PRES-SCO' , 'COLL-ACCU-CANT' , 'COLL-LANG-LV2-ITA' , 'COLL-PRES-NBE' , 'COLL-SPEC-CDI' , 'ECOLE-ACCU-ADM' , 'ECOLE-COORD-FAX' , 'ECOLE-SPEC-CDEC' , 'ECOLE-SPEC-INI' , 'LYC-ACCU' , 'LYC-FORMA2021-SPEC-SPECARTS' , 'PBAC-COORD-FAX' , 'COLL-SPEC-VOY' , 'LYC-PRES-CHE' , 'COLL-ACCU-PERI' , 'COLL-LANG-LV2-ALL' , 'ECOLE-PRES-CHE' , 'ECOLE-PRES-TUT' , 'ECOLE-SPEC-ART' , 'LYC-COORD-FAX' , 'LYC-SPEC-CDI' , 'LYCPRO-COORD' , 'LYCPRO-COORD-ADR' , 'LYCPRO-COORD-MAIL' , 'LYCPRO-COORD-TEL' , 'LYCPRO-COORD-WEB' , 'PBAC-BAC2-CDV' , 'COLL-ACCU-MIXT' , 'COLL-COORD-FAX' , 'COLL-PRES-NBC' , 'ECOLE-ACCU-MIXT' , 'LYC-FORMA2021-SPEC-SPECLLCA' , 'LYC-PRES-SCO' , 'COLL-PRES-NID' , 'COLL-PRES-TUT' , 'COLL-SPEC-ASSR1' , 'COLL-SPEC-ASSR2' , 'COLL-SPEC-PIX' , 'ECOLE-PRES-NBC' , 'ECOLE-SPEC-SORT' , 'ECOLE-SPEC-SPOR' , 'LYC-FORMA2021-SPEC-SPECPHY' , 'LYC-SPEC-ASPO' , 'LYC-SPEC-SLIN' , 'LYC-SPEC-VOY' , 'LYCPRO-PRES' , 'COLL-ACCU-ACCE' , 'COLL-ACCU-BOUR' , 'COLL-ACCU-EXT' , 'COLL-SPEC-CUL' , 'COLL-SPEC-REPA' , 'COLL-SPEC-SPOR' , 'COLL-SPEC-TICE' , 'ECOLE-PRES-NID' , 'ECOLE-SPEC-PERI' , 'LYC-SPEC-CUL' , 'PBAC-ACCU' , 'ECOLE-ACCU-ADM-3ANS' , 'ECOLE-ACCU-EXT' , 'ECOLE-ACCU-ORGA' , 'LYC-FORMA2021' , 'LYC-FORMA2021-SPEC-SPECHIST' , 'LYC-FORMA2021-SPEC-SPECMAT' , 'LYC-FORMA2021-SPEC-SPECSES' , 'LYC-FORMA2021-SPEC-SPECSVT' , 'LYC-PRES-NBE' , 'COLL-ACCU-ORGA' , 'COLL-SPEC-BDI' , 'COLL-SPEC-PAST' , 'ECOLE-SPEC-EDD' , 'ECOLE-SPEC-TICE' , 'LYC-LANG-LV2-ANG' , 'PBAC-BAC2-CDV-BTSMA' , 'COLL-CLA-CLA' , 'COLL-TARIFS' , 'COLL-TARIFS-INSC' , 'COLL-TARIFS-MODAL' , 'COLL-TARIFS-SCOLA' , 'ECOLE-ACCU-ORGA-S4J' , 'ECOLE-SPEC-EDU' , 'LYC-ACCU-ACCE' , 'LYC-ACCU-CANT' , 'LYC-ACCU-MIXT' , 'LYC-FORMA2021-GFACU' , 'LYC-SPEC-BDI' , 'LYC-SPEC-EDU' , 'COLL-ACCU-HAND_MT' , 'COLL-SPEC-ANC_MT-GRE' , 'COLL-SPEC-CDEC' , 'COLL-TARIFS-RCOMPL' , 'ECOLE-SPEC-REPA' , 'ECOLE-TARIFS' , 'LYC-ACCU-EXT' , 'LYC-FORMA2021-GFACU-GFACUMATC' , 'LYC-FORMA2021-SPEC-SPECHUM' , 'LYC-LANG-ANC_MT' , 'LYC-LANG-ANC_MT-LAT' , 'LYC-PRES-NBC' , 'LYC-PRES-NID' , 'LYC-SPEC-REPA' , 'LYCPRO-LANG' , 'LYCPRO-LANG-LV1' , 'LYCPRO-SPEC' , 'PBAC-PRES-CHE' , 'PBAC-PRES-SCO' , 'ECOLE-SPEC-ACC' , 'ECOLE-TARIFS-MODAL' , 'ECOLE-TARIFS-SCOLA-MATER' , 'ECOLE-TARIFS-SCOLA-PRIM' , 'LYC-ACCU-BOUR' , 'LYC-FORMA2021-GFACU-GFACUARTS' , 'LYC-FORMA2021-GFACU-GFACULANG' , 'LYC-FORMA2021-GFACU-GFACUMATE' , 'LYC-LANG-LV1-ALL' , 'LYC-PRES-TUT' , 'LYC-SPEC-PIX' , 'LYC-TARIFS' , 'LYC-TARIFS-MODAL' , 'LYC-TARIFS-SCOLA' , 'LYCPRO-ACCU' , 'LYCPRO-LANG-LV1-ANG' , 'PBAC-PRES-NBE' , 'COLL-CLA-CFG' , 'COLL-SPEC-ACC' , 'COLL-SPEC-BILA_MT' , 'COLL-SPEC-EDD' , 'COLL-SPEC-PSC1' , 'ECOLE-ACCU-ACCE' , 'ECOLE-PRES-DTRICE' , 'ECOLE-TARIFS-INSC' , 'ECOLE-TARIFS-RCOMPL' , 'LYC-LANG-CERT' , 'LYC-LANG-LV3' , 'LYC-SPEC-ART' , 'LYC-TARIFS-INSC' , 'LYCPRO-COORD-FAX' , 'PBAC-BAC2-GADF' , 'PBAC-BAC3-CDV' , 'PBAC-BAC3-GADF' , 'PBAC-PRES-NID' , 'PBAC-SPEC' , 'COLL-SPEC-B2I' , 'ECOLE-SPEC-B2I' , 'ECOLE-TARIFS-SCOLA-3EE' , 'LYC-ACCU-HAND_MT' , 'LYC-BACTEC-GADF' , 'LYC-TARIFS-RCOMPL' , 'LYCPRO-LANG-LV2' , 'PBAC-ACCU-MIXT' , 'PBAC-PRES-DTEUR' , 'COLL-SPEC-SLIN' , 'COLL-TARIFS-SCOLA-3EE' , 'ECOLE-ACCU-HOR_MT' , 'LYC-ACCU-CAF' , 'LYC-FORMA2021-GFACU-GFACULV3' , 'LYC-FORMA2021-SPEC-SPECNUM' , 'LYC-LANG-LV1-ESP' , 'LYC-LANG-LV3-ITA' , 'LYC-SPEC-EXP' , 'LYC-SPEC-SPOR' , 'LYC-SPEC-TICE' , 'LYCPRO-BACP-DISTRI' , 'LYCPRO-LANG-LV2-ESP' , 'LYCPRO-PRES-SCO' , 'PBAC-ACCU-ACCE' , 'PBAC-ACCU-HAND_MT' , 'PBAC-BAC45-GADF' , 'PBAC-TARIFS-INSC' , 'COLL-SPEC-EFF' , 'COLL-SPEC-JUM' , 'COLL-SPEC-PERI' , 'COLL-SPEC-RENF' , 'COLL-SPEC-SCI' , 'COLL-SPEC-STA_MT' , 'COLL-TARIFS-SCOLA-2EE' , 'ECOLE-SPEC-VOY' , 'ECOLE-TARIFS-SCOLA-2EE' , 'LYC-FORMA2021-GFACU-GFACUDROI' , 'LYC-FORMA2021-GFACU-GFACUEPS' , 'LYC-FORMA2021-SPEC-SPECING' , 'LYC-LANG-EUR' , 'LYC-SPEC-MULT' , 'LYC-TARIFS-SCOLA-2EE' , 'LYC-TARIFS-SCOLA-3EE' , 'LYCPRO-ACCU-MIXT' , 'LYCPRO-BACP-DISTRI-BACPR3' , 'LYCPRO-PRES-TEUR' , 'PBAC' , 'PBAC-TARIFS' , 'PBAC-TARIFS-MODAL' , 'PBAC-TARIFS-RCOMPL' , 'COLL-ACCU-ORGA-S5J' , 'COLL-LANG-LV1-ALL' , 'COLL-SPEC-ACC-ULIS' , 'COLL-SPEC-CFG' , 'COLL-SPEC-PARC' , 'COLL-SPEC-PREC' , 'COLL-SPEC-PRO' , 'COLL-SPEC-SPO_MT' , 'ECOLE-ACCU-HAND_MT' , 'ECOLE-SPEC-EFF' , 'ECOLE-SPEC-PAST' , 'LYC-ACCU-ORGA' , 'LYC-FORMA2021-SPEC-SPORT' , 'LYC-LANG-ANC_MT-GRE' , 'LYC-LANG-LV1-ITA' , 'LYC-PRES-DTEUR' , 'LYC-SPEC-2SGT' , 'LYC-SPEC-JUM' , 'LYC-SPEC-PREP' , 'LYC-SPEC-TPE' , 'LYC-SPEC-TXTS31' , 'LYCPRO-PRES-CHE' , 'LYCPRO-PRES-NBE' , 'PBAC-ACCU-BOUR' , 'PBAC-ACCU-CANT' , 'PBAC-BAC2-CDV-BTSNE' , 'PBAC-BAC2-GADF-BTSGE' , 'PBAC-BAC2-TRAN' , 'PBAC-BAC2-TRAN-BTSGE' , 'COLL-SPEC-EDUC' , 'COLL-SPEC-TXTS27' , 'ECOLE-SPEC-ACP' , 'LYC' , 'LYC-BACTEC-CDV' , 'LYC-BACTEC-CDV-STMG' , 'LYC-BACTEC-GADF-STMGRHC' , 'LYC-PRES-TXTS' , 'LYCPRO' , 'LYCPRO-BACP-DISTRI-BACPR2' , 'LYCPRO-BACP-GADF' , 'LYCPRO-BACP-GADF-BACPR1' , 'LYCPRO-PRES-NBC' , 'LYCPRO-PRES-TXTS' , 'LYCPRO-SPEC-PMET' , 'LYCPRO-TARIFS' , 'LYCPRO-TARIFS-INSC' , 'LYCPRO-TARIFS-MODAL' , 'LYCPRO-TARIFS-RCOMPL' , 'LYCPRO-TARIFS-SCOLA' , 'PBAC-ACCU-EXT' , 'PBAC-BAC2-BAI' , 'PBAC-BAC2-GADF-BTSCO' , 'PBAC-BAC45-CDV' , 'PBAC-LOGO' , 'PBAC-PRES-HCO' , 'PBAC-PRES-TUT' , 'PBAC-PRES-TXTS' , 'PBAC-TARIFS-INSC-BAC+2' , 'COLL-ACCU-ORGA-SDJ' , 'COLL-SPEC-EPI' , 'COLL-SPEC-MULT' , 'ECOLE-PRES-HCO' , 'ECOLE-SPEC-ACC-RA' , 'ECOLE-SPEC-ACC-ULIS' , 'ECOLE-SPEC-EDUC' , 'ECOLE-SPEC-TXTS' , 'INTERNAT-ACCSCO' , 'INTERNAT-ACTPER' , 'INTERNAT-COORD' , 'INTERNAT-COORD-ADR' , 'INTERNAT-COORD-MAIL' , 'INTERNAT-COORD-TEL' , 'INTERNAT-COORD-WEB' , 'INTERNAT-HEB' , 'INTERNAT-INFO' , 'INTERNAT-INFO-ACCES' , 'INTERNAT-INFO-CAPACC' , 'LYC-ACCU-INTA' , 'LYC-BACTEC' , 'LYC-BACTEC-GADF-STMGGF' , 'LYC-BACTEC-SASO' , 'LYC-BACTEC-SASO-ST2S' , 'LYC-BACTEC-TFACU' , 'LYC-SPEC-EFF' , 'LYC-SPEC-OPTE' , 'LYC-SPEC-PAST' , 'LYCPRO-ACCU-ACCE' , 'LYCPRO-ACCU-BOUR' , 'LYCPRO-ACCU-HAND_MT' , 'LYCPRO-BACP-TRAN' , 'LYCPRO-PRES-NID' , 'PBAC-ACCU-CAF' , 'PBAC-BAC2-SASO' , 'PBAC-SPEC-TXTS51' , 'COLL-ACCU-HORA_MT' , 'COLL-PRES-DTEUR' , 'COLL-SPEC-BIA' , 'COLL-SPEC-BIL_MT' , 'COLL-SPEC-CERT' , 'COLL-SPEC-CSPE_MT' , 'COLL-SPEC-OPTL' , 'COLL-SPEC-TXTS21' , 'COLL-SPEC-TXTS23' , 'ECOLE-PRES-DTEUR' , 'ECOLE-SPEC-ACC-ASH' , 'ECOLE-SPEC-ASSR' , 'ECOLE-SPEC-BIL_MT' , 'ECOLE-SPEC-ELANG' , 'ECOLE-SPEC-PREC' , 'ECOLE-SPEC-TXTS12' , 'INTERNAT-ACCSCO-ETSURV' , 'INTERNAT-ACCSCO-SOUSCO' , 'INTERNAT-ACTPER-ACTSPO' , 'INTERNAT-ACTPER-SOITHE' , 'INTERNAT-ACTPER-TXTS' , 'INTERNAT-HEB-CHAMB' , 'INTERNAT-INFO-INTSEM' , 'LYC-BACTEC-ELEC' , 'LYC-BACTEC-ELEC-STI2D' , 'LYC-BACTEC-ENEX' , 'LYC-BACTEC-ENEX-STI2D' , 'LYC-BACTEC-TFACU-ARTS' , 'LYC-LANG-BEUR' , 'LYC-LANG-TXTS' , 'LYC-LOGO' , 'LYC-PRES-HCO' , 'LYC-SPEC-B2I' , 'LYC-SPEC-PREC' , 'LYC-SPEC-SCI' , 'LYC-SPEC-TXTS' , 'LYCPRO-BACP-INF' , 'LYCPRO-BACP-TEXT' , 'LYCPRO-BACP-TRAN-BPRLOG' , 'LYCPRO-LOGO' , 'LYCPRO-PRES-HCO' , 'LYCPRO-PRESLIBRE-TXTS_IS' , 'LYCPRO-PRESLIBRE_IS' , 'LYCPRO-SPEC-ACC' , 'LYCPRO-SPEC-BDI' , 'LYCPRO-SPEC-CDI' , 'LYCPRO-SPEC-EDU' , 'LYCPRO-SPEC-PRE' , 'LYCPRO-SPEC-TXTS42' , 'LYCPRO-SPEC-VOY' , 'LYCPRO-TARIFS-SCOLA-2EE' , 'LYCPRO-TARIFS-SCOLA-3EE' , 'PBAC-ACCU-HEB' , 'PBAC-ACCU-INTA' , 'PBAC-BAC2-BAI-BTSAS' , 'PBAC-BAC2-WEB' , 'PBAC-BAC2-WEB-BTSCI' , 'PBAC-BAC2-WEB-BTSCI0' , 'PBAC-BAC3-PUB' , 'PBAC-PRES-DTRICE' , 'COLL-ACCU-INTA' , 'COLL-ACCU-ORGA-S4J' , 'COLL-PRES-AUTR1_MT' , 'COLL-PRES-DTRICE' , 'COLL-PRES-HCO' , 'COLL-PRES-TXTS' , 'COLL-SPEC-ACC-SEGPA' , 'COLL-SPEC-EUR' , 'COLL-SPEC-INI' , 'COLL-SPEC-TXTS' , 'ECOLE-ACCU-ADM-2ANS' , 'ECOLE-ACCU-ADM-2ANSD' , 'INTERNAT-ACCSCO-TXTS' , 'INTERNAT-PRES' , 'INTERNAT-PRES-TXTS' , 'INTERNAT-TARIFS' , 'INTERNAT-TARIFS-TXTS' , 'LYC-ACCU-HORA_MT' , 'LYC-BACTEC-CHI' , 'LYC-BACTEC-CHI-STLBIO' , 'LYC-BACTEC-MAUT' , 'LYC-BACTEC-MAUT-STI2D' , 'LYC-COORD-TXTS' , 'LYC-FORMA2021-GFACU-TXTS2021' , 'LYC-LANG-LV2-CHI' , 'LYC-LANG-LV3-ESP' , 'LYC-LANG-RENF' , 'LYC-SPEC-ACC' , 'LYC-SPEC-BIA' , 'LYC-SPEC-EDUC' , 'LYC-SPEC-EMPL' , 'LYC-SPEC-PERI' , 'LYC-SPEC-TXTS35' , 'LYCPRO-ACCU-APP' , 'LYCPRO-ACCU-CANT' , 'LYCPRO-ACCU-HORA_MT' , 'LYCPRO-ACCU-INTA' , 'LYCPRO-ACCU-ORGA' , 'LYCPRO-BACP-HOT' , 'LYCPRO-BACP-MAINT' , 'LYCPRO-BACP-SANT' , 'LYCPRO-BACP-TEXT-BPRCOS' , 'LYCPRO-CAP-COM' , 'LYCPRO-CAP-COM-CAPEQ' , 'LYCPRO-CAP-ELE' , 'LYCPRO-CAP-MOD' , 'LYCPRO-LANG-LV1-ESP' , 'LYCPRO-LANG-LV2-ANG' , 'LYCPRO-LANG-LV2-ITA' , 'LYCPRO-PRES-TRICE' , 'LYCPRO-SPEC-ACC-ULIS' , 'LYCPRO-SPEC-ASPO' , 'LYCPRO-SPEC-PIX' , 'LYCPRO-SPEC-SPOR' , 'PBAC-BAC2' , 'PBAC-BAC2-BAI-BTSPRI' , 'PBAC-BAC2-CHI' , 'PBAC-BAC2-ENT' , 'PBAC-BAC2-ENT-BTSMA' , 'PBAC-BAC2-GADF-BTSSU' , 'PBAC-BAC2-HOT' , 'PBAC-BAC2-PUB' , 'PBAC-BAC2-PUB-BTSCOM' , 'PBAC-BAC2-TXTS0' , 'PBAC-BAC3-GADF-DCG' , 'PBAC-BAC45' , 'PBAC-BAC45-GADF-DSCG' , 'PBAC-BAC45-GADF-MANAG' , 'PBAC-PREPA-COM' , 'PBAC-SPEC-ADMI' , 'PBAC-SPEC-ENTR' , 'PBAC-SPEC-IGEN' , 'PBAC-SPEC-TXTS' , 'PBAC-TARIFS-INSC-BAC+3' , 'COLL-ACCU-TXTS' , 'COLL-ACCU-TXTS26' , 'COLL-CLA-TXTS' , 'COLL-LANG-LV1-ARA' , 'COLL-LANG-LV2-CHI' , 'COLL-LANG-LV3' , 'COLL-LANG-LV3-ESP' , 'COLL-LANG-TXTS' , 'COLL-SPEC-FLE' , 'COLL-SPEC-OPTAS' , 'COLL-SPEC-PED' , 'ECOLE-ACCU-TXTS16' , 'ECOLE-CLA-TXTS' , 'ECOLE-SPEC-ACC-ASED' , 'ECOLE-SPEC-TXTS11' , 'ECOLE-SPEC-TXTS13' , 'ECOLE-SPEC-TXTS14' , 'ECOLE-SPEC-TXTS15' , 'INTERNAT-ACTPER-SORTEDU' , 'INTERNAT-COORD-FAX' , 'INTERNAT-EQCOMP' , 'INTERNAT-EQCOMP-SALETU' , 'INTERNAT-EQCOMP-TXTS' , 'INTERNAT-INFO-INTPERM' , 'INTERNAT-INFO-NIVENSACC' , 'INTERNAT-INFO-OUVPVAC' , 'LYC-ACCU-TXTS36' , 'LYC-BACTEC-CHI-STLPHY' , 'LYC-BACTEC-TFACU-EPS' , 'LYC-BACTEC-WEB' , 'LYC-BACTEC-WEB-STMGSIG' , 'LYC-LANG-BILA_MT' , 'LYC-LANG-BIL_MT' , 'LYC-LANG-FLE' , 'LYC-LANG-LV2-HEB' , 'LYC-LANG-LV3-CHI' , 'LYC-LANG-LV3-RUS' , 'LYC-LANG-REG_MT' , 'LYC-PRES-DTRICE' , 'LYC-SPEC-ACC-ULIS' , 'LYC-SPEC-PASS_MT' , 'LYC-SPEC-PSC1' , 'LYC-SPEC-SPO_MT' , 'LYC-SPEC-TXTS36' , 'LYCPRO-ACCU-EXT' , 'LYCPRO-BACP-DISTRI-BACPR' , 'LYCPRO-BACP-ELEC' , 'LYCPRO-BACP-ELEC-BACPR1' , 'LYCPRO-BACP-HOT-BPRCUI' , 'LYCPRO-BACP-HOT-BPRRES' , 'LYCPRO-BACP-INF-BACPR0' , 'LYCPRO-BACP-MAINT-BPREQI' , 'LYCPRO-BACP-PUB' , 'LYCPRO-BACP-PUB-BPRCOV' , 'LYCPRO-CAP-BOI' , 'LYCPRO-CAP-BOI-MENF' , 'LYCPRO-CAP-BTP' , 'LYCPRO-CAP-COP' , 'LYCPRO-CAP-ELE-CAPEL' , 'LYCPRO-CAP-HOT' , 'LYCPRO-CAP-HOT-CUI' , 'LYCPRO-CAP-MOD-EST' , 'LYCPRO-CAP-SANT' , 'LYCPRO-SPEC-B2I' , 'LYCPRO-SPEC-CUL' , 'LYCPRO-SPEC-EDUC' , 'LYCPRO-SPEC-EMPL' , 'LYCPRO-SPEC-MULT' , 'LYCPRO-SPEC-PAST' , 'LYCPRO-SPEC-SLIN' , 'LYCPRO-SPEC-SPO_MT' , 'LYCPRO-SPEC-STA_MT' , 'LYCPRO-SPEC-TICE' , 'LYCPRO-SPEC-TXTS47' , 'LYCPRO-SPEC-TXTS48' , 'LYCPRO-TEXTC1_MT' , 'PBAC-BAC2-CDV-BTSCO' , 'PBAC-BAC2-CDV-BTSCOMI' , 'PBAC-BAC2-CHI-BTSABM' , 'PBAC-BAC2-GADF-TITRE' , 'PBAC-BAC2-GADF-TITRE6' , 'PBAC-BAC2-HOT-BTSMA' , 'PBAC-BAC2-HOT-BTSMA0' , 'PBAC-BAC2-SPOR' , 'PBAC-BAC2-SPOR-BTSTOU' , 'PBAC-BAC2-TEXT' , 'PBAC-BAC3' , 'PBAC-BAC3-CDV-BRESDEVC' , 'PBAC-BAC3-CDV-DEESMA' , 'PBAC-BAC3-CDV-RESPO0' , 'PBAC-BAC3-CDV-RESPO3' , 'PBAC-BAC3-GADF-CERTI0' , 'PBAC-BAC3-GADF-CHARG0' , 'PBAC-BAC3-GADF-CONTR' , 'PBAC-BAC3-SASO' , 'PBAC-BAC3-TXTS0' , 'PBAC-BAC45-CDV-MANAG' , 'PBAC-BAC45-GADF-MANAG0' , 'PBAC-BAC45-PUB' , 'PBAC-BAC45-PUB-MANAG' , 'PBAC-BAC45-TXTS0' , 'PBAC-FPC-DISTRI' , 'PBAC-PREPA-MAUT' , 'PBAC-SPEC-TXTS52' , 'PBAC-TARIFS-INSC-PREPA' , 'PBAC-TEXTC1_MT' , 'COLL' , 'COLL-COORD-TXTS' , 'COLL-LANG-LV1-CHI' , 'COLL-LANG-LV1-ESP' , 'COLL-LANG-LV1-ITA' , 'COLL-LANG-LV1-NEE' , 'COLL-LANG-LV1-RUS' , 'COLL-LANG-LV2-ANG' , 'COLL-LANG-LV2-ARA' , 'COLL-LANG-LV2-HEB' , 'COLL-LANG-LV2-JAP' , 'COLL-LANG-LV2-NEE' , 'COLL-LANG-LV2-RUS' , 'COLL-LANG-LV3-CHI' , 'COLL-LANG-LV3-ITA' , 'COLL-SPEC-ALTE' , 'COLL-SPEC-ANC_MT-TXTS' , 'COLL-SPEC-PMET' , 'COLL-SPEC-REG_MT' , 'COLL-SPEC-REG_MT-PRO' , 'COLL-SPEC-TXTS25' , 'COLL-SPEC-TXTS28' , 'COLL-SPEC-TXTS29' , 'COLL-SPEC-TXTS32' , 'ECOLE' , 'ECOLE-ACCU-INTA' , 'ECOLE-ACCU-ORGA-SDJ' , 'ECOLE-ACCU-TXTS18' , 'ECOLE-COORD-TXTS' , 'ECOLE-LOGO' , 'ECOLE-PRES-TXTS' , 'ECOLE-SPEC-ACC-MAI' , 'ECOLE-SPEC-ACC-RAS' , 'ECOLE-SPEC-ASPO' , 'ECOLE-SPEC-PED' , 'ECOLE-SPEC-PED-FRE' , 'ECOLE-SPEC-PED-MON' , 'ECOLE-SPEC-PED-TXTS' , 'ECOLE-SPEC-PIX' , 'ECOLE-SPEC-SLIN' , 'ECOLE-SPEC-TXTS16' , 'INTERNAT' , 'INTERNAT-ACCSCO-SOUSPEC' , 'INTERNAT-EQCOMP-EQSPO' , 'INTERNAT-EQCOMP-FOYER' , 'INTERNAT-EQCOMP-SALINFO' , 'INTERNAT-HEB-TXTS' , 'INTERNAT-INFO-ENC' , 'INTERNAT-INFO-TXTS' , 'INTERNAT-LOGO' , 'INTERNAT-PHOTO' , 'LYC-ACCU-TXTS' , 'LYC-BACTEC-CHI-BACST4' , 'LYC-BACTEC-GADF-BACST' , 'LYC-BACTEC-PUB' , 'LYC-BACTEC-PUB-STD2A' , 'LYC-FORMA2021-SPEC-SPECECO' , 'LYC-LANG-LSF' , 'LYC-LANG-LV1-ARA' , 'LYC-LANG-LV1-CHI' , 'LYC-LANG-LV1-HEB' , 'LYC-LANG-LV1-NEE' , 'LYC-LANG-LV1-RUS' , 'LYC-LANG-LV2-ARA' , 'LYC-LANG-LV2-JAP' , 'LYC-LANG-LV2-NEE' , 'LYC-LANG-LV2-RUS' , 'LYC-LANG-LV3-ALL' , 'LYC-LANG-LV3-TXTS' , 'LYC-LANG-OPTL' , 'LYC-LANG-REG_MT-COR' , 'LYC-LANG-REG_MT-PRO' , 'LYC-PRES-AUTR1_MT' , 'LYC-SPEC-ACC-TXTS' , 'LYC-SPEC-OPTAS' , 'LYC-SPEC-PED' , 'LYC-SPEC-TXTS32' , 'LYC-SPEC-TXTS37' , 'LYC-SPEC-TXTS40' , 'LYC-TEXTC1_MT' , 'LYCPRO-ACCU-CAF' , 'LYCPRO-ACCU-TXTS' , 'LYCPRO-ACCU-TXTS47' , 'LYCPRO-BACP-AGRI' , 'LYCPRO-BACP-AGRI-BACPR7' , 'LYCPRO-BACP-BOI' , 'LYCPRO-BACP-BOI-BPMAG' , 'LYCPRO-BACP-BTPARC' , 'LYCPRO-BACP-BTPARC-TBORGO' , 'LYCPRO-BACP-CULT' , 'LYCPRO-BACP-CULT-BPRMES' , 'LYCPRO-BACP-DEF' , 'LYCPRO-BACP-DEF-BPPRV' , 'LYCPRO-BACP-DISTRI-VCOCOM' , 'LYCPRO-BACP-ENERG' , 'LYCPRO-BACP-ENERG-BACPR0' , 'LYCPRO-BACP-ENV' , 'LYCPRO-BACP-ENV-BPRPAY' , 'LYCPRO-BACP-HOT-BPCUI' , 'LYCPRO-BACP-INF-BACPR' , 'LYCPRO-BACP-INF-TITRE' , 'LYCPRO-BACP-MAINT-BACPR0' , 'LYCPRO-BACP-MAINT-BACPR4' , 'LYCPRO-BACP-MEC' , 'LYCPRO-BACP-MEC-BPRPIN' , 'LYCPRO-BACP-PUB-BMAGDDSV' , 'LYCPRO-BACP-PUB-BMAGDGLD' , 'LYCPRO-BACP-SANT-BACPR' , 'LYCPRO-BACP-SANT-BPRSAPD' , 'LYCPRO-BACP-SANT-BPRSAPS' , 'LYCPRO-BACP-SANT-SPT' , 'LYCPRO-BACP-TEXT-BPCOF' , 'LYCPRO-BACP-TEXT-BPCOS' , 'LYCPRO-BACP-TEXT-BPRVET' , 'LYCPRO-BACP-TRAN-BACPR0' , 'LYCPRO-BACP-TRAN-BPRTRM' , 'LYCPRO-CAP-BTP-CAPME' , 'LYCPRO-CAP-BTP-ETAN' , 'LYCPRO-CAP-BTP-MAC' , 'LYCPRO-CAP-BTP-PEIN' , 'LYCPRO-CAP-COP-DEC' , 'LYCPRO-CAP-COP-SIG' , 'LYCPRO-CAP-DEF' , 'LYCPRO-CAP-DEF-AGS' , 'LYCPRO-CAP-ELE-TITRE' , 'LYCPRO-CAP-ENE' , 'LYCPRO-CAP-ENE-ISTHAC' , 'LYCPRO-CAP-HOT-CAPCO' , 'LYCPRO-CAP-MET' , 'LYCPRO-CAP-MET-CAPME0' , 'LYCPRO-CAP-MOD-CAPME0' , 'LYCPRO-CAP-MOD-VTA' , 'LYCPRO-CAP-SANT-CAPAC' , 'LYCPRO-CAP-SANT-MCAD' , 'LYCPRO-CAP-SANT-MFC' , 'LYCPRO-CAP-TRAN' , 'LYCPRO-CAP-TRAN-CAPOP' , 'LYCPRO-CAP-TRAN-LIV' , 'LYCPRO-CAP-TRAN-ROMA' , 'LYCPRO-COORD-TXTS' , 'LYCPRO-FPC' , 'LYCPRO-FPC-DISTRI' , 'LYCPRO-FPC-DISTRI-BTSCC' , 'LYCPRO-FPC-DISTRI-BTSMC' , 'LYCPRO-FPC-DISTRI-BTSND' , 'LYCPRO-FPC-HOT' , 'LYCPRO-FPC-HOT-TITRE1' , 'LYCPRO-FPC-SANT' , 'LYCPRO-FPC-SANT-BPJEP' , 'LYCPRO-FPC-SANT-CAPAC' , 'LYCPRO-FPC-SANT-CERTI' , 'LYCPRO-FPC-SANT-CERTI0' , 'LYCPRO-FPC-SANT-DIPLO10' , 'LYCPRO-FPC-SANT-DIPLO11' , 'LYCPRO-FPC-SANT-DIPLO12' , 'LYCPRO-FPC-SANT-DIPLO2' , 'LYCPRO-FPC-SANT-DIPLO3' , 'LYCPRO-FPC-SANT-DIPLO5' , 'LYCPRO-FPC-SANT-DIPLO6' , 'LYCPRO-FPC-SANT-DIPLO7' , 'LYCPRO-FPC-SANT-DIPLO8' , 'LYCPRO-FPC-SANT-DIPLO9' , 'LYCPRO-FPC-SANT-DIRIG' , 'LYCPRO-FPC-SANT-PREPA10' , 'LYCPRO-FPC-SANT-TITRE' , 'LYCPRO-FPC-SANT-TITRE0' , 'LYCPRO-FPC-SANT-TITRE1' , 'LYCPRO-FPC-SANT-TITRE2' , 'LYCPRO-FPC-SANT-TITRE3' , 'LYCPRO-FPC-SANT-TITRE4' , 'LYCPRO-FPC-SANT-TITRE5' , 'LYCPRO-FPC-TXTS' , 'LYCPRO-LANG-LV2-ALL' , 'LYCPRO-LANG-LV2-HEB' , 'LYCPRO-LANG-LV3' , 'LYCPRO-LANG-TXTS' , 'LYCPRO-PRES-TUT' , 'LYCPRO-SPEC-ACC-TXTS' , 'LYCPRO-SPEC-PASS_MT' , 'LYCPRO-SPEC-PREP' , 'LYCPRO-SPEC-PSC1' , 'LYCPRO-SPEC-SCI' , 'LYCPRO-SPEC-TXTS' , 'LYCPRO-SPEC-TXTS43' , 'LYCPRO-TEXTC2_MT' , 'PBAC-ACCU-TXTS53' , 'PBAC-BAC2-AGRI' , 'PBAC-BAC2-AGRI-ANASTRENA' , 'PBAC-BAC2-ART' , 'PBAC-BAC2-ART-CERTI' , 'PBAC-BAC2-CDV-ATCOM' , 'PBAC-BAC2-CDV-GESTI' , 'PBAC-BAC2-CDV-TITRE2' , 'PBAC-BAC2-CHI-BTSBIOC' , 'PBAC-BAC2-CHI-BTSBIOT' , 'PBAC-BAC2-CHI-BTSME' , 'PBAC-BAC2-CHI-BTSME0' , 'PBAC-BAC2-CULT' , 'PBAC-BAC2-CULT-BTSPHOT' , 'PBAC-BAC2-ELEC' , 'PBAC-BAC2-ELEC-BTSELEC' , 'PBAC-BAC2-ENS' , 'PBAC-BAC2-ENS-TPFOR' , 'PBAC-BAC2-ENT-BTSMA0' , 'PBAC-BAC2-ENV' , 'PBAC-BAC2-ENV-BTSAEAU' , 'PBAC-BAC2-GADF-BTSCO0' , 'PBAC-BAC2-GADF-TITRE0' , 'PBAC-BAC2-GADF-TITRE1' , 'PBAC-BAC2-HOT-ASSIS' , 'PBAC-BAC2-PUB-BTSER' , 'PBAC-BAC2-PUB-BTSER0' , 'PBAC-BAC2-SASO-BTSDIE' , 'PBAC-BAC2-SASO-BTSDTS' , 'PBAC-BAC2-SASO-BTSESF' , 'PBAC-BAC2-SASO-BTSOPT' , 'PBAC-BAC2-SASO-BTSSASO' , 'PBAC-BAC2-SASO-TITRE0' , 'PBAC-BAC2-TEXT-BTSMARQ' , 'PBAC-BAC2-TEXT-BTSVET' , 'PBAC-BAC2-TXTS' , 'PBAC-BAC2-WEB-BTSINFR' , 'PBAC-BAC2-WEB-BTSSLAM' , 'PBAC-BAC2-WEB-CERTI' , 'PBAC-BAC2-WEB-CERTI1' , 'PBAC-BAC2-WEB-TITRE' , 'PBAC-BAC3-AGRI' , 'PBAC-BAC3-AGRI-DIMA' , 'PBAC-BAC3-ART' , 'PBAC-BAC3-ART-DESIG0' , 'PBAC-BAC3-BAN' , 'PBAC-BAC3-BAN-BACHE2' , 'PBAC-BAC3-BTP' , 'PBAC-BAC3-BTP-CERTI0' , 'PBAC-BAC3-CDV-BACHE6' , 'PBAC-BAC3-CDV-BGB' , 'PBAC-BAC3-CDV-BGMC' , 'PBAC-BAC3-CDV-COMMU' , 'PBAC-BAC3-CDV-LICEN2' , 'PBAC-BAC3-CDV-RESPO10' , 'PBAC-BAC3-CDV-RESPO13' , 'PBAC-BAC3-CDV-RESPO15' , 'PBAC-BAC3-CDV-RESPO19' , 'PBAC-BAC3-CDV-RESPO7' , 'PBAC-BAC3-CDV-RESPO8' , 'PBAC-BAC3-CDV-RESPO9' , 'PBAC-BAC3-CDV-TITRE4' , 'PBAC-BAC3-CULT' , 'PBAC-BAC3-CULT-IHTM' , 'PBAC-BAC3-GADF-BACHE' , 'PBAC-BAC3-GADF-BACHE1' , 'PBAC-BAC3-GADF-CHARG' , 'PBAC-BAC3-GADF-CHARG1' , 'PBAC-BAC3-GADF-DEESARH' , 'PBAC-BAC3-GADF-LICEN12' , 'PBAC-BAC3-GADF-LP5' , 'PBAC-BAC3-GADF-RESPO0' , 'PBAC-BAC3-GADF-RESPO1' , 'PBAC-BAC3-GADF-RESPO2' , 'PBAC-BAC3-PUB-BACHE2' , 'PBAC-BAC3-PUB-BACHE7' , 'PBAC-BAC3-PUB-CERTI' , 'PBAC-BAC3-PUB-DEES2' , 'PBAC-BAC3-PUB-DEESCOM' , 'PBAC-BAC3-SASO-CESF' , 'PBAC-BAC3-SASO-LICEN' , 'PBAC-BAC3-WEB' , 'PBAC-BAC3-WEB-BRCDSM' , 'PBAC-BAC3-WEB-TITRE0' , 'PBAC-BAC3-WEB-TITRE2' , 'PBAC-BAC45-CDV-MANAG0' , 'PBAC-BAC45-CDV-MANAG1' , 'PBAC-BAC45-CDV-MANAG10' , 'PBAC-BAC45-CDV-MANAG11' , 'PBAC-BAC45-CDV-MANAG12' , 'PBAC-BAC45-CDV-MANAG14' , 'PBAC-BAC45-CDV-MANAG15' , 'PBAC-BAC45-CDV-MANAG2' , 'PBAC-BAC45-CDV-MANAG3' , 'PBAC-BAC45-CDV-MANAG4' , 'PBAC-BAC45-CDV-MANAG5' , 'PBAC-BAC45-CDV-MANAG9' , 'PBAC-BAC45-CDV-MASTE3' , 'PBAC-BAC45-CDV-MASTE7' , 'PBAC-BAC45-CDV-RESPO1' , 'PBAC-BAC45-ENS' , 'PBAC-BAC45-ENS-ENS' , 'PBAC-BAC45-GADF-EXPER' , 'PBAC-BAC45-GADF-MANAG1' , 'PBAC-BAC45-GADF-MANAG2' , 'PBAC-BAC45-GADF-MASTE0' , 'PBAC-BAC45-GADF-MEMRH' , 'PBAC-BAC45-INF' , 'PBAC-BAC45-INF-MANAG0' , 'PBAC-BAC45-SPOR' , 'PBAC-BAC45-SPOR-MANAG' , 'PBAC-BAC45-TXTS' , 'PBAC-FPC-DISTRI-BACPR' , 'PBAC-FPC-DISTRI-BACPR0' , 'PBAC-FPC-DISTRI-GESTI' , 'PBAC-FPC-TRAN' , 'PBAC-FPC-TRAN-BACPR' , 'PBAC-PREPA-CHI' , 'PBAC-PREPA-CHI-CGPEMP' , 'PBAC-PREPA-COM-CGPEECE' , 'PBAC-PREPA-COM-CGPEECS' , 'PBAC-PREPA-COM-CGPEECT' , 'PBAC-PREPA-CUL' , 'PBAC-PREPA-CUL-MANAA' , 'PBAC-PREPA-GADF' , 'PBAC-PREPA-GADF-PREPA' , 'PBAC-PREPA-MAUT-CPATS' , 'PBAC-PREPA-MAUT-CPGEMPSI' , 'PBAC-PREPA-SASO' , 'PBAC-PREPA-SASO-CEINF' , 'PBAC-PRES-AUTR1_MT' , 'PBAC-SPEC-CAMP' , 'PBAC-SPEC-INTE' , 'PBAC-TARIFS-INSC-BAC+4-5' ) GROUP BY i0_ . id ORDER BY i0_ . libelle ASC ;
Copy
9
3.41 ms
SELECT i0_ . libelle AS libelle_0 , i0_ . libelle_mep AS libelle_mep_1 , i0_ . texte_defaut AS texte_defaut_2 , i0_ . onglet AS onglet_3 , i0_ . niveau AS niveau_4 , i0_ . formation AS formation_5 , i0_ . options AS options_6 , i0_ . libelle_web AS libelle_web_7 , i0_ . id AS id_8 , i0_ . maj AS maj_9 FROM items i0_ WHERE i0_ . niveau = 4 AND i0_ . id LIKE ? AND i0_ . id IN (? ) ORDER BY i0_ . libelle ASC
Parameters :
[
"LYC-FORMA2021-SPEC-% "
[
"LYC-FORMA2021-SPEC-SPECLANG "
"LYC-FORMA2021-SPEC-SPECARTS "
"LYC-FORMA2021-SPEC-SPECLLCA "
"LYC-FORMA2021-SPEC-SPECPHY "
"LYC-FORMA2021-SPEC-SPECHIST "
"LYC-FORMA2021-SPEC-SPECMAT "
"LYC-FORMA2021-SPEC-SPECSES "
"LYC-FORMA2021-SPEC-SPECSVT "
"LYC-FORMA2021-SPEC-SPECHUM "
"LYC-FORMA2021-SPEC-SPECNUM "
"LYC-FORMA2021-SPEC-SPECING "
"LYC-FORMA2021-SPEC-SPORT "
"LYC-FORMA2021-SPEC-SPECECO "
]
]
SELECT i0_ . libelle AS libelle_0 , i0_ . libelle_mep AS libelle_mep_1 , i0_ . texte_defaut AS texte_defaut_2 , i0_ . onglet AS onglet_3 , i0_ . niveau AS niveau_4 , i0_ . formation AS formation_5 , i0_ . options AS options_6 , i0_ . libelle_web AS libelle_web_7 , i0_ . id AS id_8 , i0_ . maj AS maj_9 FROM items i0_ WHERE i0_ . niveau = 4 AND i0_ . id LIKE 'LYC-FORMA2021-SPEC-%' AND i0_ . id IN ('LYC-FORMA2021-SPEC-SPECLANG' , 'LYC-FORMA2021-SPEC-SPECARTS' , 'LYC-FORMA2021-SPEC-SPECLLCA' , 'LYC-FORMA2021-SPEC-SPECPHY' , 'LYC-FORMA2021-SPEC-SPECHIST' , 'LYC-FORMA2021-SPEC-SPECMAT' , 'LYC-FORMA2021-SPEC-SPECSES' , 'LYC-FORMA2021-SPEC-SPECSVT' , 'LYC-FORMA2021-SPEC-SPECHUM' , 'LYC-FORMA2021-SPEC-SPECNUM' , 'LYC-FORMA2021-SPEC-SPECING' , 'LYC-FORMA2021-SPEC-SPORT' , 'LYC-FORMA2021-SPEC-SPECECO' ) ORDER BY i0_ . libelle ASC ;
Copy
10
0.69 ms
SELECT s0_ . id AS id_0 , s0_ . formation AS formation_1 , s0_ . secteur AS secteur_2 , s0_ . diplome AS diplome_3 , s0_ . titre_national AS titre_national_4 , s0_ . texte_national AS texte_national_5 , s0_ . titre_regional AS titre_regional_6 , s0_ . texte_regional AS texte_regional_7 , s0_ . titre_departemental AS titre_departemental_8 , s0_ . texte_departemental AS texte_departemental_9 , s0_ . titre_ville AS titre_ville_10 , s0_ . texte_ville AS texte_ville_11 FROM seo_texte_referencement_diplome s0_ WHERE s0_ . formation = ? AND s0_ . diplome IS NULL AND s0_ . secteur IS NULL
Parameters :
[
"annuaire-enseignement-prive "
]
SELECT s0_ . id AS id_0 , s0_ . formation AS formation_1 , s0_ . secteur AS secteur_2 , s0_ . diplome AS diplome_3 , s0_ . titre_national AS titre_national_4 , s0_ . texte_national AS texte_national_5 , s0_ . titre_regional AS titre_regional_6 , s0_ . texte_regional AS texte_regional_7 , s0_ . titre_departemental AS titre_departemental_8 , s0_ . texte_departemental AS texte_departemental_9 , s0_ . titre_ville AS titre_ville_10 , s0_ . texte_ville AS texte_ville_11 FROM seo_texte_referencement_diplome s0_ WHERE s0_ . formation = 'annuaire-enseignement-prive' AND s0_ . diplome IS NULL AND s0_ . secteur IS NULL ;
Copy
11
0.89 ms
SELECT z0_ . zone AS zone_0 , z0_ . id AS id_1 , z0_ . maj AS maj_2 , e1_ . type AS type_3 , e1_ . nombre_eleves AS nombre_eleves_4 , e1_ . url AS url_5 , e1_ . video AS video_6 , e1_ . mots_cles AS mots_cles_7 , e1_ . denomination AS denomination_8 , e1_ . denomination_sigle AS denomination_sigle_9 , e1_ . denomination_extension AS denomination_extension_10 , e1_ . denomination_abregee AS denomination_abregee_11 , e1_ . droit_page_web AS droit_page_web_12 , e1_ . droit_actualite AS droit_actualite_13 , e1_ . adresse1 AS adresse1_14 , e1_ . adresse2 AS adresse2_15 , e1_ . adresse3 AS adresse3_16 , e1_ . code_postal AS code_postal_17 , e1_ . cedex AS cedex_18 , e1_ . latitude AS latitude_19 , e1_ . longitude AS longitude_20 , e1_ . telephone_principal AS telephone_principal_21 , e1_ . fax AS fax_22 , e1_ . email_principal AS email_principal_23 , e1_ . logo_liste AS logo_liste_24 , e1_ . logo_fiche AS logo_fiche_25 , e1_ . diaporama_actif AS diaporama_actif_26 , e1_ . images_diaporama AS images_diaporama_27 , e1_ . participant AS participant_28 , e1_ . catholique AS catholique_29 , e1_ . age_admission AS age_admission_30 , e1_ . actif AS actif_31 , e1_ . internat AS internat_32 , e1_ . has_internat AS has_internat_33 , e1_ . types_internat AS types_internat_34 , e1_ . sous_contrat AS sous_contrat_35 , e1_ . alternance AS alternance_36 , e1_ . type_client AS type_client_37 , e1_ . bloque_txt_ref AS bloque_txt_ref_38 , e1_ . facebook AS facebook_39 , e1_ . bloque_bac2021 AS bloque_bac2021_40 , e1_ . presence_web AS presence_web_41 , e1_ . video_plus AS video_plus_42 , e1_ . diapo_plus AS diapo_plus_43 , e1_ . jpo_plus AS jpo_plus_44 , e1_ . doc_plus AS doc_plus_45 , e1_ . diplome_plus AS diplome_plus_46 , e1_ . refus AS refus_47 , e1_ . path AS path_48 , e1_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_49 , e1_ . lva AS lva_50 , e1_ . lvb AS lvb_51 , e1_ . numero_administratif_uai AS numero_administratif_uai_52 , e1_ . siret AS siret_53 , e1_ . chiffres AS chiffres_54 , e1_ . id AS id_55 , e1_ . maj AS maj_56 , t2_ . actif AS actif_57 , t2_ . contenu AS contenu_58 , t2_ . id AS id_59 , v3_ . slug AS slug_60 , v3_ . libelle AS libelle_61 , v3_ . code_postal AS code_postal_62 , v3_ . email_delegue AS email_delegue_63 , v3_ . onglets AS onglets_64 , v3_ . id AS id_65 , v3_ . maj AS maj_66 , v4_ . latitude AS latitude_67 , v4_ . longitude AS longitude_68 , v4_ . id AS id_69 , z0_ . etablissement_id AS etablissement_id_70 , e1_ . gestionnaire_id AS gestionnaire_id_71 , e1_ . ville_id AS ville_id_72 , e1_ . categorie_primaire_id AS categorie_primaire_id_73 , e1_ . region_id AS region_id_74 , e1_ . departement_id AS departement_id_75 , e1_ . categorie_organisme_id AS categorie_organisme_id_76 , e1_ . rubrique AS rubrique_77 , e1_ . internat2_id AS internat2_id_78 , e1_ . etablissement_lie_id AS etablissement_lie_id_79 , e1_ . logo_id AS logo_id_80 , e1_ . diapo_principal_id AS diapo_principal_id_81 , t2_ . etablissement_id AS etablissement_id_82 , t2_ . template_id AS template_id_83 , v3_ . departement_id AS departement_id_84 , v4_ . ville_id AS ville_id_85 FROM zones_internat z0_ LEFT JOIN etablissement e1_ ON z0_ . etablissement_id = e1_ . id LEFT JOIN texte_referencement t2_ ON e1_ . id = t2_ . etablissement_id LEFT JOIN ville v3_ ON e1_ . ville_id = v3_ . id LEFT JOIN ville_coordonnees v4_ ON v3_ . id = v4_ . ville_id WHERE z0_ . zone = ? GROUP BY z0_ . etablissement_id ORDER BY z0_ . id ASC
SELECT
z0_ . zone AS zone_0 ,
z0_ . id AS id_1 ,
z0_ . maj AS maj_2 ,
e1_ . type AS type_3 ,
e1_ . nombre_eleves AS nombre_eleves_4 ,
e1_ . url AS url_5 ,
e1_ . video AS video_6 ,
e1_ . mots_cles AS mots_cles_7 ,
e1_ . denomination AS denomination_8 ,
e1_ . denomination_sigle AS denomination_sigle_9 ,
e1_ . denomination_extension AS denomination_extension_10 ,
e1_ . denomination_abregee AS denomination_abregee_11 ,
e1_ . droit_page_web AS droit_page_web_12 ,
e1_ . droit_actualite AS droit_actualite_13 ,
e1_ . adresse1 AS adresse1_14 ,
e1_ . adresse2 AS adresse2_15 ,
e1_ . adresse3 AS adresse3_16 ,
e1_ . code_postal AS code_postal_17 ,
e1_ . cedex AS cedex_18 ,
e1_ . latitude AS latitude_19 ,
e1_ . longitude AS longitude_20 ,
e1_ . telephone_principal AS telephone_principal_21 ,
e1_ . fax AS fax_22 ,
e1_ . email_principal AS email_principal_23 ,
e1_ . logo_liste AS logo_liste_24 ,
e1_ . logo_fiche AS logo_fiche_25 ,
e1_ . diaporama_actif AS diaporama_actif_26 ,
e1_ . images_diaporama AS images_diaporama_27 ,
e1_ . participant AS participant_28 ,
e1_ . catholique AS catholique_29 ,
e1_ . age_admission AS age_admission_30 ,
e1_ . actif AS actif_31 ,
e1_ . internat AS internat_32 ,
e1_ . has_internat AS has_internat_33 ,
e1_ . types_internat AS types_internat_34 ,
e1_ . sous_contrat AS sous_contrat_35 ,
e1_ . alternance AS alternance_36 ,
e1_ . type_client AS type_client_37 ,
e1_ . bloque_txt_ref AS bloque_txt_ref_38 ,
e1_ . facebook AS facebook_39 ,
e1_ . bloque_bac2021 AS bloque_bac2021_40 ,
e1_ . presence_web AS presence_web_41 ,
e1_ . video_plus AS video_plus_42 ,
e1_ . diapo_plus AS diapo_plus_43 ,
e1_ . jpo_plus AS jpo_plus_44 ,
e1_ . doc_plus AS doc_plus_45 ,
e1_ . diplome_plus AS diplome_plus_46 ,
e1_ . refus AS refus_47 ,
e1_ . path AS path_48 ,
e1_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_49 ,
e1_ . lva AS lva_50 ,
e1_ . lvb AS lvb_51 ,
e1_ . numero_administratif_uai AS numero_administratif_uai_52 ,
e1_ . siret AS siret_53 ,
e1_ . chiffres AS chiffres_54 ,
e1_ . id AS id_55 ,
e1_ . maj AS maj_56 ,
t2_ . actif AS actif_57 ,
t2_ . contenu AS contenu_58 ,
t2_ . id AS id_59 ,
v3_ . slug AS slug_60 ,
v3_ . libelle AS libelle_61 ,
v3_ . code_postal AS code_postal_62 ,
v3_ . email_delegue AS email_delegue_63 ,
v3_ . onglets AS onglets_64 ,
v3_ . id AS id_65 ,
v3_ . maj AS maj_66 ,
v4_ . latitude AS latitude_67 ,
v4_ . longitude AS longitude_68 ,
v4_ . id AS id_69 ,
z0_ . etablissement_id AS etablissement_id_70 ,
e1_ . gestionnaire_id AS gestionnaire_id_71 ,
e1_ . ville_id AS ville_id_72 ,
e1_ . categorie_primaire_id AS categorie_primaire_id_73 ,
e1_ . region_id AS region_id_74 ,
e1_ . departement_id AS departement_id_75 ,
e1_ . categorie_organisme_id AS categorie_organisme_id_76 ,
e1_ . rubrique AS rubrique_77 ,
e1_ . internat2_id AS internat2_id_78 ,
e1_ . etablissement_lie_id AS etablissement_lie_id_79 ,
e1_ . logo_id AS logo_id_80 ,
e1_ . diapo_principal_id AS diapo_principal_id_81 ,
t2_ . etablissement_id AS etablissement_id_82 ,
t2_ . template_id AS template_id_83 ,
v3_ . departement_id AS departement_id_84 ,
v4_ . ville_id AS ville_id_85
FROM
zones_internat z0_
LEFT JOIN etablissement e1_ ON z0_ . etablissement_id = e1_ . id
LEFT JOIN texte_referencement t2_ ON e1_ . id = t2_ . etablissement_id
LEFT JOIN ville v3_ ON e1_ . ville_id = v3_ . id
LEFT JOIN ville_coordonnees v4_ ON v3_ . id = v4_ . ville_id
WHERE
z0_ . zone = ?
GROUP BY
z0_ . etablissement_id
ORDER BY
z0_ . id ASC
Copy
SELECT z0_ . zone AS zone_0 , z0_ . id AS id_1 , z0_ . maj AS maj_2 , e1_ . type AS type_3 , e1_ . nombre_eleves AS nombre_eleves_4 , e1_ . url AS url_5 , e1_ . video AS video_6 , e1_ . mots_cles AS mots_cles_7 , e1_ . denomination AS denomination_8 , e1_ . denomination_sigle AS denomination_sigle_9 , e1_ . denomination_extension AS denomination_extension_10 , e1_ . denomination_abregee AS denomination_abregee_11 , e1_ . droit_page_web AS droit_page_web_12 , e1_ . droit_actualite AS droit_actualite_13 , e1_ . adresse1 AS adresse1_14 , e1_ . adresse2 AS adresse2_15 , e1_ . adresse3 AS adresse3_16 , e1_ . code_postal AS code_postal_17 , e1_ . cedex AS cedex_18 , e1_ . latitude AS latitude_19 , e1_ . longitude AS longitude_20 , e1_ . telephone_principal AS telephone_principal_21 , e1_ . fax AS fax_22 , e1_ . email_principal AS email_principal_23 , e1_ . logo_liste AS logo_liste_24 , e1_ . logo_fiche AS logo_fiche_25 , e1_ . diaporama_actif AS diaporama_actif_26 , e1_ . images_diaporama AS images_diaporama_27 , e1_ . participant AS participant_28 , e1_ . catholique AS catholique_29 , e1_ . age_admission AS age_admission_30 , e1_ . actif AS actif_31 , e1_ . internat AS internat_32 , e1_ . has_internat AS has_internat_33 , e1_ . types_internat AS types_internat_34 , e1_ . sous_contrat AS sous_contrat_35 , e1_ . alternance AS alternance_36 , e1_ . type_client AS type_client_37 , e1_ . bloque_txt_ref AS bloque_txt_ref_38 , e1_ . facebook AS facebook_39 , e1_ . bloque_bac2021 AS bloque_bac2021_40 , e1_ . presence_web AS presence_web_41 , e1_ . video_plus AS video_plus_42 , e1_ . diapo_plus AS diapo_plus_43 , e1_ . jpo_plus AS jpo_plus_44 , e1_ . doc_plus AS doc_plus_45 , e1_ . diplome_plus AS diplome_plus_46 , e1_ . refus AS refus_47 , e1_ . path AS path_48 , e1_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_49 , e1_ . lva AS lva_50 , e1_ . lvb AS lvb_51 , e1_ . numero_administratif_uai AS numero_administratif_uai_52 , e1_ . siret AS siret_53 , e1_ . chiffres AS chiffres_54 , e1_ . id AS id_55 , e1_ . maj AS maj_56 , t2_ . actif AS actif_57 , t2_ . contenu AS contenu_58 , t2_ . id AS id_59 , v3_ . slug AS slug_60 , v3_ . libelle AS libelle_61 , v3_ . code_postal AS code_postal_62 , v3_ . email_delegue AS email_delegue_63 , v3_ . onglets AS onglets_64 , v3_ . id AS id_65 , v3_ . maj AS maj_66 , v4_ . latitude AS latitude_67 , v4_ . longitude AS longitude_68 , v4_ . id AS id_69 , z0_ . etablissement_id AS etablissement_id_70 , e1_ . gestionnaire_id AS gestionnaire_id_71 , e1_ . ville_id AS ville_id_72 , e1_ . categorie_primaire_id AS categorie_primaire_id_73 , e1_ . region_id AS region_id_74 , e1_ . departement_id AS departement_id_75 , e1_ . categorie_organisme_id AS categorie_organisme_id_76 , e1_ . rubrique AS rubrique_77 , e1_ . internat2_id AS internat2_id_78 , e1_ . etablissement_lie_id AS etablissement_lie_id_79 , e1_ . logo_id AS logo_id_80 , e1_ . diapo_principal_id AS diapo_principal_id_81 , t2_ . etablissement_id AS etablissement_id_82 , t2_ . template_id AS template_id_83 , v3_ . departement_id AS departement_id_84 , v4_ . ville_id AS ville_id_85 FROM zones_internat z0_ LEFT JOIN etablissement e1_ ON z0_ . etablissement_id = e1_ . id LEFT JOIN texte_referencement t2_ ON e1_ . id = t2_ . etablissement_id LEFT JOIN ville v3_ ON e1_ . ville_id = v3_ . id LEFT JOIN ville_coordonnees v4_ ON v3_ . id = v4_ . ville_id WHERE z0_ . zone = 'Z4' GROUP BY z0_ . etablissement_id ORDER BY z0_ . id ASC ;
Copy
12
24.36 ms
SELECT t0 . type AS type_1 , t0 . nombre_eleves AS nombre_eleves_2 , t0 . url AS url_3 , t0 . video AS video_4 , t0 . mots_cles AS mots_cles_5 , t0 . denomination AS denomination_6 , t0 . denomination_sigle AS denomination_sigle_7 , t0 . denomination_extension AS denomination_extension_8 , t0 . denomination_abregee AS denomination_abregee_9 , t0 . droit_page_web AS droit_page_web_10 , t0 . droit_actualite AS droit_actualite_11 , t0 . adresse1 AS adresse1_12 , t0 . adresse2 AS adresse2_13 , t0 . adresse3 AS adresse3_14 , t0 . code_postal AS code_postal_15 , t0 . cedex AS cedex_16 , t0 . latitude AS latitude_17 , t0 . longitude AS longitude_18 , t0 . telephone_principal AS telephone_principal_19 , t0 . fax AS fax_20 , t0 . email_principal AS email_principal_21 , t0 . logo_liste AS logo_liste_22 , t0 . logo_fiche AS logo_fiche_23 , t0 . diaporama_actif AS diaporama_actif_24 , t0 . images_diaporama AS images_diaporama_25 , t0 . participant AS participant_26 , t0 . catholique AS catholique_27 , t0 . age_admission AS age_admission_28 , t0 . actif AS actif_29 , t0 . internat AS internat_30 , t0 . has_internat AS has_internat_31 , t0 . types_internat AS types_internat_32 , t0 . sous_contrat AS sous_contrat_33 , t0 . alternance AS alternance_34 , t0 . type_client AS type_client_35 , t0 . bloque_txt_ref AS bloque_txt_ref_36 , t0 . facebook AS facebook_37 , t0 . bloque_bac2021 AS bloque_bac2021_38 , t0 . presence_web AS presence_web_39 , t0 . video_plus AS video_plus_40 , t0 . diapo_plus AS diapo_plus_41 , t0 . jpo_plus AS jpo_plus_42 , t0 . doc_plus AS doc_plus_43 , t0 . diplome_plus AS diplome_plus_44 , t0 . refus AS refus_45 , t0 . path AS path_46 , t0 . composition_ensemble_scolaire AS composition_ensemble_scolaire_47 , t0 . lva AS lva_48 , t0 . lvb AS lvb_49 , t0 . numero_administratif_uai AS numero_administratif_uai_50 , t0 . siret AS siret_51 , t0 . chiffres AS chiffres_52 , t0 . id AS id_53 , t0 . maj AS maj_54 , t0 . gestionnaire_id AS gestionnaire_id_55 , t56 . type AS type_57 , t56 . nombre_eleves AS nombre_eleves_58 , t56 . url AS url_59 , t56 . video AS video_60 , t56 . mots_cles AS mots_cles_61 , t56 . denomination AS denomination_62 , t56 . denomination_sigle AS denomination_sigle_63 , t56 . denomination_extension AS denomination_extension_64 , t56 . denomination_abregee AS denomination_abregee_65 , t56 . droit_page_web AS droit_page_web_66 , t56 . droit_actualite AS droit_actualite_67 , t56 . adresse1 AS adresse1_68 , t56 . adresse2 AS adresse2_69 , t56 . adresse3 AS adresse3_70 , t56 . code_postal AS code_postal_71 , t56 . cedex AS cedex_72 , t56 . latitude AS latitude_73 , t56 . longitude AS longitude_74 , t56 . telephone_principal AS telephone_principal_75 , t56 . fax AS fax_76 , t56 . email_principal AS email_principal_77 , t56 . logo_liste AS logo_liste_78 , t56 . logo_fiche AS logo_fiche_79 , t56 . diaporama_actif AS diaporama_actif_80 , t56 . images_diaporama AS images_diaporama_81 , t56 . participant AS participant_82 , t56 . catholique AS catholique_83 , t56 . age_admission AS age_admission_84 , t56 . actif AS actif_85 , t56 . internat AS internat_86 , t56 . has_internat AS has_internat_87 , t56 . types_internat AS types_internat_88 , t56 . sous_contrat AS sous_contrat_89 , t56 . alternance AS alternance_90 , t56 . type_client AS type_client_91 , t56 . bloque_txt_ref AS bloque_txt_ref_92 , t56 . facebook AS facebook_93 , t56 . bloque_bac2021 AS bloque_bac2021_94 , t56 . presence_web AS presence_web_95 , t56 . video_plus AS video_plus_96 , t56 . diapo_plus AS diapo_plus_97 , t56 . jpo_plus AS jpo_plus_98 , t56 . doc_plus AS doc_plus_99 , t56 . diplome_plus AS diplome_plus_100 , t56 . refus AS refus_101 , t56 . path AS path_102 , t56 . composition_ensemble_scolaire AS composition_ensemble_scolaire_103 , t56 . lva AS lva_104 , t56 . lvb AS lvb_105 , t56 . numero_administratif_uai AS numero_administratif_uai_106 , t56 . siret AS siret_107 , t56 . chiffres AS chiffres_108 , t56 . id AS id_109 , t56 . maj AS maj_110 , t56 . gestionnaire_id AS gestionnaire_id_111 , t56 . ville_id AS ville_id_112 , t56 . categorie_primaire_id AS categorie_primaire_id_113 , t56 . region_id AS region_id_114 , t56 . departement_id AS departement_id_115 , t56 . categorie_organisme_id AS categorie_organisme_id_116 , t56 . rubrique AS rubrique_117 , t56 . internat2_id AS internat2_id_118 , t56 . etablissement_lie_id AS etablissement_lie_id_119 , t56 . logo_id AS logo_id_120 , t56 . diapo_principal_id AS diapo_principal_id_121 , t0 . ville_id AS ville_id_122 , t123 . actif AS actif_124 , t123 . contenu AS contenu_125 , t123 . id AS id_126 , t123 . etablissement_id AS etablissement_id_127 , t123 . template_id AS template_id_128 , t0 . categorie_primaire_id AS categorie_primaire_id_129 , t0 . region_id AS region_id_130 , t0 . departement_id AS departement_id_131 , t0 . categorie_organisme_id AS categorie_organisme_id_132 , t0 . rubrique AS rubrique_133 , t0 . internat2_id AS internat2_id_134 , t0 . etablissement_lie_id AS etablissement_lie_id_135 , t0 . logo_id AS logo_id_136 , t0 . diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0 . gestionnaire_id = t56 . id LEFT JOIN texte_referencement t123 ON t123 . etablissement_id = t0 . id WHERE t0 . id IN (? )
Parameters :
[
[
"GE001-10 "
"GE030-26 "
"GE095-9 "
"GE069-56 "
"GE074-30 "
"GE077-19 "
"GE069-28 "
"GE012-1 "
"GE074-6 "
]
]
SELECT
t0 . type AS type_1 ,
t0 . nombre_eleves AS nombre_eleves_2 ,
t0 . url AS url_3 ,
t0 . video AS video_4 ,
t0 . mots_cles AS mots_cles_5 ,
t0 . denomination AS denomination_6 ,
t0 . denomination_sigle AS denomination_sigle_7 ,
t0 . denomination_extension AS denomination_extension_8 ,
t0 . denomination_abregee AS denomination_abregee_9 ,
t0 . droit_page_web AS droit_page_web_10 ,
t0 . droit_actualite AS droit_actualite_11 ,
t0 . adresse1 AS adresse1_12 ,
t0 . adresse2 AS adresse2_13 ,
t0 . adresse3 AS adresse3_14 ,
t0 . code_postal AS code_postal_15 ,
t0 . cedex AS cedex_16 ,
t0 . latitude AS latitude_17 ,
t0 . longitude AS longitude_18 ,
t0 . telephone_principal AS telephone_principal_19 ,
t0 . fax AS fax_20 ,
t0 . email_principal AS email_principal_21 ,
t0 . logo_liste AS logo_liste_22 ,
t0 . logo_fiche AS logo_fiche_23 ,
t0 . diaporama_actif AS diaporama_actif_24 ,
t0 . images_diaporama AS images_diaporama_25 ,
t0 . participant AS participant_26 ,
t0 . catholique AS catholique_27 ,
t0 . age_admission AS age_admission_28 ,
t0 . actif AS actif_29 ,
t0 . internat AS internat_30 ,
t0 . has_internat AS has_internat_31 ,
t0 . types_internat AS types_internat_32 ,
t0 . sous_contrat AS sous_contrat_33 ,
t0 . alternance AS alternance_34 ,
t0 . type_client AS type_client_35 ,
t0 . bloque_txt_ref AS bloque_txt_ref_36 ,
t0 . facebook AS facebook_37 ,
t0 . bloque_bac2021 AS bloque_bac2021_38 ,
t0 . presence_web AS presence_web_39 ,
t0 . video_plus AS video_plus_40 ,
t0 . diapo_plus AS diapo_plus_41 ,
t0 . jpo_plus AS jpo_plus_42 ,
t0 . doc_plus AS doc_plus_43 ,
t0 . diplome_plus AS diplome_plus_44 ,
t0 . refus AS refus_45 ,
t0 . path AS path_46 ,
t0 . composition_ensemble_scolaire AS composition_ensemble_scolaire_47 ,
t0 . lva AS lva_48 ,
t0 . lvb AS lvb_49 ,
t0 . numero_administratif_uai AS numero_administratif_uai_50 ,
t0 . siret AS siret_51 ,
t0 . chiffres AS chiffres_52 ,
t0 . id AS id_53 ,
t0 . maj AS maj_54 ,
t0 . gestionnaire_id AS gestionnaire_id_55 ,
t56 . type AS type_57 ,
t56 . nombre_eleves AS nombre_eleves_58 ,
t56 . url AS url_59 ,
t56 . video AS video_60 ,
t56 . mots_cles AS mots_cles_61 ,
t56 . denomination AS denomination_62 ,
t56 . denomination_sigle AS denomination_sigle_63 ,
t56 . denomination_extension AS denomination_extension_64 ,
t56 . denomination_abregee AS denomination_abregee_65 ,
t56 . droit_page_web AS droit_page_web_66 ,
t56 . droit_actualite AS droit_actualite_67 ,
t56 . adresse1 AS adresse1_68 ,
t56 . adresse2 AS adresse2_69 ,
t56 . adresse3 AS adresse3_70 ,
t56 . code_postal AS code_postal_71 ,
t56 . cedex AS cedex_72 ,
t56 . latitude AS latitude_73 ,
t56 . longitude AS longitude_74 ,
t56 . telephone_principal AS telephone_principal_75 ,
t56 . fax AS fax_76 ,
t56 . email_principal AS email_principal_77 ,
t56 . logo_liste AS logo_liste_78 ,
t56 . logo_fiche AS logo_fiche_79 ,
t56 . diaporama_actif AS diaporama_actif_80 ,
t56 . images_diaporama AS images_diaporama_81 ,
t56 . participant AS participant_82 ,
t56 . catholique AS catholique_83 ,
t56 . age_admission AS age_admission_84 ,
t56 . actif AS actif_85 ,
t56 . internat AS internat_86 ,
t56 . has_internat AS has_internat_87 ,
t56 . types_internat AS types_internat_88 ,
t56 . sous_contrat AS sous_contrat_89 ,
t56 . alternance AS alternance_90 ,
t56 . type_client AS type_client_91 ,
t56 . bloque_txt_ref AS bloque_txt_ref_92 ,
t56 . facebook AS facebook_93 ,
t56 . bloque_bac2021 AS bloque_bac2021_94 ,
t56 . presence_web AS presence_web_95 ,
t56 . video_plus AS video_plus_96 ,
t56 . diapo_plus AS diapo_plus_97 ,
t56 . jpo_plus AS jpo_plus_98 ,
t56 . doc_plus AS doc_plus_99 ,
t56 . diplome_plus AS diplome_plus_100 ,
t56 . refus AS refus_101 ,
t56 . path AS path_102 ,
t56 . composition_ensemble_scolaire AS composition_ensemble_scolaire_103 ,
t56 . lva AS lva_104 ,
t56 . lvb AS lvb_105 ,
t56 . numero_administratif_uai AS numero_administratif_uai_106 ,
t56 . siret AS siret_107 ,
t56 . chiffres AS chiffres_108 ,
t56 . id AS id_109 ,
t56 . maj AS maj_110 ,
t56 . gestionnaire_id AS gestionnaire_id_111 ,
t56 . ville_id AS ville_id_112 ,
t56 . categorie_primaire_id AS categorie_primaire_id_113 ,
t56 . region_id AS region_id_114 ,
t56 . departement_id AS departement_id_115 ,
t56 . categorie_organisme_id AS categorie_organisme_id_116 ,
t56 . rubrique AS rubrique_117 ,
t56 . internat2_id AS internat2_id_118 ,
t56 . etablissement_lie_id AS etablissement_lie_id_119 ,
t56 . logo_id AS logo_id_120 ,
t56 . diapo_principal_id AS diapo_principal_id_121 ,
t0 . ville_id AS ville_id_122 ,
t123 . actif AS actif_124 ,
t123 . contenu AS contenu_125 ,
t123 . id AS id_126 ,
t123 . etablissement_id AS etablissement_id_127 ,
t123 . template_id AS template_id_128 ,
t0 . categorie_primaire_id AS categorie_primaire_id_129 ,
t0 . region_id AS region_id_130 ,
t0 . departement_id AS departement_id_131 ,
t0 . categorie_organisme_id AS categorie_organisme_id_132 ,
t0 . rubrique AS rubrique_133 ,
t0 . internat2_id AS internat2_id_134 ,
t0 . etablissement_lie_id AS etablissement_lie_id_135 ,
t0 . logo_id AS logo_id_136 ,
t0 . diapo_principal_id AS diapo_principal_id_137
FROM
etablissement t0
LEFT JOIN etablissement t56 ON t0 . gestionnaire_id = t56 . id
LEFT JOIN texte_referencement t123 ON t123 . etablissement_id = t0 . id
WHERE
t0 . id IN (? )
Copy
SELECT t0 . type AS type_1 , t0 . nombre_eleves AS nombre_eleves_2 , t0 . url AS url_3 , t0 . video AS video_4 , t0 . mots_cles AS mots_cles_5 , t0 . denomination AS denomination_6 , t0 . denomination_sigle AS denomination_sigle_7 , t0 . denomination_extension AS denomination_extension_8 , t0 . denomination_abregee AS denomination_abregee_9 , t0 . droit_page_web AS droit_page_web_10 , t0 . droit_actualite AS droit_actualite_11 , t0 . adresse1 AS adresse1_12 , t0 . adresse2 AS adresse2_13 , t0 . adresse3 AS adresse3_14 , t0 . code_postal AS code_postal_15 , t0 . cedex AS cedex_16 , t0 . latitude AS latitude_17 , t0 . longitude AS longitude_18 , t0 . telephone_principal AS telephone_principal_19 , t0 . fax AS fax_20 , t0 . email_principal AS email_principal_21 , t0 . logo_liste AS logo_liste_22 , t0 . logo_fiche AS logo_fiche_23 , t0 . diaporama_actif AS diaporama_actif_24 , t0 . images_diaporama AS images_diaporama_25 , t0 . participant AS participant_26 , t0 . catholique AS catholique_27 , t0 . age_admission AS age_admission_28 , t0 . actif AS actif_29 , t0 . internat AS internat_30 , t0 . has_internat AS has_internat_31 , t0 . types_internat AS types_internat_32 , t0 . sous_contrat AS sous_contrat_33 , t0 . alternance AS alternance_34 , t0 . type_client AS type_client_35 , t0 . bloque_txt_ref AS bloque_txt_ref_36 , t0 . facebook AS facebook_37 , t0 . bloque_bac2021 AS bloque_bac2021_38 , t0 . presence_web AS presence_web_39 , t0 . video_plus AS video_plus_40 , t0 . diapo_plus AS diapo_plus_41 , t0 . jpo_plus AS jpo_plus_42 , t0 . doc_plus AS doc_plus_43 , t0 . diplome_plus AS diplome_plus_44 , t0 . refus AS refus_45 , t0 . path AS path_46 , t0 . composition_ensemble_scolaire AS composition_ensemble_scolaire_47 , t0 . lva AS lva_48 , t0 . lvb AS lvb_49 , t0 . numero_administratif_uai AS numero_administratif_uai_50 , t0 . siret AS siret_51 , t0 . chiffres AS chiffres_52 , t0 . id AS id_53 , t0 . maj AS maj_54 , t0 . gestionnaire_id AS gestionnaire_id_55 , t56 . type AS type_57 , t56 . nombre_eleves AS nombre_eleves_58 , t56 . url AS url_59 , t56 . video AS video_60 , t56 . mots_cles AS mots_cles_61 , t56 . denomination AS denomination_62 , t56 . denomination_sigle AS denomination_sigle_63 , t56 . denomination_extension AS denomination_extension_64 , t56 . denomination_abregee AS denomination_abregee_65 , t56 . droit_page_web AS droit_page_web_66 , t56 . droit_actualite AS droit_actualite_67 , t56 . adresse1 AS adresse1_68 , t56 . adresse2 AS adresse2_69 , t56 . adresse3 AS adresse3_70 , t56 . code_postal AS code_postal_71 , t56 . cedex AS cedex_72 , t56 . latitude AS latitude_73 , t56 . longitude AS longitude_74 , t56 . telephone_principal AS telephone_principal_75 , t56 . fax AS fax_76 , t56 . email_principal AS email_principal_77 , t56 . logo_liste AS logo_liste_78 , t56 . logo_fiche AS logo_fiche_79 , t56 . diaporama_actif AS diaporama_actif_80 , t56 . images_diaporama AS images_diaporama_81 , t56 . participant AS participant_82 , t56 . catholique AS catholique_83 , t56 . age_admission AS age_admission_84 , t56 . actif AS actif_85 , t56 . internat AS internat_86 , t56 . has_internat AS has_internat_87 , t56 . types_internat AS types_internat_88 , t56 . sous_contrat AS sous_contrat_89 , t56 . alternance AS alternance_90 , t56 . type_client AS type_client_91 , t56 . bloque_txt_ref AS bloque_txt_ref_92 , t56 . facebook AS facebook_93 , t56 . bloque_bac2021 AS bloque_bac2021_94 , t56 . presence_web AS presence_web_95 , t56 . video_plus AS video_plus_96 , t56 . diapo_plus AS diapo_plus_97 , t56 . jpo_plus AS jpo_plus_98 , t56 . doc_plus AS doc_plus_99 , t56 . diplome_plus AS diplome_plus_100 , t56 . refus AS refus_101 , t56 . path AS path_102 , t56 . composition_ensemble_scolaire AS composition_ensemble_scolaire_103 , t56 . lva AS lva_104 , t56 . lvb AS lvb_105 , t56 . numero_administratif_uai AS numero_administratif_uai_106 , t56 . siret AS siret_107 , t56 . chiffres AS chiffres_108 , t56 . id AS id_109 , t56 . maj AS maj_110 , t56 . gestionnaire_id AS gestionnaire_id_111 , t56 . ville_id AS ville_id_112 , t56 . categorie_primaire_id AS categorie_primaire_id_113 , t56 . region_id AS region_id_114 , t56 . departement_id AS departement_id_115 , t56 . categorie_organisme_id AS categorie_organisme_id_116 , t56 . rubrique AS rubrique_117 , t56 . internat2_id AS internat2_id_118 , t56 . etablissement_lie_id AS etablissement_lie_id_119 , t56 . logo_id AS logo_id_120 , t56 . diapo_principal_id AS diapo_principal_id_121 , t0 . ville_id AS ville_id_122 , t123 . actif AS actif_124 , t123 . contenu AS contenu_125 , t123 . id AS id_126 , t123 . etablissement_id AS etablissement_id_127 , t123 . template_id AS template_id_128 , t0 . categorie_primaire_id AS categorie_primaire_id_129 , t0 . region_id AS region_id_130 , t0 . departement_id AS departement_id_131 , t0 . categorie_organisme_id AS categorie_organisme_id_132 , t0 . rubrique AS rubrique_133 , t0 . internat2_id AS internat2_id_134 , t0 . etablissement_lie_id AS etablissement_lie_id_135 , t0 . logo_id AS logo_id_136 , t0 . diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0 . gestionnaire_id = t56 . id LEFT JOIN texte_referencement t123 ON t123 . etablissement_id = t0 . id WHERE t0 . id IN ('GE001-10' , 'GE030-26' , 'GE095-9' , 'GE069-56' , 'GE074-30' , 'GE077-19' , 'GE069-28' , 'GE012-1' , 'GE074-6' );
Copy