Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.lastconection AS lastconection_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.google_id AS google_id_7,
  t0.google_access_token AS google_access_token_8,
  t0.facebook_id AS facebook_id_9,
  t0.facebook_access_token AS facebook_access_token_10,
  t0.is_verified AS is_verified_11,
  t0.def_menu AS def_menu_12,
  t0.akademikoak_fiels AS akademikoak_fiels_13,
  t0.pertsonalak_fields AS pertsonalak_fields_14
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.lastconection AS lastconection_4, t0.roles AS roles_5, t0.password AS password_6, t0.google_id AS google_id_7, t0.google_access_token AS google_access_token_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.is_verified AS is_verified_11, t0.def_menu AS def_menu_12, t0.akademikoak_fiels AS akademikoak_fiels_13, t0.pertsonalak_fields AS pertsonalak_fields_14 FROM user t0 WHERE t0.id = 2 LIMIT 1;

SELECT
  t0.ID_baimena AS ID_baimena_1,
  t0.kodea AS kodea_2,
  t0.multxoa AS multxoa_3,
  t0.ordena AS ordena_4,
  t0.azalpena AS azalpena_5,
  t0.descripcion AS descripcion_6,
  t0.baimendutakorolak AS baimendutakorolak_7,
  t0.langilerola AS langilerola_8,
  t0.ID_menuitem AS ID_menuitem_9,
  t10.ID_menuitem AS ID_menuitem_11,
  t10.ordena AS ordena_12,
  t10.tagId AS tagId_13,
  t10.izena AS izena_14,
  t10.nombre AS nombre_15,
  t10.path AS path_16,
  t10.itxura AS itxura_17,
  t10.fontawesome AS fontawesome_18,
  t10.target AS target_19,
  t10.parentmenu AS parentmenu_20,
  t10.gutxienekobaimena AS gutxienekobaimena_21
FROM
  baimena t0
  LEFT JOIN menuitem t10 ON t10.gutxienekobaimena = t0.ID_baimena
WHERE
  t0.kodea = ?
LIMIT
  1

SELECT t0.ID_baimena AS ID_baimena_1, t0.kodea AS kodea_2, t0.multxoa AS multxoa_3, t0.ordena AS ordena_4, t0.azalpena AS azalpena_5, t0.descripcion AS descripcion_6, t0.baimendutakorolak AS baimendutakorolak_7, t0.langilerola AS langilerola_8, t0.ID_menuitem AS ID_menuitem_9, t10.ID_menuitem AS ID_menuitem_11, t10.ordena AS ordena_12, t10.tagId AS tagId_13, t10.izena AS izena_14, t10.nombre AS nombre_15, t10.path AS path_16, t10.itxura AS itxura_17, t10.fontawesome AS fontawesome_18, t10.target AS target_19, t10.parentmenu AS parentmenu_20, t10.gutxienekobaimena AS gutxienekobaimena_21 FROM baimena t0 LEFT JOIN menuitem t10 ON t10.gutxienekobaimena = t0.ID_baimena WHERE t0.kodea = 'Esk_bete' LIMIT 1;

