Symfony Profiler

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_.identifiant)
WHERE
  i0_.formation = 'oui'
  AND i0_.niveau = 4
  AND i0_.id IN (?)
  AND i0_.id LIKE 'PBAC-BAC2-GADF%'
ORDER BY
  i0_.libelle ASC

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_.identifiant) WHERE i0_.formation = 'oui' AND i0_.niveau = 4 AND i0_.id IN ('PBAC-BAC2-GADF', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-TEL', 'PBAC-COORD-MAIL', 'PBAC-COORD-WEB', 'PBAC-PRES', 'PBAC-ACCU', 'PBAC-BAC2-CDV', 'PBAC-SPEC', 'PBAC-BAC2-GADF-BTSCO', 'PBAC-BAC2-GADF-BTSGE', 'PBAC-PRES-CHE', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC3-GADF', 'PBAC-COORD-FAX', 'PBAC-BAC2-GADF-BTSSU', 'PBAC-ACCU-ACCE', 'PBAC-ACCU-CANT', 'PBAC-BAC2-CDV-BTSNE', 'PBAC-BAC3-CDV', 'PBAC-PRES-SCO', 'PBAC-SPEC-ADMI', 'PBAC-ACCU-BOUR', 'PBAC-PRES-NBE', 'PBAC-SPEC-IGEN', 'PBAC-PRES-DTEUR', 'PBAC-PRES-TUT', 'PBAC-ACCU-EXT', 'PBAC-BAC45-GADF', 'PBAC-ACCU-INTA', 'PBAC-BAC2-WEB', 'PBAC-BAC2-SASO', 'PBAC-ACCU-CAF', 'PBAC-BAC2-PUB', 'PBAC-BAC2-BAI', 'PBAC-BAC2-PUB-BTSCOM', 'PBAC-BAC2-WEB-BTSINFR', 'PBAC-SPEC-ENTR', 'PBAC-ACCU-MIXT', 'PBAC-BAC2-WEB-BTSSLAM', 'PBAC-BAC3-GADF-DCG', 'PBAC-SPEC-TXTS51', 'PBAC-PRES-NID', 'PBAC-SPEC-TXTS', 'PBAC-ACCU-HAND_MT', 'PBAC', 'PBAC-BAC2-BAI-BTSPRI', 'PBAC-BAC3-PUB', 'PBAC-BAC2-SASO-BTSSASO', 'PBAC-BAC45-CDV', 'PBAC-PRES-AUTR1_MT', 'PBAC-BAC2-CDV-BTSCOMI', 'PBAC-BAC2-SPOR', 'PBAC-BAC45-GADF-DSCG', 'PBAC-BAC2-SPOR-BTSTOU', 'PBAC-PRES-HCO', 'PBAC-SPEC-INTE', 'PBAC-BAC3-WEB', 'PBAC-SPEC-TXTS52', 'PBAC-BAC2-CDV-BTSCO', 'PBAC-PRES-DTRICE', 'PBAC-ACCU-HEB', 'PBAC-ACCU-TXTS53', 'PBAC-BAC2-GADF-BTSCO0', 'PBAC-BAC2-SASO-BTSESF', 'PBAC-BAC2-TRAN', 'PBAC-BAC2-TRAN-BTSGE', 'PBAC-PREPA-SASO', 'PBAC-SPEC-CAMP', 'PBAC-BAC2', 'PBAC-BAC3-BAN', 'PBAC-BAC3-CDV-LICEN2', 'PBAC-LOGO', 'PBAC-TEXTC1_MT', 'PBAC-BAC2-BAI-BTSAS', 'PBAC-BAC3', 'PBAC-BAC45-GADF-MANAG0', 'PBAC-PREPA-COM', 'PBAC-PRES-TXTS', 'PBAC-TARIFS', 'PBAC-BAC2-GADF-BTSMA', 'PBAC-TARIFS-RCOMPL', 'PBAC-ACCU-TXTS', 'PBAC-BAC2-TXTS', 'PBAC-BAC2-WEB-BTSCI', 'PBAC-BAC3-GADF-BACHE', 'PBAC-BAC3-SASO', 'PBAC-BAC3-SASO-CESF', 'PBAC-BAC3-SPOR', 'PBAC-BAC45', 'PBAC-BAC45-INF', 'PBAC-PREPA-MAUT', 'PBAC-TARIFS-INSC', 'PBAC-BAC2-CHI', 'PBAC-BAC3-BAN-BACHE4', 'PBAC-BAC3-PUB-BACHE', 'PBAC-ACCU-TXTS54', 'PBAC-BAC2-AUT', 'PBAC-BAC2-BAI-BANQU', 'PBAC-BAC2-ELEC', 'PBAC-BAC2-ELEC-BTSELEC', 'PBAC-BAC2-ENT', 'PBAC-BAC2-ENT-BTSMA', 'PBAC-BAC2-GADF-TITRE', 'PBAC-BAC2-WEB-BTSCI0', 'PBAC-BAC3-TXTS0', 'PBAC-BAC45-TXTS0', 'PBAC-PREPA-COM-CGPEECE', 'PBAC-TARIFS-INSC-BAC+2', 'PBAC-TARIFS-MODAL', 'PBAC-BAC2-TEXT', 'PBAC-BAC2-TXTS0', 'PBAC-BAC3-CDV-BACHE16', 'PBAC-BAC3-CDV-BRESDEVC', 'PBAC-BAC3-CDV-RESPO3', 'PBAC-BAC3-GADF-GESRH', 'PBAC-BAC3-GADF-LP25', 'PBAC-BAC3-GADF-RESPO5', 'PBAC-BAC3-TXTS', 'PBAC-BAC3-WEB-INF', 'PBAC-PRES-AUTR2_MT', 'PBAC-BAC2-AUT-BTSSAUT', 'PBAC-BAC2-CDV-ATCOM', 'PBAC-BAC2-GADF-TITRE0', 'PBAC-BAC2-GADF-TITRE1', 'PBAC-BAC2-HOT', 'PBAC-BAC2-HOT-BTSMA0', 'PBAC-BAC2-HOT-BTSMA1', 'PBAC-BAC2-SASO-BTSDIE', 'PBAC-BAC3-ART', 'PBAC-BAC3-CDV-BACHE6', 'PBAC-BAC3-CDV-BGB', 'PBAC-BAC3-CDV-COMDI', 'PBAC-BAC3-GADF-CHARG1', 'PBAC-BAC3-GADF-GESTEN', 'PBAC-BAC3-GADF-LICEN0', 'PBAC-BAC3-GADF-LP35', 'PBAC-BAC3-GADF-MANAG', 'PBAC-BAC3-PUB-BACHE3', 'PBAC-BAC3-PUB-BACHE7', 'PBAC-BAC3-TEXT', 'PBAC-BAC3-WEB-BACHE4', 'PBAC-BAC3-WEB-TITRE2', 'PBAC-BAC45-CDV-MANAG15', 'PBAC-BAC45-CDV-MANAG6', 'PBAC-BAC45-CDV-MASTE2', 'PBAC-BAC45-GADF-CONTR', 'PBAC-BAC45-GADF-DNOT', 'PBAC-BAC45-GADF-MA50', 'PBAC-BAC45-INF-MASTE3', 'PBAC-COORD-TXTS', 'PBAC-FPC-GADF', 'PBAC-PREPA', 'PBAC-PREPA-CHI', 'PBAC-PREPA-CHI-CGPEMP', 'PBAC-PREPA-CHI-CGPEPC', 'PBAC-PREPA-CHI-CGPEPCSI', 'PBAC-PREPA-COM-CGPEECS', 'PBAC-PREPA-COM-CGPEECT', 'PBAC-PREPA-MAUT-CPGEMPSI', 'LYC-ACCU', 'LYC-ACCU-CANT', 'LYC-ACCU-EXT', 'LYC-BACTEC-GADF', 'LYC-COORD', 'LYC-COORD-ADR', 'LYC-COORD-MAIL', 'LYC-COORD-TEL', 'LYC-COORD-WEB', 'LYC-FORMA2021', 'LYC-FORMA2021-GFACU', 'LYC-FORMA2021-GFACU-GFACULANG', 'LYC-FORMA2021-SPEC', 'LYC-FORMA2021-SPEC-SPECHIST', 'LYC-FORMA2021-SPEC-SPECHUM', 'LYC-FORMA2021-SPEC-SPECLANG', 'LYC-FORMA2021-SPEC-SPECMAT', 'LYC-FORMA2021-SPEC-SPECNUM', 'LYC-FORMA2021-SPEC-SPECPHY', 'LYC-FORMA2021-SPEC-SPECSES', 'LYC-FORMA2021-SPEC-SPECSVT', 'LYC-LANG', 'LYC-LANG-LV1', 'LYC-LANG-LV1-ANG', 'LYC-LANG-LV2', 'LYC-LANG-LV2-ALL', 'LYC-LANG-LV2-ESP', 'LYC-LANG-LV3', 'LYC-LANG-LV3-ITA', 'LYC-PRES', 'LYC-PRES-NBE', 'LYC-PRES-SCO', 'LYC-SPEC', 'LYC-SPEC-TXTS33', 'PBAC-BAC2-CHI-BTSABM', 'PBAC-BAC2-CHI-BTSME', 'PBAC-BAC2-ENEX', 'PBAC-BAC2-ENEX-BTSFL', 'PBAC-BAC2-GADF-TITRE5', 'PBAC-BAC2-GADF-TITRE6', 'PBAC-BAC2-HOT-BTSMA', 'PBAC-BAC2-SASO-BTSOPT', 'PBAC-BAC2-SASO-DEUST', 'PBAC-BAC2-SPOR-CERTI', 'PBAC-BAC2-SPOR-CERTI0', 'PBAC-BAC2-SPOR-MCANI', 'PBAC-BAC2-TEXT-BTSCOSM', 'PBAC-BAC2-TEXT-BTSMARQ', 'PBAC-BAC2-WEB-CERTI1', 'PBAC-BAC3-ART-DIPLO2', 'PBAC-BAC3-BAN-BACHE2', 'PBAC-BAC3-CDV-BACHE19', 'PBAC-BAC3-CDV-BACHE3', 'PBAC-BAC3-CDV-BACHE4', 'PBAC-BAC3-CDV-BAHON', 'PBAC-BAC3-CDV-BGM', 'PBAC-BAC3-CDV-BGMC', 'PBAC-BAC3-CDV-LICEN8', 'PBAC-BAC3-CDV-MMOP', 'PBAC-BAC3-CDV-RESPO4', 'PBAC-BAC3-CDV-TITRE3', 'PBAC-BAC3-CHIM', 'PBAC-BAC3-CULT', 'PBAC-BAC3-ENS', 'PBAC-BAC3-GADF-BACHE0', 'PBAC-BAC3-GADF-CERTI0', 'PBAC-BAC3-GADF-CONTR', 'PBAC-BAC3-GADF-GEST', 'PBAC-BAC3-GADF-GRH', 'PBAC-BAC3-GADF-LP33', 'PBAC-BAC3-GADF-LP38', 'PBAC-BAC3-GADF-MENOT', 'PBAC-BAC3-HOT', 'PBAC-BAC3-PUB-BCOMNUM', 'PBAC-BAC3-SPOR-BACHE', 'PBAC-BAC3-TEXT-BACHE', 'PBAC-BAC3-TRAN', 'PBAC-BAC3-WEB-BACHE1', 'PBAC-BAC3-WEB-BRCDSM', 'PBAC-BAC3-WEB-LICEN1', 'PBAC-BAC45-CDV-MANAG17', 'PBAC-BAC45-GADF-MA6', 'PBAC-BAC45-GADF-MBAMA2', 'PBAC-BAC45-GADF-RH', 'PBAC-BAC45-GADF-TMRH', 'PBAC-BAC45-TXTS', 'PBAC-FPC-SANT', 'PBAC-PREPA-COM-PREPA', 'PBAC-PREPA-CUL', 'PBAC-PREPA-CUL-MANAA', 'PBAC-PREPA-ENS', 'PBAC-PREPA-ENS-CPGELSS', 'PBAC-PREPA-GADF', 'PBAC-PREPA-MAUT-CPATS', 'PBAC-PREPA-MAUT-CPGEPSI', 'PBAC-PREPA-SASO-CEINF', 'PBAC-PREPA-SASO-CIFSI', 'PBAC-PREPA-SASO-CPPARA', 'PBAC-PREPA-TXTS0', 'PBAC-TARIFS-INSC-BAC+3', 'PBAC-TARIFS-INSC-PREPA', 'LYC-ACCU-ACCE', 'LYC-ACCU-BOUR', 'LYC-ACCU-CAF', 'LYC-ACCU-MIXT', 'LYC-ACCU-TXTS36', 'LYC-BACTEC', 'LYC-BACTEC-BTP', 'LYC-BACTEC-BTP-BACST', 'LYC-BACTEC-CDV', 'LYC-BACTEC-CDV-STMG', 'LYC-BACTEC-GADF-BACST', 'LYC-BACTEC-GADF-STMGGF', 'LYC-BACTEC-GADF-STMGRHC', 'LYC-BACTEC-TFACU', 'LYC-BACTEC-TFACU-ARTS', 'LYC-BACTEC-TFACU-LV3', 'LYC-BACTEC-WEB', 'LYC-BACTEC-WEB-STMGSIG', 'LYC-COORD-FAX', 'LYC-FORMA2021-GFACU-GFACUARTS', 'LYC-FORMA2021-GFACU-GFACUDROI', 'LYC-FORMA2021-GFACU-GFACUEPS', 'LYC-FORMA2021-GFACU-GFACULV3', 'LYC-FORMA2021-GFACU-GFACUMATC', 'LYC-FORMA2021-GFACU-GFACUMATE', 'LYC-FORMA2021-SPEC-SPECARTS', 'LYC-FORMA2021-SPEC-SPECING', 'LYC-FORMA2021-SPEC-SPECLLCA', 'LYC-FORMA2021-SPEC-SPORT', 'LYC-LANG-ANC_MT', 'LYC-LANG-ANC_MT-LAT', 'LYC-LANG-CERT', 'LYC-LANG-EUR', 'LYC-LANG-LSF', 'LYC-LANG-LV1-ALL', 'LYC-LANG-LV2-ITA', 'LYC-LANG-LV3-ALL', 'LYC-LANG-LV3-CHI', 'LYC-LANG-LV3-ESP', 'LYC-LANG-TXTS', 'LYC-PRES-AUTR1_MT', 'LYC-PRES-AUTR2_MT', 'LYC-PRES-CHE', 'LYC-PRES-DTEUR', 'LYC-PRES-NID', 'LYC-PRES-TUT', 'LYC-SPEC-2SGT', 'LYC-SPEC-ACC', 'LYC-SPEC-ACC-ULIS', 'LYC-SPEC-ART', 'LYC-SPEC-ASPO', 'LYC-SPEC-BDI', 'LYC-SPEC-BIA', 'LYC-SPEC-CDI', 'LYC-SPEC-EXP', 'LYC-SPEC-JUM', 'LYC-SPEC-OPTE', 'LYC-SPEC-PIX', 'LYC-SPEC-PREP', 'LYC-SPEC-PSC1', 'LYC-SPEC-REPA', 'LYC-SPEC-SCI', 'LYC-SPEC-SLIN', 'LYC-SPEC-SPOR', 'LYC-SPEC-TXTS32', 'LYC-SPEC-TXTS40', 'LYC-SPEC-VOY', 'LYCPRO-ACCU', 'LYCPRO-ACCU-ACCE', 'LYCPRO-ACCU-BOUR', 'LYCPRO-ACCU-CAF', 'LYCPRO-ACCU-CANT', 'LYCPRO-ACCU-EXT', 'LYCPRO-ACCU-MIXT', 'LYCPRO-BACP-DISTRI', 'LYCPRO-BACP-DISTRI-BACPR2', 'LYCPRO-BACP-DISTRI-BACPR3', 'LYCPRO-BACP-INF', 'LYCPRO-BACP-INF-BACPR0', 'LYCPRO-BACP-TEXT', 'LYCPRO-BACP-TEXT-BPRCOS', 'LYCPRO-COORD', 'LYCPRO-COORD-ADR', 'LYCPRO-COORD-FAX', 'LYCPRO-COORD-MAIL', 'LYCPRO-COORD-TEL', 'LYCPRO-COORD-WEB', 'LYCPRO-LANG', 'LYCPRO-LANG-LV1', 'LYCPRO-LANG-LV1-ANG', 'LYCPRO-LANG-LV2', 'LYCPRO-LANG-LV2-ALL', 'LYCPRO-LANG-LV2-ESP', 'LYCPRO-LANG-LV2-ITA', 'LYCPRO-PRES', 'LYCPRO-PRES-CHE', 'LYCPRO-PRES-NBE', 'LYCPRO-PRES-NID', 'LYCPRO-PRES-SCO', 'LYCPRO-PRES-TUT', 'LYCPRO-SPEC', 'LYCPRO-SPEC-ACC', 'LYCPRO-SPEC-ACC-ULIS', 'LYCPRO-SPEC-ASPO', 'LYCPRO-SPEC-BDI', 'LYCPRO-SPEC-BIA', 'LYCPRO-SPEC-CDI', 'LYCPRO-SPEC-CUL', 'LYCPRO-SPEC-EUR', 'LYCPRO-SPEC-PIX', 'LYCPRO-SPEC-PMET', 'LYCPRO-SPEC-SLIN', 'LYCPRO-SPEC-TXTS50', 'LYCPRO-SPEC-VOY', 'PBAC-BAC2-AGRI', 'PBAC-BAC2-AGRI-BTSAM', 'PBAC-BAC2-AUT-BTSTEIN', 'PBAC-BAC2-AUT-FCILP', 'PBAC-BAC2-BTP', 'PBAC-BAC2-BTP-BTSET', 'PBAC-BAC2-BTP-BTSMA', 'PBAC-BAC2-CDV-CHARG', 'PBAC-BAC2-CDV-TITRE', 'PBAC-BAC2-CDV-TITRE0', 'PBAC-BAC2-CDV-TITRE1', 'PBAC-BAC2-CDV-TITRE2', 'PBAC-BAC2-CHI-BTSBIOC', 'PBAC-BAC2-CHI-BTSME0', 'PBAC-BAC2-ENEX-BTSFEDOM', 'PBAC-BAC2-ENS', 'PBAC-BAC2-ENS-TPFOR', 'PBAC-BAC2-ENT-BTSMA2', 'PBAC-BAC2-ENT-BTSRAUT', 'PBAC-BAC2-ENV', 'PBAC-BAC2-ENV-BTSMEAU', 'PBAC-BAC2-GADF-ASSIS', 'PBAC-BAC2-GADF-TITRE2', 'PBAC-BAC2-GADF-TITRE3', 'PBAC-BAC2-GADF-TITRE4', 'PBAC-BAC2-PUB-BTSER', 'PBAC-BAC2-PUB-BTSER0', 'PBAC-BAC2-SASO-BTSDTS', 'PBAC-BAC2-SASO-BTSPDEN', 'PBAC-BAC2-SASO-TITRE', 'PBAC-BAC2-SASO-TITRE0', 'PBAC-BAC2-SPOR-BTSATRU', 'PBAC-BAC2-TEXT-BTSMANA', 'PBAC-BAC2-TEXT-BTSVET', 'PBAC-BAC2-WEB-CERTI', 'PBAC-BAC2-WEB-CERTI0', 'PBAC-BAC2-WEB-TITRE', 'PBAC-BAC3-AGRI', 'PBAC-BAC3-AGRI-LICEN', 'PBAC-BAC3-ART-DIPLO4', 'PBAC-BAC3-ART-DIPLO9', 'PBAC-BAC3-BAN-CCBFA', 'PBAC-BAC3-BAN-FIN', 'PBAC-BAC3-CDV-BACHE18', 'PBAC-BAC3-CDV-BACHE20', 'PBAC-BAC3-CDV-BACHE22', 'PBAC-BAC3-CDV-BACHE5', 'PBAC-BAC3-CDV-BHIHTM', 'PBAC-BAC3-CDV-BUTTC', 'PBAC-BAC3-CDV-CERTI0', 'PBAC-BAC3-CDV-COMMU', 'PBAC-BAC3-CDV-DEESMA', 'PBAC-BAC3-CDV-LICEN4', 'PBAC-BAC3-CDV-LICEN6', 'PBAC-BAC3-CDV-LICEN7', 'PBAC-BAC3-CDV-LPCMN', 'PBAC-BAC3-CDV-LPCPS', 'PBAC-BAC3-CDV-RESPO1', 'PBAC-BAC3-CDV-RESPO17', 'PBAC-BAC3-CDV-RESPO18', 'PBAC-BAC3-CDV-RESPO19', 'PBAC-BAC3-CDV-RESPO20', 'PBAC-BAC3-CDV-RESPO22', 'PBAC-BAC3-CDV-RESPO23', 'PBAC-BAC3-CDV-TITRE1', 'PBAC-BAC3-CDV-TITRE2', 'PBAC-BAC3-CDV-TITRE4', 'PBAC-BAC3-CHIM-LP16', 'PBAC-BAC3-CHIM-LP8', 'PBAC-BAC3-CULT-IHTM', 'PBAC-BAC3-CULT-LICEN', 'PBAC-BAC3-ENEX', 'PBAC-BAC3-ENEX-LP6', 'PBAC-BAC3-ENS-BEMD', 'PBAC-BAC3-ENS-LEA', 'PBAC-BAC3-ENT', 'PBAC-BAC3-ENT-TITRE', 'PBAC-BAC3-ENV', 'PBAC-BAC3-ENV-LICEN', 'PBAC-BAC3-GADF-ARTGB', 'PBAC-BAC3-GADF-BACHE10', 'PBAC-BAC3-GADF-BACHE2', 'PBAC-BAC3-GADF-BACHE3', 'PBAC-BAC3-GADF-BACHE5', 'PBAC-BAC3-GADF-BACHE9', 'PBAC-BAC3-GADF-BUTGE', 'PBAC-BAC3-GADF-BUTGE0', 'PBAC-BAC3-GADF-CONSE', 'PBAC-BAC3-GADF-DEESARH', 'PBAC-BAC3-GADF-DIPLO', 'PBAC-BAC3-GADF-DREDRH', 'PBAC-BAC3-GADF-FCILA', 'PBAC-BAC3-GADF-LICEN12', 'PBAC-BAC3-GADF-LICEN8', 'PBAC-BAC3-GADF-LP20', 'PBAC-BAC3-GADF-LP24', 'PBAC-BAC3-GADF-LP26', 'PBAC-BAC3-GADF-LP36', 'PBAC-BAC3-GADF-LP5', 'PBAC-BAC3-GADF-MANOR', 'PBAC-BAC3-GADF-RESPO', 'PBAC-BAC3-GADF-RESPO1', 'PBAC-BAC3-GADF-RESPO6', 'PBAC-BAC3-GADF-RESPO7', 'PBAC-BAC3-GADF-RESPO8', 'PBAC-BAC3-GADF-RHRSO', 'PBAC-BAC3-HOT-BACHE0', 'PBAC-BAC3-HOT-HOT', 'PBAC-BAC3-HOT-LICEN', 'PBAC-BAC3-PUB-BACHE0', 'PBAC-BAC3-PUB-BACHE1', 'PBAC-BAC3-PUB-BACHE2', 'PBAC-BAC3-PUB-BUTIN', 'PBAC-BAC3-PUB-CERTOME', 'PBAC-BAC3-PUB-INFC', 'PBAC-BAC3-PUB-LICEN', 'PBAC-BAC3-PUB-RESPO', 'PBAC-BAC3-SPOR-BACHE2', 'PBAC-BAC3-SPOR-BAHOTO', 'PBAC-BAC3-SPOR-LDEES1', 'PBAC-BAC3-SPOR-LP3', 'PBAC-BAC3-SPOR-TOUR', 'PBAC-BAC3-TEXT-BACHE3', 'PBAC-BAC3-TEXT-FORMA', 'PBAC-BAC3-TRAN-AGENT', 'PBAC-BAC3-TRAN-BACHE0', 'PBAC-BAC3-WEB-BACHE', 'PBAC-BAC3-WEB-BACHE0', 'PBAC-BAC3-WEB-BACHE3', 'PBAC-BAC3-WEB-LICEN0', 'PBAC-BAC3-WEB-TITRE', 'PBAC-BAC3-WEB-TITRE0', 'PBAC-BAC45-ART', 'PBAC-BAC45-ART-MASTE', 'PBAC-BAC45-ART-MASTE0', 'PBAC-BAC45-ART-MASTE2', 'PBAC-BAC45-BAI', 'PBAC-BAC45-BAI-MANAG', 'PBAC-BAC45-CDV-MANAG0', 'PBAC-BAC45-CDV-MANAG10', 'PBAC-BAC45-CDV-MANAG11', 'PBAC-BAC45-CDV-MANAG12', 'PBAC-BAC45-CDV-MANAG14', 'PBAC-BAC45-CDV-MANAG18', 'PBAC-BAC45-CDV-MANAG19', 'PBAC-BAC45-CDV-MANAG7', 'PBAC-BAC45-CDV-MANAG9', 'PBAC-BAC45-CDV-MASTE3', 'PBAC-BAC45-CDV-MASTE4', 'PBAC-BAC45-CDV-MASTE7', 'PBAC-BAC45-CDV-MASTE9', 'PBAC-BAC45-CDV-TITRE', 'PBAC-BAC45-GADF-EXPER', 'PBAC-BAC45-GADF-MA49', 'PBAC-BAC45-GADF-MA58', 'PBAC-BAC45-GADF-MANAG5', 'PBAC-BAC45-GADF-MASTE15', 'PBAC-BAC45-GADF-MASTE16', 'PBAC-BAC45-GADF-MIBUS', 'PBAC-BAC45-GADF-SCMA', 'PBAC-BAC45-GADF-TITRE', 'PBAC-BAC45-INF-EXPER1', 'PBAC-BAC45-INF-INF', 'PBAC-BAC45-INF-MANAG0', 'PBAC-BAC45-INF-MASTE2', 'PBAC-BAC45-INF-TITRE', 'PBAC-FPC', 'PBAC-FPC-DISTRI', 'PBAC-FPC-DISTRI-BTSAS', 'PBAC-FPC-DISTRI-BTSMA', 'PBAC-FPC-DISTRI-BTSND', 'PBAC-FPC-DISTRI-TITRE2', 'PBAC-FPC-DISTRI-TITRE3', 'PBAC-FPC-DISTRI-TITRE4', 'PBAC-FPC-DISTRI-TITRE5', 'PBAC-FPC-GADF-BTSCO', 'PBAC-FPC-GADF-DIPLO', 'PBAC-FPC-GADF-FORMA0', 'PBAC-FPC-GADF-LICEN', 'PBAC-FPC-GADF-LICEN0', 'PBAC-FPC-GADF-TITRE', 'PBAC-FPC-GADF-TITRE0', 'PBAC-FPC-GADF-TITRE1', 'PBAC-FPC-GADF-TITRE2', 'PBAC-FPC-INF', 'PBAC-FPC-INF-FCILC', 'PBAC-FPC-PUB', 'PBAC-FPC-PUB-LICEN', 'PBAC-FPC-SANT-CADRE', 'PBAC-FPC-SANT-TITRE', 'PBAC-FPC-TXTS', 'PBAC-ING-ENV', 'PBAC-ING-ENV-SENVPRV', 'PBAC-PREPA-BTP', 'PBAC-PREPA-BTP-ARTARC', 'PBAC-PREPA-CUL-CCPEA', 'PBAC-PREPA-ENS-CPGESCP', 'PBAC-PREPA-GADF-CPCCE', 'PBAC-PREPA-GADF-CPECO', 'PBAC-PREPA-GADF-CPECOM', 'PBAC-PREPA-MAUT-CPGETSI', 'PBAC-PREPA-SASO-CLASS0', 'PBAC-PREPA-SASO-CMED', 'PBAC-PREPA-SASO-CPCSSS', 'PBAC-PREPA-SASO-CPMED', 'PBAC-PREPA-SASO-CPPARAERG', 'PBAC-PREPA-SASO-CPPARAINF', 'PBAC-PREPA-SASO-ESSASS', 'PBAC-PREPA-SASO-ESSEDJE', 'PBAC-PREPA-SASO-ESSEDSP', 'PBAC-PREPA-SASO-FCILPARAS', 'PBAC-PREPA-TXTS', 'PBAC-SPEC-REEN', 'PBAC-TARIFS-INSC-BAC+4-5') AND i0_.id LIKE 'PBAC-BAC2-GADF%' ORDER BY i0_.libelle ASC;

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

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 'PBAC-BAC2-%' AND i0_.id IN ('PBAC-BAC2-GADF', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-TEL', 'PBAC-COORD-MAIL', 'PBAC-COORD-WEB', 'PBAC-PRES', 'PBAC-ACCU', 'PBAC-BAC2-CDV', 'PBAC-SPEC', 'PBAC-BAC2-GADF-BTSCO', 'PBAC-BAC2-GADF-BTSGE', 'PBAC-PRES-CHE', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC3-GADF', 'PBAC-COORD-FAX', 'PBAC-BAC2-GADF-BTSSU', 'PBAC-ACCU-ACCE', 'PBAC-ACCU-CANT', 'PBAC-BAC2-CDV-BTSNE', 'PBAC-BAC3-CDV', 'PBAC-PRES-SCO', 'PBAC-SPEC-ADMI', 'PBAC-ACCU-BOUR', 'PBAC-PRES-NBE', 'PBAC-SPEC-IGEN', 'PBAC-PRES-DTEUR', 'PBAC-PRES-TUT', 'PBAC-ACCU-EXT', 'PBAC-BAC45-GADF', 'PBAC-ACCU-INTA', 'PBAC-BAC2-WEB', 'PBAC-BAC2-SASO', 'PBAC-ACCU-CAF', 'PBAC-BAC2-PUB', 'PBAC-BAC2-BAI', 'PBAC-BAC2-PUB-BTSCOM', 'PBAC-BAC2-WEB-BTSINFR', 'PBAC-SPEC-ENTR', 'PBAC-ACCU-MIXT', 'PBAC-BAC2-WEB-BTSSLAM', 'PBAC-BAC3-GADF-DCG', 'PBAC-SPEC-TXTS51', 'PBAC-PRES-NID', 'PBAC-SPEC-TXTS', 'PBAC-ACCU-HAND_MT', 'PBAC', 'PBAC-BAC2-BAI-BTSPRI', 'PBAC-BAC3-PUB', 'PBAC-BAC2-SASO-BTSSASO', 'PBAC-BAC45-CDV', 'PBAC-PRES-AUTR1_MT', 'PBAC-BAC2-CDV-BTSCOMI', 'PBAC-BAC2-SPOR', 'PBAC-BAC45-GADF-DSCG', 'PBAC-BAC2-SPOR-BTSTOU', 'PBAC-PRES-HCO', 'PBAC-SPEC-INTE', 'PBAC-BAC3-WEB', 'PBAC-SPEC-TXTS52', 'PBAC-BAC2-CDV-BTSCO', 'PBAC-PRES-DTRICE', 'PBAC-ACCU-HEB', 'PBAC-ACCU-TXTS53', 'PBAC-BAC2-GADF-BTSCO0', 'PBAC-BAC2-SASO-BTSESF', 'PBAC-BAC2-TRAN', 'PBAC-BAC2-TRAN-BTSGE', 'PBAC-PREPA-SASO', 'PBAC-SPEC-CAMP', 'PBAC-BAC2', 'PBAC-BAC3-BAN', 'PBAC-BAC3-CDV-LICEN2', 'PBAC-LOGO', 'PBAC-TEXTC1_MT', 'PBAC-BAC2-BAI-BTSAS', 'PBAC-BAC3', 'PBAC-BAC45-GADF-MANAG0', 'PBAC-PREPA-COM', 'PBAC-PRES-TXTS', 'PBAC-TARIFS', 'PBAC-BAC2-GADF-BTSMA', 'PBAC-TARIFS-RCOMPL', 'PBAC-ACCU-TXTS', 'PBAC-BAC2-TXTS', 'PBAC-BAC2-WEB-BTSCI', 'PBAC-BAC3-GADF-BACHE', 'PBAC-BAC3-SASO', 'PBAC-BAC3-SASO-CESF', 'PBAC-BAC3-SPOR', 'PBAC-BAC45', 'PBAC-BAC45-INF', 'PBAC-PREPA-MAUT', 'PBAC-TARIFS-INSC', 'PBAC-BAC2-CHI', 'PBAC-BAC3-BAN-BACHE4', 'PBAC-BAC3-PUB-BACHE', 'PBAC-ACCU-TXTS54', 'PBAC-BAC2-AUT', 'PBAC-BAC2-BAI-BANQU', 'PBAC-BAC2-ELEC', 'PBAC-BAC2-ELEC-BTSELEC', 'PBAC-BAC2-ENT', 'PBAC-BAC2-ENT-BTSMA', 'PBAC-BAC2-GADF-TITRE', 'PBAC-BAC2-WEB-BTSCI0', 'PBAC-BAC3-TXTS0', 'PBAC-BAC45-TXTS0', 'PBAC-PREPA-COM-CGPEECE', 'PBAC-TARIFS-INSC-BAC+2', 'PBAC-TARIFS-MODAL', 'PBAC-BAC2-TEXT', 'PBAC-BAC2-TXTS0', 'PBAC-BAC3-CDV-BACHE16', 'PBAC-BAC3-CDV-BRESDEVC', 'PBAC-BAC3-CDV-RESPO3', 'PBAC-BAC3-GADF-GESRH', 'PBAC-BAC3-GADF-LP25', 'PBAC-BAC3-GADF-RESPO5', 'PBAC-BAC3-TXTS', 'PBAC-BAC3-WEB-INF', 'PBAC-PRES-AUTR2_MT', 'PBAC-BAC2-AUT-BTSSAUT', 'PBAC-BAC2-CDV-ATCOM', 'PBAC-BAC2-GADF-TITRE0', 'PBAC-BAC2-GADF-TITRE1', 'PBAC-BAC2-HOT', 'PBAC-BAC2-HOT-BTSMA0', 'PBAC-BAC2-HOT-BTSMA1', 'PBAC-BAC2-SASO-BTSDIE', 'PBAC-BAC3-ART', 'PBAC-BAC3-CDV-BACHE6', 'PBAC-BAC3-CDV-BGB', 'PBAC-BAC3-CDV-COMDI', 'PBAC-BAC3-GADF-CHARG1', 'PBAC-BAC3-GADF-GESTEN', 'PBAC-BAC3-GADF-LICEN0', 'PBAC-BAC3-GADF-LP35', 'PBAC-BAC3-GADF-MANAG', 'PBAC-BAC3-PUB-BACHE3', 'PBAC-BAC3-PUB-BACHE7', 'PBAC-BAC3-TEXT', 'PBAC-BAC3-WEB-BACHE4', 'PBAC-BAC3-WEB-TITRE2', 'PBAC-BAC45-CDV-MANAG15', 'PBAC-BAC45-CDV-MANAG6', 'PBAC-BAC45-CDV-MASTE2', 'PBAC-BAC45-GADF-CONTR', 'PBAC-BAC45-GADF-DNOT', 'PBAC-BAC45-GADF-MA50', 'PBAC-BAC45-INF-MASTE3', 'PBAC-COORD-TXTS', 'PBAC-FPC-GADF', 'PBAC-PREPA', 'PBAC-PREPA-CHI', 'PBAC-PREPA-CHI-CGPEMP', 'PBAC-PREPA-CHI-CGPEPC', 'PBAC-PREPA-CHI-CGPEPCSI', 'PBAC-PREPA-COM-CGPEECS', 'PBAC-PREPA-COM-CGPEECT', 'PBAC-PREPA-MAUT-CPGEMPSI', 'LYC-ACCU', 'LYC-ACCU-CANT', 'LYC-ACCU-EXT', 'LYC-BACTEC-GADF', 'LYC-COORD', 'LYC-COORD-ADR', 'LYC-COORD-MAIL', 'LYC-COORD-TEL', 'LYC-COORD-WEB', 'LYC-FORMA2021', 'LYC-FORMA2021-GFACU', 'LYC-FORMA2021-GFACU-GFACULANG', 'LYC-FORMA2021-SPEC', 'LYC-FORMA2021-SPEC-SPECHIST', 'LYC-FORMA2021-SPEC-SPECHUM', 'LYC-FORMA2021-SPEC-SPECLANG', 'LYC-FORMA2021-SPEC-SPECMAT', 'LYC-FORMA2021-SPEC-SPECNUM', 'LYC-FORMA2021-SPEC-SPECPHY', 'LYC-FORMA2021-SPEC-SPECSES', 'LYC-FORMA2021-SPEC-SPECSVT', 'LYC-LANG', 'LYC-LANG-LV1', 'LYC-LANG-LV1-ANG', 'LYC-LANG-LV2', 'LYC-LANG-LV2-ALL', 'LYC-LANG-LV2-ESP', 'LYC-LANG-LV3', 'LYC-LANG-LV3-ITA', 'LYC-PRES', 'LYC-PRES-NBE', 'LYC-PRES-SCO', 'LYC-SPEC', 'LYC-SPEC-TXTS33', 'PBAC-BAC2-CHI-BTSABM', 'PBAC-BAC2-CHI-BTSME', 'PBAC-BAC2-ENEX', 'PBAC-BAC2-ENEX-BTSFL', 'PBAC-BAC2-GADF-TITRE5', 'PBAC-BAC2-GADF-TITRE6', 'PBAC-BAC2-HOT-BTSMA', 'PBAC-BAC2-SASO-BTSOPT', 'PBAC-BAC2-SASO-DEUST', 'PBAC-BAC2-SPOR-CERTI', 'PBAC-BAC2-SPOR-CERTI0', 'PBAC-BAC2-SPOR-MCANI', 'PBAC-BAC2-TEXT-BTSCOSM', 'PBAC-BAC2-TEXT-BTSMARQ', 'PBAC-BAC2-WEB-CERTI1', 'PBAC-BAC3-ART-DIPLO2', 'PBAC-BAC3-BAN-BACHE2', 'PBAC-BAC3-CDV-BACHE19', 'PBAC-BAC3-CDV-BACHE3', 'PBAC-BAC3-CDV-BACHE4', 'PBAC-BAC3-CDV-BAHON', 'PBAC-BAC3-CDV-BGM', 'PBAC-BAC3-CDV-BGMC', 'PBAC-BAC3-CDV-LICEN8', 'PBAC-BAC3-CDV-MMOP', 'PBAC-BAC3-CDV-RESPO4', 'PBAC-BAC3-CDV-TITRE3', 'PBAC-BAC3-CHIM', 'PBAC-BAC3-CULT', 'PBAC-BAC3-ENS', 'PBAC-BAC3-GADF-BACHE0', 'PBAC-BAC3-GADF-CERTI0', 'PBAC-BAC3-GADF-CONTR', 'PBAC-BAC3-GADF-GEST', 'PBAC-BAC3-GADF-GRH', 'PBAC-BAC3-GADF-LP33', 'PBAC-BAC3-GADF-LP38', 'PBAC-BAC3-GADF-MENOT', 'PBAC-BAC3-HOT', 'PBAC-BAC3-PUB-BCOMNUM', 'PBAC-BAC3-SPOR-BACHE', 'PBAC-BAC3-TEXT-BACHE', 'PBAC-BAC3-TRAN', 'PBAC-BAC3-WEB-BACHE1', 'PBAC-BAC3-WEB-BRCDSM', 'PBAC-BAC3-WEB-LICEN1', 'PBAC-BAC45-CDV-MANAG17', 'PBAC-BAC45-GADF-MA6', 'PBAC-BAC45-GADF-MBAMA2', 'PBAC-BAC45-GADF-RH', 'PBAC-BAC45-GADF-TMRH', 'PBAC-BAC45-TXTS', 'PBAC-FPC-SANT', 'PBAC-PREPA-COM-PREPA', 'PBAC-PREPA-CUL', 'PBAC-PREPA-CUL-MANAA', 'PBAC-PREPA-ENS', 'PBAC-PREPA-ENS-CPGELSS', 'PBAC-PREPA-GADF', 'PBAC-PREPA-MAUT-CPATS', 'PBAC-PREPA-MAUT-CPGEPSI', 'PBAC-PREPA-SASO-CEINF', 'PBAC-PREPA-SASO-CIFSI', 'PBAC-PREPA-SASO-CPPARA', 'PBAC-PREPA-TXTS0', 'PBAC-TARIFS-INSC-BAC+3', 'PBAC-TARIFS-INSC-PREPA', 'LYC-ACCU-ACCE', 'LYC-ACCU-BOUR', 'LYC-ACCU-CAF', 'LYC-ACCU-MIXT', 'LYC-ACCU-TXTS36', 'LYC-BACTEC', 'LYC-BACTEC-BTP', 'LYC-BACTEC-BTP-BACST', 'LYC-BACTEC-CDV', 'LYC-BACTEC-CDV-STMG', 'LYC-BACTEC-GADF-BACST', 'LYC-BACTEC-GADF-STMGGF', 'LYC-BACTEC-GADF-STMGRHC', 'LYC-BACTEC-TFACU', 'LYC-BACTEC-TFACU-ARTS', 'LYC-BACTEC-TFACU-LV3', 'LYC-BACTEC-WEB', 'LYC-BACTEC-WEB-STMGSIG', 'LYC-COORD-FAX', 'LYC-FORMA2021-GFACU-GFACUARTS', 'LYC-FORMA2021-GFACU-GFACUDROI', 'LYC-FORMA2021-GFACU-GFACUEPS', 'LYC-FORMA2021-GFACU-GFACULV3', 'LYC-FORMA2021-GFACU-GFACUMATC', 'LYC-FORMA2021-GFACU-GFACUMATE', 'LYC-FORMA2021-SPEC-SPECARTS', 'LYC-FORMA2021-SPEC-SPECING', 'LYC-FORMA2021-SPEC-SPECLLCA', 'LYC-FORMA2021-SPEC-SPORT', 'LYC-LANG-ANC_MT', 'LYC-LANG-ANC_MT-LAT', 'LYC-LANG-CERT', 'LYC-LANG-EUR', 'LYC-LANG-LSF', 'LYC-LANG-LV1-ALL', 'LYC-LANG-LV2-ITA', 'LYC-LANG-LV3-ALL', 'LYC-LANG-LV3-CHI', 'LYC-LANG-LV3-ESP', 'LYC-LANG-TXTS', 'LYC-PRES-AUTR1_MT', 'LYC-PRES-AUTR2_MT', 'LYC-PRES-CHE', 'LYC-PRES-DTEUR', 'LYC-PRES-NID', 'LYC-PRES-TUT', 'LYC-SPEC-2SGT', 'LYC-SPEC-ACC', 'LYC-SPEC-ACC-ULIS', 'LYC-SPEC-ART', 'LYC-SPEC-ASPO', 'LYC-SPEC-BDI', 'LYC-SPEC-BIA', 'LYC-SPEC-CDI', 'LYC-SPEC-EXP', 'LYC-SPEC-JUM', 'LYC-SPEC-OPTE', 'LYC-SPEC-PIX', 'LYC-SPEC-PREP', 'LYC-SPEC-PSC1', 'LYC-SPEC-REPA', 'LYC-SPEC-SCI', 'LYC-SPEC-SLIN', 'LYC-SPEC-SPOR', 'LYC-SPEC-TXTS32', 'LYC-SPEC-TXTS40', 'LYC-SPEC-VOY', 'LYCPRO-ACCU', 'LYCPRO-ACCU-ACCE', 'LYCPRO-ACCU-BOUR', 'LYCPRO-ACCU-CAF', 'LYCPRO-ACCU-CANT', 'LYCPRO-ACCU-EXT', 'LYCPRO-ACCU-MIXT', 'LYCPRO-BACP-DISTRI', 'LYCPRO-BACP-DISTRI-BACPR2', 'LYCPRO-BACP-DISTRI-BACPR3', 'LYCPRO-BACP-INF', 'LYCPRO-BACP-INF-BACPR0', 'LYCPRO-BACP-TEXT', 'LYCPRO-BACP-TEXT-BPRCOS', 'LYCPRO-COORD', 'LYCPRO-COORD-ADR', 'LYCPRO-COORD-FAX', 'LYCPRO-COORD-MAIL', 'LYCPRO-COORD-TEL', 'LYCPRO-COORD-WEB', 'LYCPRO-LANG', 'LYCPRO-LANG-LV1', 'LYCPRO-LANG-LV1-ANG', 'LYCPRO-LANG-LV2', 'LYCPRO-LANG-LV2-ALL', 'LYCPRO-LANG-LV2-ESP', 'LYCPRO-LANG-LV2-ITA', 'LYCPRO-PRES', 'LYCPRO-PRES-CHE', 'LYCPRO-PRES-NBE', 'LYCPRO-PRES-NID', 'LYCPRO-PRES-SCO', 'LYCPRO-PRES-TUT', 'LYCPRO-SPEC', 'LYCPRO-SPEC-ACC', 'LYCPRO-SPEC-ACC-ULIS', 'LYCPRO-SPEC-ASPO', 'LYCPRO-SPEC-BDI', 'LYCPRO-SPEC-BIA', 'LYCPRO-SPEC-CDI', 'LYCPRO-SPEC-CUL', 'LYCPRO-SPEC-EUR', 'LYCPRO-SPEC-PIX', 'LYCPRO-SPEC-PMET', 'LYCPRO-SPEC-SLIN', 'LYCPRO-SPEC-TXTS50', 'LYCPRO-SPEC-VOY', 'PBAC-BAC2-AGRI', 'PBAC-BAC2-AGRI-BTSAM', 'PBAC-BAC2-AUT-BTSTEIN', 'PBAC-BAC2-AUT-FCILP', 'PBAC-BAC2-BTP', 'PBAC-BAC2-BTP-BTSET', 'PBAC-BAC2-BTP-BTSMA', 'PBAC-BAC2-CDV-CHARG', 'PBAC-BAC2-CDV-TITRE', 'PBAC-BAC2-CDV-TITRE0', 'PBAC-BAC2-CDV-TITRE1', 'PBAC-BAC2-CDV-TITRE2', 'PBAC-BAC2-CHI-BTSBIOC', 'PBAC-BAC2-CHI-BTSME0', 'PBAC-BAC2-ENEX-BTSFEDOM', 'PBAC-BAC2-ENS', 'PBAC-BAC2-ENS-TPFOR', 'PBAC-BAC2-ENT-BTSMA2', 'PBAC-BAC2-ENT-BTSRAUT', 'PBAC-BAC2-ENV', 'PBAC-BAC2-ENV-BTSMEAU', 'PBAC-BAC2-GADF-ASSIS', 'PBAC-BAC2-GADF-TITRE2', 'PBAC-BAC2-GADF-TITRE3', 'PBAC-BAC2-GADF-TITRE4', 'PBAC-BAC2-PUB-BTSER', 'PBAC-BAC2-PUB-BTSER0', 'PBAC-BAC2-SASO-BTSDTS', 'PBAC-BAC2-SASO-BTSPDEN', 'PBAC-BAC2-SASO-TITRE', 'PBAC-BAC2-SASO-TITRE0', 'PBAC-BAC2-SPOR-BTSATRU', 'PBAC-BAC2-TEXT-BTSMANA', 'PBAC-BAC2-TEXT-BTSVET', 'PBAC-BAC2-WEB-CERTI', 'PBAC-BAC2-WEB-CERTI0', 'PBAC-BAC2-WEB-TITRE', 'PBAC-BAC3-AGRI', 'PBAC-BAC3-AGRI-LICEN', 'PBAC-BAC3-ART-DIPLO4', 'PBAC-BAC3-ART-DIPLO9', 'PBAC-BAC3-BAN-CCBFA', 'PBAC-BAC3-BAN-FIN', 'PBAC-BAC3-CDV-BACHE18', 'PBAC-BAC3-CDV-BACHE20', 'PBAC-BAC3-CDV-BACHE22', 'PBAC-BAC3-CDV-BACHE5', 'PBAC-BAC3-CDV-BHIHTM', 'PBAC-BAC3-CDV-BUTTC', 'PBAC-BAC3-CDV-CERTI0', 'PBAC-BAC3-CDV-COMMU', 'PBAC-BAC3-CDV-DEESMA', 'PBAC-BAC3-CDV-LICEN4', 'PBAC-BAC3-CDV-LICEN6', 'PBAC-BAC3-CDV-LICEN7', 'PBAC-BAC3-CDV-LPCMN', 'PBAC-BAC3-CDV-LPCPS', 'PBAC-BAC3-CDV-RESPO1', 'PBAC-BAC3-CDV-RESPO17', 'PBAC-BAC3-CDV-RESPO18', 'PBAC-BAC3-CDV-RESPO19', 'PBAC-BAC3-CDV-RESPO20', 'PBAC-BAC3-CDV-RESPO22', 'PBAC-BAC3-CDV-RESPO23', 'PBAC-BAC3-CDV-TITRE1', 'PBAC-BAC3-CDV-TITRE2', 'PBAC-BAC3-CDV-TITRE4', 'PBAC-BAC3-CHIM-LP16', 'PBAC-BAC3-CHIM-LP8', 'PBAC-BAC3-CULT-IHTM', 'PBAC-BAC3-CULT-LICEN', 'PBAC-BAC3-ENEX', 'PBAC-BAC3-ENEX-LP6', 'PBAC-BAC3-ENS-BEMD', 'PBAC-BAC3-ENS-LEA', 'PBAC-BAC3-ENT', 'PBAC-BAC3-ENT-TITRE', 'PBAC-BAC3-ENV', 'PBAC-BAC3-ENV-LICEN', 'PBAC-BAC3-GADF-ARTGB', 'PBAC-BAC3-GADF-BACHE10', 'PBAC-BAC3-GADF-BACHE2', 'PBAC-BAC3-GADF-BACHE3', 'PBAC-BAC3-GADF-BACHE5', 'PBAC-BAC3-GADF-BACHE9', 'PBAC-BAC3-GADF-BUTGE', 'PBAC-BAC3-GADF-BUTGE0', 'PBAC-BAC3-GADF-CONSE', 'PBAC-BAC3-GADF-DEESARH', 'PBAC-BAC3-GADF-DIPLO', 'PBAC-BAC3-GADF-DREDRH', 'PBAC-BAC3-GADF-FCILA', 'PBAC-BAC3-GADF-LICEN12', 'PBAC-BAC3-GADF-LICEN8', 'PBAC-BAC3-GADF-LP20', 'PBAC-BAC3-GADF-LP24', 'PBAC-BAC3-GADF-LP26', 'PBAC-BAC3-GADF-LP36', 'PBAC-BAC3-GADF-LP5', 'PBAC-BAC3-GADF-MANOR', 'PBAC-BAC3-GADF-RESPO', 'PBAC-BAC3-GADF-RESPO1', 'PBAC-BAC3-GADF-RESPO6', 'PBAC-BAC3-GADF-RESPO7', 'PBAC-BAC3-GADF-RESPO8', 'PBAC-BAC3-GADF-RHRSO', 'PBAC-BAC3-HOT-BACHE0', 'PBAC-BAC3-HOT-HOT', 'PBAC-BAC3-HOT-LICEN', 'PBAC-BAC3-PUB-BACHE0', 'PBAC-BAC3-PUB-BACHE1', 'PBAC-BAC3-PUB-BACHE2', 'PBAC-BAC3-PUB-BUTIN', 'PBAC-BAC3-PUB-CERTOME', 'PBAC-BAC3-PUB-INFC', 'PBAC-BAC3-PUB-LICEN', 'PBAC-BAC3-PUB-RESPO', 'PBAC-BAC3-SPOR-BACHE2', 'PBAC-BAC3-SPOR-BAHOTO', 'PBAC-BAC3-SPOR-LDEES1', 'PBAC-BAC3-SPOR-LP3', 'PBAC-BAC3-SPOR-TOUR', 'PBAC-BAC3-TEXT-BACHE3', 'PBAC-BAC3-TEXT-FORMA', 'PBAC-BAC3-TRAN-AGENT', 'PBAC-BAC3-TRAN-BACHE0', 'PBAC-BAC3-WEB-BACHE', 'PBAC-BAC3-WEB-BACHE0', 'PBAC-BAC3-WEB-BACHE3', 'PBAC-BAC3-WEB-LICEN0', 'PBAC-BAC3-WEB-TITRE', 'PBAC-BAC3-WEB-TITRE0', 'PBAC-BAC45-ART', 'PBAC-BAC45-ART-MASTE', 'PBAC-BAC45-ART-MASTE0', 'PBAC-BAC45-ART-MASTE2', 'PBAC-BAC45-BAI', 'PBAC-BAC45-BAI-MANAG', 'PBAC-BAC45-CDV-MANAG0', 'PBAC-BAC45-CDV-MANAG10', 'PBAC-BAC45-CDV-MANAG11', 'PBAC-BAC45-CDV-MANAG12', 'PBAC-BAC45-CDV-MANAG14', 'PBAC-BAC45-CDV-MANAG18', 'PBAC-BAC45-CDV-MANAG19', 'PBAC-BAC45-CDV-MANAG7', 'PBAC-BAC45-CDV-MANAG9', 'PBAC-BAC45-CDV-MASTE3', 'PBAC-BAC45-CDV-MASTE4', 'PBAC-BAC45-CDV-MASTE7', 'PBAC-BAC45-CDV-MASTE9', 'PBAC-BAC45-CDV-TITRE', 'PBAC-BAC45-GADF-EXPER', 'PBAC-BAC45-GADF-MA49', 'PBAC-BAC45-GADF-MA58', 'PBAC-BAC45-GADF-MANAG5', 'PBAC-BAC45-GADF-MASTE15', 'PBAC-BAC45-GADF-MASTE16', 'PBAC-BAC45-GADF-MIBUS', 'PBAC-BAC45-GADF-SCMA', 'PBAC-BAC45-GADF-TITRE', 'PBAC-BAC45-INF-EXPER1', 'PBAC-BAC45-INF-INF', 'PBAC-BAC45-INF-MANAG0', 'PBAC-BAC45-INF-MASTE2', 'PBAC-BAC45-INF-TITRE', 'PBAC-FPC', 'PBAC-FPC-DISTRI', 'PBAC-FPC-DISTRI-BTSAS', 'PBAC-FPC-DISTRI-BTSMA', 'PBAC-FPC-DISTRI-BTSND', 'PBAC-FPC-DISTRI-TITRE2', 'PBAC-FPC-DISTRI-TITRE3', 'PBAC-FPC-DISTRI-TITRE4', 'PBAC-FPC-DISTRI-TITRE5', 'PBAC-FPC-GADF-BTSCO', 'PBAC-FPC-GADF-DIPLO', 'PBAC-FPC-GADF-FORMA0', 'PBAC-FPC-GADF-LICEN', 'PBAC-FPC-GADF-LICEN0', 'PBAC-FPC-GADF-TITRE', 'PBAC-FPC-GADF-TITRE0', 'PBAC-FPC-GADF-TITRE1', 'PBAC-FPC-GADF-TITRE2', 'PBAC-FPC-INF', 'PBAC-FPC-INF-FCILC', 'PBAC-FPC-PUB', 'PBAC-FPC-PUB-LICEN', 'PBAC-FPC-SANT-CADRE', 'PBAC-FPC-SANT-TITRE', 'PBAC-FPC-TXTS', 'PBAC-ING-ENV', 'PBAC-ING-ENV-SENVPRV', 'PBAC-PREPA-BTP', 'PBAC-PREPA-BTP-ARTARC', 'PBAC-PREPA-CUL-CCPEA', 'PBAC-PREPA-ENS-CPGESCP', 'PBAC-PREPA-GADF-CPCCE', 'PBAC-PREPA-GADF-CPECO', 'PBAC-PREPA-GADF-CPECOM', 'PBAC-PREPA-MAUT-CPGETSI', 'PBAC-PREPA-SASO-CLASS0', 'PBAC-PREPA-SASO-CMED', 'PBAC-PREPA-SASO-CPCSSS', 'PBAC-PREPA-SASO-CPMED', 'PBAC-PREPA-SASO-CPPARAERG', 'PBAC-PREPA-SASO-CPPARAINF', 'PBAC-PREPA-SASO-ESSASS', 'PBAC-PREPA-SASO-ESSEDJE', 'PBAC-PREPA-SASO-ESSEDSP', 'PBAC-PREPA-SASO-FCILPARAS', 'PBAC-PREPA-TXTS', 'PBAC-SPEC-REEN', 'PBAC-TARIFS-INSC-BAC+4-5') GROUP BY i0_.id ORDER BY i0_.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_.onglets LIKE ?
  AND 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_.onglets LIKE '%superieur%' AND 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
  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

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', '30189', '33063', '69385', '69387', '77288', '10387', '13206', '35238', '42218', '44109', '49007', '49099', '59350', '59512', '59606', '75106', '75114', '75119', '92044', '01053', '01071', '06069', '06088', '07010', '07319', '07324', '08105', '09225', '13028', '13103', '13204', '13207', '13209', '13212', '14118', '16015', '18033', '19031', '21231', '22070', '22187', '22278', '24322', '25056', '26010', '28253', '30007', '30132', '31555', '34032', '34172', '37050', '38421', '38516', '38563', '41018', '42103', '42187', '42323', '43157', '43268', '45155', '47001', '49328', '50025', '51108', '51454', '52121', '52448', '55029', '55545', '56260', '57606', '58194', '59009', '59122', '59178', '59183', '59295', '59360', '60159', '61001', '62498', '63075', '64445', '65440', '66136', '69149', '69381', '69383', '72181', '73011', '74224', '75107', '75110', '75113', '75115', '75116', '76451') ORDER BY t0.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,
  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
  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,
  v0_.departement_id AS departement_id_10,
  v1_.ville_id AS ville_id_11
FROM
  ville v0_
  LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id
WHERE
  v0_.slug = ?
LIMIT
  1

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, v0_.departement_id AS departement_id_10, v1_.ville_id AS ville_id_11 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id WHERE v0_.slug = 'niveau' LIMIT 1;

SELECT
  a0_.slug AS slug_0,
  a0_.libelle AS libelle_1,
  a0_.id AS id_2,
  a0_.maj AS maj_3,
  a0_.region_id AS region_id_4
FROM
  ancienne_region a0_

SELECT a0_.slug AS slug_0, a0_.libelle AS libelle_1, a0_.id AS id_2, a0_.maj AS maj_3, a0_.region_id AS region_id_4 FROM ancienne_region a0_;

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