Symfony Profiler

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;

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,
  r0_.pays_id AS pays_id_7
FROM
  region r0_

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, r0_.pays_id AS pays_id_7 FROM region r0_;

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
  AND r0_.libelle <> 'DEFAULT'
  AND r0_.region_adm IS NOT NULL
ORDER BY
  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 AND r0_.libelle <> 'DEFAULT' AND r0_.region_adm IS NOT NULL ORDER BY r0_.libelle ASC;

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

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 = '000' AND d0_.id <> 'BE' ORDER BY d0_.libelle ASC;

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
  LEFT JOIN departement d2_ ON v0_.departement_id = d2_.id
  LEFT JOIN ancienne_region a3_ ON d2_.ancienne_region_id = a3_.id
WHERE
  v0_.libelle IS NOT NULL
  AND a3_.region_id = ?
ORDER BY
  v0_.libelle ASC

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 LEFT JOIN departement d2_ ON v0_.departement_id = d2_.id LEFT JOIN ancienne_region a3_ ON d2_.ancienne_region_id = a3_.id WHERE v0_.libelle IS NOT NULL AND a3_.region_id = '000' ORDER BY v0_.libelle ASC;

SELECT
  v0_.id AS id_0,
  v0_.titre AS titre_1,
  v0_.url AS url_2,
  v0_.actif AS actif_3,
  v0_.position AS position_4,
  v0_.texte AS texte_5,
  v0_.file_name AS file_name_6,
  v0_.file_size AS file_size_7,
  v0_.updated_at AS updated_at_8,
  v0_.file_name_source AS file_name_source_9,
  v0_.file_size_source AS file_size_source_10,
  v0_.date_crea AS date_crea_11,
  v0_.date_maj AS date_maj_12
FROM
  video v0_
  INNER JOIN video_etablissement v2_ ON v0_.id = v2_.video_id
  INNER JOIN etablissement e1_ ON e1_.id = v2_.etablissement_id
  INNER JOIN ville v3_ ON e1_.ville_id = v3_.id
  INNER JOIN departement d4_ ON v3_.departement_id = d4_.id
  INNER JOIN ancienne_region a5_ ON d4_.ancienne_region_id = a5_.id
  INNER JOIN region r6_ ON a5_.region_id = r6_.id
ORDER BY
  v0_.date_crea DESC
LIMIT
  1000

SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.url AS url_2, v0_.actif AS actif_3, v0_.position AS position_4, v0_.texte AS texte_5, v0_.file_name AS file_name_6, v0_.file_size AS file_size_7, v0_.updated_at AS updated_at_8, v0_.file_name_source AS file_name_source_9, v0_.file_size_source AS file_size_source_10, v0_.date_crea AS date_crea_11, v0_.date_maj AS date_maj_12 FROM video v0_ INNER JOIN video_etablissement v2_ ON v0_.id = v2_.video_id INNER JOIN etablissement e1_ ON e1_.id = v2_.etablissement_id INNER JOIN ville v3_ ON e1_.ville_id = v3_.id INNER JOIN departement d4_ ON v3_.departement_id = d4_.id INNER JOIN ancienne_region a5_ ON d4_.ancienne_region_id = a5_.id INNER JOIN region r6_ ON a5_.region_id = r6_.id ORDER BY v0_.date_crea DESC LIMIT 1000;