SELECT
  t0.ID_setup AS ID_setup_1,
  t0.infoEmail AS infoEmail_2,
  t0.herria AS herria_3,
  t0.eskolaIzena AS eskolaIzena_4,
  t0.nombreEscuela AS nombreEscuela_5,
  t0.domeinua AS domeinua_6,
  t0.headerImg AS headerImg_7,
  t0.logoUdalaImg AS logoUdalaImg_8,
  t0.logoExtraImg AS logoExtraImg_9,
  t0.logoEskolaImg AS logoEskolaImg_10,
  t0.infoIzena AS infoIzena_11,
  t0.infoLOPD AS infoLOPD_12,
  t0.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_13,
  t0.matrikulaznb AS matrikulaznb_14,
  t0.bajaznb AS bajaznb_15,
  t0.zenbatebaluaketa AS zenbatebaluaketa_16,
  t0.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_17,
  t0.modulogainditzekoazterketa AS modulogainditzekoazterketa_18,
  t0.multisede AS multisede_19,
  t0.multibilera AS multibilera_20,
  t0.remesaksortu AS remesaksortu_21,
  t0.urtekoakuota AS urtekoakuota_22,
  t0.zenbatkuota AS zenbatkuota_23,
  t0.sepaEmpresaIzena AS sepaEmpresaIzena_24,
  t0.sepaEmpresaIban AS sepaEmpresaIban_25,
  t0.sepaEmpresaBic AS sepaEmpresaBic_26,
  t0.sepaEmpresaIdentifikatzailea AS sepaEmpresaIdentifikatzailea_27,
  t0.sepaAktibatuta AS sepaAktibatuta_28,
  t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_29,
  t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_30,
  t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_31,
  t0.kuotaproporzionala AS kuotaproporzionala_32,
  t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_33,
  t0.bajanDesaktibazioData AS bajanDesaktibazioData_34,
  t0.bajaOnartuAutomatikoki AS bajaOnartuAutomatikoki_35,
  t0.eskeintzaMuga AS eskeintzaMuga_36,
  t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_37,
  t0.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_38,
  t0.notaknibelekakolorez AS notaknibelekakolorez_39,
  t0.espezialitateanKurtsorikEz AS espezialitateanKurtsorikEz_40,
  t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_41,
  t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_42,
  t0.dirulaguntzak AS dirulaguntzak_43,
  t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_44,
  t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_45,
  t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_46,
  t0.onartualumni AS onartualumni_47,
  t0.whatsappbidezinformazioa AS whatsappbidezinformazioa_48,
  t0.gurasoeninformaziorakohizkuntza AS gurasoeninformaziorakohizkuntza_49,
  t0.dokumentoenPolitika AS dokumentoenPolitika_50,
  t0.lanaldiRegistroa AS lanaldiRegistroa_51,
  t0.asistentziaBakarrikX AS asistentziaBakarrikX_52,
  t0.faltaJustifikatuak AS faltaJustifikatuak_53,
  t0.komunikazioakIlaraBitartez AS komunikazioakIlaraBitartez_54,
  t0.akademikoaEgoeraAldatuJakinarazi AS akademikoaEgoeraAldatuJakinarazi_55,
  t0.ordutegiAldaketaJakinarazi AS ordutegiAldaketaJakinarazi_56,
  t0.faltakGurasoeiJakinarazi AS faltakGurasoeiJakinarazi_57,
  t0.faltajustifituakIrakasleeiJakinarazi AS faltajustifituakIrakasleeiJakinarazi_58,
  t0.delayJakinarazpenakBidaltzeko AS delayJakinarazpenakBidaltzeko_59,
  t0.autosortuEskeintzaIkasturteBerria AS autosortuEskeintzaIkasturteBerria_60,
  t0.autosortuKuotaMatrikulaIkasturteBerria AS autosortuKuotaMatrikulaIkasturteBerria_61,
  t0.autosortuEgutegiAukeraIkasturteBerria AS autosortuEgutegiAukeraIkasturteBerria_62,
  t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_63,
  t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_64
FROM
  appsetup t0
WHERE
  t0.ID_setup = ?

SELECT t0.ID_setup AS ID_setup_1, t0.infoEmail AS infoEmail_2, t0.herria AS herria_3, t0.eskolaIzena AS eskolaIzena_4, t0.nombreEscuela AS nombreEscuela_5, t0.domeinua AS domeinua_6, t0.headerImg AS headerImg_7, t0.logoUdalaImg AS logoUdalaImg_8, t0.logoExtraImg AS logoExtraImg_9, t0.logoEskolaImg AS logoEskolaImg_10, t0.infoIzena AS infoIzena_11, t0.infoLOPD AS infoLOPD_12, t0.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_13, t0.matrikulaznb AS matrikulaznb_14, t0.bajaznb AS bajaznb_15, t0.zenbatebaluaketa AS zenbatebaluaketa_16, t0.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_17, t0.modulogainditzekoazterketa AS modulogainditzekoazterketa_18, t0.multisede AS multisede_19, t0.multibilera AS multibilera_20, t0.remesaksortu AS remesaksortu_21, t0.urtekoakuota AS urtekoakuota_22, t0.zenbatkuota AS zenbatkuota_23, t0.sepaEmpresaIzena AS sepaEmpresaIzena_24, t0.sepaEmpresaIban AS sepaEmpresaIban_25, t0.sepaEmpresaBic AS sepaEmpresaBic_26, t0.sepaEmpresaIdentifikatzailea AS sepaEmpresaIdentifikatzailea_27, t0.sepaAktibatuta AS sepaAktibatuta_28, t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_29, t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_30, t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_31, t0.kuotaproporzionala AS kuotaproporzionala_32, t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_33, t0.bajanDesaktibazioData AS bajanDesaktibazioData_34, t0.bajaOnartuAutomatikoki AS bajaOnartuAutomatikoki_35, t0.eskeintzaMuga AS eskeintzaMuga_36, t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_37, t0.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_38, t0.notaknibelekakolorez AS notaknibelekakolorez_39, t0.espezialitateanKurtsorikEz AS espezialitateanKurtsorikEz_40, t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_41, t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_42, t0.dirulaguntzak AS dirulaguntzak_43, t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_44, t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_45, t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_46, t0.onartualumni AS onartualumni_47, t0.whatsappbidezinformazioa AS whatsappbidezinformazioa_48, t0.gurasoeninformaziorakohizkuntza AS gurasoeninformaziorakohizkuntza_49, t0.dokumentoenPolitika AS dokumentoenPolitika_50, t0.lanaldiRegistroa AS lanaldiRegistroa_51, t0.asistentziaBakarrikX AS asistentziaBakarrikX_52, t0.faltaJustifikatuak AS faltaJustifikatuak_53, t0.komunikazioakIlaraBitartez AS komunikazioakIlaraBitartez_54, t0.akademikoaEgoeraAldatuJakinarazi AS akademikoaEgoeraAldatuJakinarazi_55, t0.ordutegiAldaketaJakinarazi AS ordutegiAldaketaJakinarazi_56, t0.faltakGurasoeiJakinarazi AS faltakGurasoeiJakinarazi_57, t0.faltajustifituakIrakasleeiJakinarazi AS faltajustifituakIrakasleeiJakinarazi_58, t0.delayJakinarazpenakBidaltzeko AS delayJakinarazpenakBidaltzeko_59, t0.autosortuEskeintzaIkasturteBerria AS autosortuEskeintzaIkasturteBerria_60, t0.autosortuKuotaMatrikulaIkasturteBerria AS autosortuKuotaMatrikulaIkasturteBerria_61, t0.autosortuEgutegiAukeraIkasturteBerria AS autosortuEgutegiAukeraIkasturteBerria_62, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_63, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_64 FROM appsetup t0 WHERE t0.ID_setup = 1;

SELECT
  t0.ID_sedea AS ID_sedea_1,
  t0.izena AS izena_2,
  t0.argazkia AS argazkia_3,
  t0.aktiba AS aktiba_4,
  t0.matrikulaonline AS matrikulaonline_5,
  t0.lehenengoIkasgaia AS lehenengoIkasgaia_6,
  t0.porcentajeDef1 AS porcentajeDef1_7,
  t0.porcentajeDef2 AS porcentajeDef2_8,
  t0.porcentajeDef3 AS porcentajeDef3_9,
  t0.porcentajeDef4 AS porcentajeDef4_10,
  t0.porcentajeDef5 AS porcentajeDef5_11,
  t0.porcentajeDef6 AS porcentajeDef6_12,
  t0.porcentajeDef7 AS porcentajeDef7_13,
  t0.porcentajeDef8 AS porcentajeDef8_14,
  t0.porcentajeDef9 AS porcentajeDef9_15,
  t0.porcentajeDef10 AS porcentajeDef10_16
FROM
  sedea t0
WHERE
  t0.ID_sedea = ?

SELECT t0.ID_sedea AS ID_sedea_1, t0.izena AS izena_2, t0.argazkia AS argazkia_3, t0.aktiba AS aktiba_4, t0.matrikulaonline AS matrikulaonline_5, t0.lehenengoIkasgaia AS lehenengoIkasgaia_6, t0.porcentajeDef1 AS porcentajeDef1_7, t0.porcentajeDef2 AS porcentajeDef2_8, t0.porcentajeDef3 AS porcentajeDef3_9, t0.porcentajeDef4 AS porcentajeDef4_10, t0.porcentajeDef5 AS porcentajeDef5_11, t0.porcentajeDef6 AS porcentajeDef6_12, t0.porcentajeDef7 AS porcentajeDef7_13, t0.porcentajeDef8 AS porcentajeDef8_14, t0.porcentajeDef9 AS porcentajeDef9_15, t0.porcentajeDef10 AS porcentajeDef10_16 FROM sedea t0 WHERE t0.ID_sedea = '3';