SELECT
  v0_.id AS id_0,
  v0_.titre AS titre_1,
  v0_.url AS url_2,
  v0_.actif AS actif_3,
  v0_.position AS position_4,
  v0_.texte AS texte_5,
  v0_.file_name AS file_name_6,
  v0_.file_size AS file_size_7,
  v0_.updated_at AS updated_at_8,
  v0_.file_name_source AS file_name_source_9,
  v0_.file_size_source AS file_size_source_10,
  v0_.date_crea AS date_crea_11,
  v0_.date_maj AS date_maj_12,
  e1_.type AS type_13,
  e1_.nombre_eleves AS nombre_eleves_14,
  e1_.url AS url_15,
  e1_.video AS video_16,
  e1_.mots_cles AS mots_cles_17,
  e1_.denomination AS denomination_18,
  e1_.denomination_sigle AS denomination_sigle_19,
  e1_.denomination_extension AS denomination_extension_20,
  e1_.denomination_abregee AS denomination_abregee_21,
  e1_.droit_page_web AS droit_page_web_22,
  e1_.droit_actualite AS droit_actualite_23,
  e1_.adresse1 AS adresse1_24,
  e1_.adresse2 AS adresse2_25,
  e1_.adresse3 AS adresse3_26,
  e1_.code_postal AS code_postal_27,
  e1_.cedex AS cedex_28,
  e1_.latitude AS latitude_29,
  e1_.longitude AS longitude_30,
  e1_.telephone_principal AS telephone_principal_31,
  e1_.fax AS fax_32,
  e1_.email_principal AS email_principal_33,
  e1_.logo_liste AS logo_liste_34,
  e1_.logo_fiche AS logo_fiche_35,
  e1_.diaporama_actif AS diaporama_actif_36,
  e1_.images_diaporama AS images_diaporama_37,
  e1_.participant AS participant_38,
  e1_.catholique AS catholique_39,
  e1_.age_admission AS age_admission_40,
  e1_.actif AS actif_41,
  e1_.internat AS internat_42,
  e1_.has_internat AS has_internat_43,
  e1_.types_internat AS types_internat_44,
  e1_.sous_contrat AS sous_contrat_45,
  e1_.alternance AS alternance_46,
  e1_.type_client AS type_client_47,
  e1_.bloque_txt_ref AS bloque_txt_ref_48,
  e1_.facebook AS facebook_49,
  e1_.bloque_bac2021 AS bloque_bac2021_50,
  e1_.presence_web AS presence_web_51,
  e1_.video_plus AS video_plus_52,
  e1_.diapo_plus AS diapo_plus_53,
  e1_.jpo_plus AS jpo_plus_54,
  e1_.doc_plus AS doc_plus_55,
  e1_.diplome_plus AS diplome_plus_56,
  e1_.refus AS refus_57,
  e1_.path AS path_58,
  e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_59,
  e1_.lva AS lva_60,
  e1_.lvb AS lvb_61,
  e1_.numero_administratif_uai AS numero_administratif_uai_62,
  e1_.siret AS siret_63,
  e1_.chiffres AS chiffres_64,
  e1_.id AS id_65,
  e1_.maj AS maj_66,
  t2_.actif AS actif_67,
  t2_.contenu AS contenu_68,
  t2_.id AS id_69,
  e1_.gestionnaire_id AS gestionnaire_id_70,
  e1_.ville_id AS ville_id_71,
  e1_.categorie_primaire_id AS categorie_primaire_id_72,
  e1_.region_id AS region_id_73,
  e1_.departement_id AS departement_id_74,
  e1_.categorie_organisme_id AS categorie_organisme_id_75,
  e1_.rubrique AS rubrique_76,
  e1_.internat2_id AS internat2_id_77,
  e1_.etablissement_lie_id AS etablissement_lie_id_78,
  e1_.logo_id AS logo_id_79,
  e1_.diapo_principal_id AS diapo_principal_id_80,
  t2_.etablissement_id AS etablissement_id_81,
  t2_.template_id AS template_id_82
FROM
  video v0_
  INNER JOIN video_etablissement v4_ ON v0_.id = v4_.video_id
  INNER JOIN etablissement e3_ ON e3_.id = v4_.etablissement_id
  LEFT JOIN video_etablissement v5_ ON v0_.id = v5_.video_id
  LEFT JOIN etablissement e1_ ON e1_.id = v5_.etablissement_id
  LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id
WHERE
  e3_.video_plus = 1
ORDER BY
  RAND() ASC
LIMIT
  5

SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.url AS url_2, v0_.actif AS actif_3, v0_.position AS position_4, v0_.texte AS texte_5, v0_.file_name AS file_name_6, v0_.file_size AS file_size_7, v0_.updated_at AS updated_at_8, v0_.file_name_source AS file_name_source_9, v0_.file_size_source AS file_size_source_10, v0_.date_crea AS date_crea_11, v0_.date_maj AS date_maj_12, e1_.type AS type_13, e1_.nombre_eleves AS nombre_eleves_14, e1_.url AS url_15, e1_.video AS video_16, e1_.mots_cles AS mots_cles_17, e1_.denomination AS denomination_18, e1_.denomination_sigle AS denomination_sigle_19, e1_.denomination_extension AS denomination_extension_20, e1_.denomination_abregee AS denomination_abregee_21, e1_.droit_page_web AS droit_page_web_22, e1_.droit_actualite AS droit_actualite_23, e1_.adresse1 AS adresse1_24, e1_.adresse2 AS adresse2_25, e1_.adresse3 AS adresse3_26, e1_.code_postal AS code_postal_27, e1_.cedex AS cedex_28, e1_.latitude AS latitude_29, e1_.longitude AS longitude_30, e1_.telephone_principal AS telephone_principal_31, e1_.fax AS fax_32, e1_.email_principal AS email_principal_33, e1_.logo_liste AS logo_liste_34, e1_.logo_fiche AS logo_fiche_35, e1_.diaporama_actif AS diaporama_actif_36, e1_.images_diaporama AS images_diaporama_37, e1_.participant AS participant_38, e1_.catholique AS catholique_39, e1_.age_admission AS age_admission_40, e1_.actif AS actif_41, e1_.internat AS internat_42, e1_.has_internat AS has_internat_43, e1_.types_internat AS types_internat_44, e1_.sous_contrat AS sous_contrat_45, e1_.alternance AS alternance_46, e1_.type_client AS type_client_47, e1_.bloque_txt_ref AS bloque_txt_ref_48, e1_.facebook AS facebook_49, e1_.bloque_bac2021 AS bloque_bac2021_50, e1_.presence_web AS presence_web_51, e1_.video_plus AS video_plus_52, e1_.diapo_plus AS diapo_plus_53, e1_.jpo_plus AS jpo_plus_54, e1_.doc_plus AS doc_plus_55, e1_.diplome_plus AS diplome_plus_56, e1_.refus AS refus_57, e1_.path AS path_58, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_59, e1_.lva AS lva_60, e1_.lvb AS lvb_61, e1_.numero_administratif_uai AS numero_administratif_uai_62, e1_.siret AS siret_63, e1_.chiffres AS chiffres_64, e1_.id AS id_65, e1_.maj AS maj_66, t2_.actif AS actif_67, t2_.contenu AS contenu_68, t2_.id AS id_69, e1_.gestionnaire_id AS gestionnaire_id_70, e1_.ville_id AS ville_id_71, e1_.categorie_primaire_id AS categorie_primaire_id_72, e1_.region_id AS region_id_73, e1_.departement_id AS departement_id_74, e1_.categorie_organisme_id AS categorie_organisme_id_75, e1_.rubrique AS rubrique_76, e1_.internat2_id AS internat2_id_77, e1_.etablissement_lie_id AS etablissement_lie_id_78, e1_.logo_id AS logo_id_79, e1_.diapo_principal_id AS diapo_principal_id_80, t2_.etablissement_id AS etablissement_id_81, t2_.template_id AS template_id_82 FROM video v0_ INNER JOIN video_etablissement v4_ ON v0_.id = v4_.video_id INNER JOIN etablissement e3_ ON e3_.id = v4_.etablissement_id LEFT JOIN video_etablissement v5_ ON v0_.id = v5_.video_id LEFT JOIN etablissement e1_ ON e1_.id = v5_.etablissement_id LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id WHERE e3_.video_plus = 1 ORDER BY RAND() ASC LIMIT 5;

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 (?)

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-9', 'GE034-30', 'GE083-7', 'GE016-3');