SELECT
  t0.ID_ikasgaia AS ID_ikasgaia_1,
  t0.ikasgaia AS ikasgaia_2,
  t0.ikasgaiaErderaz AS ikasgaiaErderaz_3,
  t0.ikasgaiMota AS ikasgaiMota_4,
  t0.tutoretzarakolehentasuna AS tutoretzarakolehentasuna_5,
  t0.espezialitatea AS espezialitatea_6,
  t0.aktiboa AS aktiboa_7,
  t0.numeroKlauso AS numeroKlauso_8,
  t0.zenbatikaslezahar AS zenbatikaslezahar_9,
  t0.zenbatikasleberri AS zenbatikasleberri_10,
  t0.zenbatikaslebaja AS zenbatikaslebaja_11,
  t0.gutxienekoadina AS gutxienekoadina_12,
  t0.gehienekoadina AS gehienekoadina_13,
  t0.sarreramaila AS sarreramaila_14,
  t0.zenbatkurtso1nibelean AS zenbatkurtso1nibelean_15,
  t0.zenbatderrigorrez1nibelean AS zenbatderrigorrez1nibelean_16,
  t0.zenbatkurtso2nibelean AS zenbatkurtso2nibelean_17,
  t0.zenbatderrigorrez2nibelean AS zenbatderrigorrez2nibelean_18,
  t0.zenbatkurtso3nibelean AS zenbatkurtso3nibelean_19,
  t0.zenbatderrigorrez3nibelean AS zenbatderrigorrez3nibelean_20,
  t0.zenbatkurtso4nibelean AS zenbatkurtso4nibelean_21,
  t0.zenbatderrigorrez4nibelean AS zenbatderrigorrez4nibelean_22,
  t0.ID_ikasketaplana AS ID_ikasketaplana_23,
  t0.ID_notamota AS ID_notamota_24
FROM
  ikasgaia t0
WHERE
  t0.ID_ikasgaia = ?

SELECT t0.ID_ikasgaia AS ID_ikasgaia_1, t0.ikasgaia AS ikasgaia_2, t0.ikasgaiaErderaz AS ikasgaiaErderaz_3, t0.ikasgaiMota AS ikasgaiMota_4, t0.tutoretzarakolehentasuna AS tutoretzarakolehentasuna_5, t0.espezialitatea AS espezialitatea_6, t0.aktiboa AS aktiboa_7, t0.numeroKlauso AS numeroKlauso_8, t0.zenbatikaslezahar AS zenbatikaslezahar_9, t0.zenbatikasleberri AS zenbatikasleberri_10, t0.zenbatikaslebaja AS zenbatikaslebaja_11, t0.gutxienekoadina AS gutxienekoadina_12, t0.gehienekoadina AS gehienekoadina_13, t0.sarreramaila AS sarreramaila_14, t0.zenbatkurtso1nibelean AS zenbatkurtso1nibelean_15, t0.zenbatderrigorrez1nibelean AS zenbatderrigorrez1nibelean_16, t0.zenbatkurtso2nibelean AS zenbatkurtso2nibelean_17, t0.zenbatderrigorrez2nibelean AS zenbatderrigorrez2nibelean_18, t0.zenbatkurtso3nibelean AS zenbatkurtso3nibelean_19, t0.zenbatderrigorrez3nibelean AS zenbatderrigorrez3nibelean_20, t0.zenbatkurtso4nibelean AS zenbatkurtso4nibelean_21, t0.zenbatderrigorrez4nibelean AS zenbatderrigorrez4nibelean_22, t0.ID_ikasketaplana AS ID_ikasketaplana_23, t0.ID_notamota AS ID_notamota_24 FROM ikasgaia t0 WHERE t0.ID_ikasgaia = 167;

SELECT
  e0_.ID_egutegiaukera AS ID_egutegiaukera_0,
  e0_.izena AS izena_1,
  e0_.ikasturteaHasi AS ikasturteaHasi_2,
  e0_.ikasturteaBukatu AS ikasturteaBukatu_3,
  e0_.egutegiaitxita AS egutegiaitxita_4,
  e0_.ordena AS ordena_5,
  e0_.lehenetsia AS lehenetsia_6,
  e0_.ID_ikasturtea AS ID_ikasturtea_7
FROM
  egutegiaukera e0_
WHERE
  e0_.ID_ikasturtea = ?
  AND e0_.izena = ?
LIMIT
  1

SELECT e0_.ID_egutegiaukera AS ID_egutegiaukera_0, e0_.izena AS izena_1, e0_.ikasturteaHasi AS ikasturteaHasi_2, e0_.ikasturteaBukatu AS ikasturteaBukatu_3, e0_.egutegiaitxita AS egutegiaitxita_4, e0_.ordena AS ordena_5, e0_.lehenetsia AS lehenetsia_6, e0_.ID_ikasturtea AS ID_ikasturtea_7 FROM egutegiaukera e0_ WHERE e0_.ID_ikasturtea = 2026 AND e0_.izena = 'DONIBANE' LIMIT 1;

SELECT
  e0_.ID_egutegiaukera AS ID_egutegiaukera_0,
  e0_.izena AS izena_1,
  e0_.ikasturteaHasi AS ikasturteaHasi_2,
  e0_.ikasturteaBukatu AS ikasturteaBukatu_3,
  e0_.egutegiaitxita AS egutegiaitxita_4,
  e0_.ordena AS ordena_5,
  e0_.lehenetsia AS lehenetsia_6,
  e0_.ID_ikasturtea AS ID_ikasturtea_7
FROM
  egutegiaukera e0_
WHERE
  e0_.ID_ikasturtea = ?
  AND e0_.lehenetsia = 1
LIMIT
  1

SELECT e0_.ID_egutegiaukera AS ID_egutegiaukera_0, e0_.izena AS izena_1, e0_.ikasturteaHasi AS ikasturteaHasi_2, e0_.ikasturteaBukatu AS ikasturteaBukatu_3, e0_.egutegiaitxita AS egutegiaitxita_4, e0_.ordena AS ordena_5, e0_.lehenetsia AS lehenetsia_6, e0_.ID_ikasturtea AS ID_ikasturtea_7 FROM egutegiaukera e0_ WHERE e0_.ID_ikasturtea = 2026 AND e0_.lehenetsia = 1 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO eskeintza (
  zerrenda, maila, kurtsoa, taldea, gutxienekoAdina,
  gehienekoAdina, bileraordutegia,
  bileraordutegiaerderaz, remesable,
  subvencionable, ordutegiaerakutsi,
  ikasleakklasebakoitzean, klaseareniraupena,
  banakakoa, kolorea, aktibazioData,
  desaktibazioData, ID_ikasgaia, ID_irakaslea,
  ID_kuotamatrikula, ID_sedea, ID_ikasturtea,
  ID_egutegiaukera
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO eskeintza (zerrenda, maila, kurtsoa, taldea, gutxienekoAdina, gehienekoAdina, bileraordutegia, bileraordutegiaerderaz, remesable, subvencionable, ordutegiaerakutsi, ikasleakklasebakoitzean, klaseareniraupena, banakakoa, kolorea, aktibazioData, desaktibazioData, ID_ikasgaia, ID_irakaslea, ID_kuotamatrikula, ID_sedea, ID_ikasturtea, ID_egutegiaukera) VALUES (NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, NULL, NULL, 0, '#ffffff', NULL, NULL, 167, NULL, NULL, 3, 2026, 18);

"COMMIT"

"COMMIT";

SELECT
  a0_.ID_setup AS ID_setup_0,
  a0_.infoEmail AS infoEmail_1,
  a0_.herria AS herria_2,
  a0_.eskolaIzena AS eskolaIzena_3,
  a0_.nombreEscuela AS nombreEscuela_4,
  a0_.domeinua AS domeinua_5,
  a0_.headerImg AS headerImg_6,
  a0_.logoUdalaImg AS logoUdalaImg_7,
  a0_.logoExtraImg AS logoExtraImg_8,
  a0_.logoEskolaImg AS logoEskolaImg_9,
  a0_.infoIzena AS infoIzena_10,
  a0_.infoLOPD AS infoLOPD_11,
  a0_.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_12,
  a0_.matrikulaznb AS matrikulaznb_13,
  a0_.bajaznb AS bajaznb_14,
  a0_.zenbatebaluaketa AS zenbatebaluaketa_15,
  a0_.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_16,
  a0_.modulogainditzekoazterketa AS modulogainditzekoazterketa_17,
  a0_.multisede AS multisede_18,
  a0_.multibilera AS multibilera_19,
  a0_.remesaksortu AS remesaksortu_20,
  a0_.urtekoakuota AS urtekoakuota_21,
  a0_.zenbatkuota AS zenbatkuota_22,
  a0_.sepaEmpresaIzena AS sepaEmpresaIzena_23,
  a0_.sepaEmpresaIban AS sepaEmpresaIban_24,
  a0_.sepaEmpresaBic AS sepaEmpresaBic_25,
  a0_.sepaEmpresaIdentifikatzailea AS sepaEmpresaIdentifikatzailea_26,
  a0_.sepaAktibatuta AS sepaAktibatuta_27,
  a0_.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_28,
  a0_.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_29,
  a0_.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_30,
  a0_.kuotaproporzionala AS kuotaproporzionala_31,
  a0_.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_32,
  a0_.bajanDesaktibazioData AS bajanDesaktibazioData_33,
  a0_.bajaOnartuAutomatikoki AS bajaOnartuAutomatikoki_34,
  a0_.eskeintzaMuga AS eskeintzaMuga_35,
  a0_.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_36,
  a0_.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_37,
  a0_.notaknibelekakolorez AS notaknibelekakolorez_38,
  a0_.espezialitateanKurtsorikEz AS espezialitateanKurtsorikEz_39,
  a0_.familiaUgariaDeskontua AS familiaUgariaDeskontua_40,
  a0_.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_41,
  a0_.dirulaguntzak AS dirulaguntzak_42,
  a0_.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_43,
  a0_.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_44,
  a0_.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_45,
  a0_.onartualumni AS onartualumni_46,
  a0_.whatsappbidezinformazioa AS whatsappbidezinformazioa_47,
  a0_.gurasoeninformaziorakohizkuntza AS gurasoeninformaziorakohizkuntza_48,
  a0_.dokumentoenPolitika AS dokumentoenPolitika_49,
  a0_.lanaldiRegistroa AS lanaldiRegistroa_50,
  a0_.asistentziaBakarrikX AS asistentziaBakarrikX_51,
  a0_.faltaJustifikatuak AS faltaJustifikatuak_52,
  a0_.komunikazioakIlaraBitartez AS komunikazioakIlaraBitartez_53,
  a0_.akademikoaEgoeraAldatuJakinarazi AS akademikoaEgoeraAldatuJakinarazi_54,
  a0_.ordutegiAldaketaJakinarazi AS ordutegiAldaketaJakinarazi_55,
  a0_.faltakGurasoeiJakinarazi AS faltakGurasoeiJakinarazi_56,
  a0_.faltajustifituakIrakasleeiJakinarazi AS faltajustifituakIrakasleeiJakinarazi_57,
  a0_.delayJakinarazpenakBidaltzeko AS delayJakinarazpenakBidaltzeko_58,
  a0_.autosortuEskeintzaIkasturteBerria AS autosortuEskeintzaIkasturteBerria_59,
  a0_.autosortuKuotaMatrikulaIkasturteBerria AS autosortuKuotaMatrikulaIkasturteBerria_60,
  a0_.autosortuEgutegiAukeraIkasturteBerria AS autosortuEgutegiAukeraIkasturteBerria_61,
  a0_.ikasturteaAkademikoa AS ikasturteaAkademikoa_62,
  a0_.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_63
FROM
  appsetup a0_
WHERE
  a0_.ID_setup = 1

SELECT a0_.ID_setup AS ID_setup_0, a0_.infoEmail AS infoEmail_1, a0_.herria AS herria_2, a0_.eskolaIzena AS eskolaIzena_3, a0_.nombreEscuela AS nombreEscuela_4, a0_.domeinua AS domeinua_5, a0_.headerImg AS headerImg_6, a0_.logoUdalaImg AS logoUdalaImg_7, a0_.logoExtraImg AS logoExtraImg_8, a0_.logoEskolaImg AS logoEskolaImg_9, a0_.infoIzena AS infoIzena_10, a0_.infoLOPD AS infoLOPD_11, a0_.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_12, a0_.matrikulaznb AS matrikulaznb_13, a0_.bajaznb AS bajaznb_14, a0_.zenbatebaluaketa AS zenbatebaluaketa_15, a0_.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_16, a0_.modulogainditzekoazterketa AS modulogainditzekoazterketa_17, a0_.multisede AS multisede_18, a0_.multibilera AS multibilera_19, a0_.remesaksortu AS remesaksortu_20, a0_.urtekoakuota AS urtekoakuota_21, a0_.zenbatkuota AS zenbatkuota_22, a0_.sepaEmpresaIzena AS sepaEmpresaIzena_23, a0_.sepaEmpresaIban AS sepaEmpresaIban_24, a0_.sepaEmpresaBic AS sepaEmpresaBic_25, a0_.sepaEmpresaIdentifikatzailea AS sepaEmpresaIdentifikatzailea_26, a0_.sepaAktibatuta AS sepaAktibatuta_27, a0_.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_28, a0_.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_29, a0_.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_30, a0_.kuotaproporzionala AS kuotaproporzionala_31, a0_.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_32, a0_.bajanDesaktibazioData AS bajanDesaktibazioData_33, a0_.bajaOnartuAutomatikoki AS bajaOnartuAutomatikoki_34, a0_.eskeintzaMuga AS eskeintzaMuga_35, a0_.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_36, a0_.matrikulaGehituAutomatikoki AS matrikulaGehituAutomatikoki_37, a0_.notaknibelekakolorez AS notaknibelekakolorez_38, a0_.espezialitateanKurtsorikEz AS espezialitateanKurtsorikEz_39, a0_.familiaUgariaDeskontua AS familiaUgariaDeskontua_40, a0_.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_41, a0_.dirulaguntzak AS dirulaguntzak_42, a0_.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_43, a0_.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_44, a0_.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_45, a0_.onartualumni AS onartualumni_46, a0_.whatsappbidezinformazioa AS whatsappbidezinformazioa_47, a0_.gurasoeninformaziorakohizkuntza AS gurasoeninformaziorakohizkuntza_48, a0_.dokumentoenPolitika AS dokumentoenPolitika_49, a0_.lanaldiRegistroa AS lanaldiRegistroa_50, a0_.asistentziaBakarrikX AS asistentziaBakarrikX_51, a0_.faltaJustifikatuak AS faltaJustifikatuak_52, a0_.komunikazioakIlaraBitartez AS komunikazioakIlaraBitartez_53, a0_.akademikoaEgoeraAldatuJakinarazi AS akademikoaEgoeraAldatuJakinarazi_54, a0_.ordutegiAldaketaJakinarazi AS ordutegiAldaketaJakinarazi_55, a0_.faltakGurasoeiJakinarazi AS faltakGurasoeiJakinarazi_56, a0_.faltajustifituakIrakasleeiJakinarazi AS faltajustifituakIrakasleeiJakinarazi_57, a0_.delayJakinarazpenakBidaltzeko AS delayJakinarazpenakBidaltzeko_58, a0_.autosortuEskeintzaIkasturteBerria AS autosortuEskeintzaIkasturteBerria_59, a0_.autosortuKuotaMatrikulaIkasturteBerria AS autosortuKuotaMatrikulaIkasturteBerria_60, a0_.autosortuEgutegiAukeraIkasturteBerria AS autosortuEgutegiAukeraIkasturteBerria_61, a0_.ikasturteaAkademikoa AS ikasturteaAkademikoa_62, a0_.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_63 FROM appsetup a0_ WHERE a0_.ID_setup = 1;

SELECT
  k0_.ID_kuotamatrikula AS ID_kuotamatrikula_0,
  k0_.kuotarenizena AS kuotarenizena_1,
  k0_.ordena AS ordena_2,
  k0_.matrikula AS matrikula_3,
  k0_.kuota AS kuota_4,
  k0_.kuota1ikasgaia AS kuota1ikasgaia_5,
  k0_.ID_ikasturtea AS ID_ikasturtea_6
FROM
  kuotamatrikulaprezioa k0_
WHERE
  k0_.ID_ikasturtea = ?

SELECT k0_.ID_kuotamatrikula AS ID_kuotamatrikula_0, k0_.kuotarenizena AS kuotarenizena_1, k0_.ordena AS ordena_2, k0_.matrikula AS matrikula_3, k0_.kuota AS kuota_4, k0_.kuota1ikasgaia AS kuota1ikasgaia_5, k0_.ID_ikasturtea AS ID_ikasturtea_6 FROM kuotamatrikulaprezioa k0_ WHERE k0_.ID_ikasturtea = 2026;

SELECT
  i0_.ID_irakaslea AS ID_irakaslea_0,
  i0_.kontratomota AS kontratomota_1,
  i0_.lanhitzarmena AS lanhitzarmena_2,
  i0_.altadata AS altadata_3,
  i0_.bajadata AS bajadata_4,
  i0_.titulazioak AS titulazioak_5,
  i0_.egoera AS egoera_6,
  i0_.emaila AS emaila_7,
  i0_.mezuakEmailPertsonaleraBidali AS mezuakEmailPertsonaleraBidali_8,
  i0_.jakinarazpenakEmailPertsonaleraBidali AS jakinarazpenakEmailPertsonaleraBidali_9,
  i0_.mobila AS mobila_10,
  i0_.mezuakWhatsappPertsonaleraBidali AS mezuakWhatsappPertsonaleraBidali_11,
  i0_.jakinarazpenakWhatsappPertsonaleraBidali AS jakinarazpenakWhatsappPertsonaleraBidali_12,
  i0_.telefonoa AS telefonoa_13,
  i0_.extensioa AS extensioa_14,
  i0_.ID_pertsonala AS ID_pertsonala_15,
  i0_.ID_ohikogela AS ID_ohikogela_16
FROM
  irakaslea i0_
  INNER JOIN pertsonala p1_ ON i0_.ID_pertsonala = p1_.ID_pertsonala
WHERE
  i0_.egoera = 1
  OR EXISTS (
    SELECT
      a2_.ID_akademikoa
    FROM
      akademikoa a2_
    WHERE
      a2_.ID_ikasturtea = ?
      AND a2_.ID_irakaslea = i0_.ID_irakaslea
  )
GROUP BY
  i0_.ID_irakaslea
ORDER BY
  p1_.izenabizenak ASC

SELECT i0_.ID_irakaslea AS ID_irakaslea_0, i0_.kontratomota AS kontratomota_1, i0_.lanhitzarmena AS lanhitzarmena_2, i0_.altadata AS altadata_3, i0_.bajadata AS bajadata_4, i0_.titulazioak AS titulazioak_5, i0_.egoera AS egoera_6, i0_.emaila AS emaila_7, i0_.mezuakEmailPertsonaleraBidali AS mezuakEmailPertsonaleraBidali_8, i0_.jakinarazpenakEmailPertsonaleraBidali AS jakinarazpenakEmailPertsonaleraBidali_9, i0_.mobila AS mobila_10, i0_.mezuakWhatsappPertsonaleraBidali AS mezuakWhatsappPertsonaleraBidali_11, i0_.jakinarazpenakWhatsappPertsonaleraBidali AS jakinarazpenakWhatsappPertsonaleraBidali_12, i0_.telefonoa AS telefonoa_13, i0_.extensioa AS extensioa_14, i0_.ID_pertsonala AS ID_pertsonala_15, i0_.ID_ohikogela AS ID_ohikogela_16 FROM irakaslea i0_ INNER JOIN pertsonala p1_ ON i0_.ID_pertsonala = p1_.ID_pertsonala WHERE i0_.egoera = 1 OR EXISTS (SELECT a2_.ID_akademikoa FROM akademikoa a2_ WHERE a2_.ID_ikasturtea = 2026 AND a2_.ID_irakaslea = i0_.ID_irakaslea) GROUP BY i0_.ID_irakaslea ORDER BY p1_.izenabizenak ASC;