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 = 1219 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.baimendutakorolak AS baimendutakorolak_6,
  t0.langilerola AS langilerola_7,
  t0.ID_menuitem AS ID_menuitem_8,
  t9.ID_menuitem AS ID_menuitem_10,
  t9.ordena AS ordena_11,
  t9.tagId AS tagId_12,
  t9.izena AS izena_13,
  t9.path AS path_14,
  t9.itxura AS itxura_15,
  t9.fontawesome AS fontawesome_16,
  t9.target AS target_17,
  t9.parentmenu AS parentmenu_18,
  t9.gutxienekobaimena AS gutxienekobaimena_19
FROM
  baimena t0
  LEFT JOIN menuitem t9 ON t9.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.baimendutakorolak AS baimendutakorolak_6, t0.langilerola AS langilerola_7, t0.ID_menuitem AS ID_menuitem_8, t9.ID_menuitem AS ID_menuitem_10, t9.ordena AS ordena_11, t9.tagId AS tagId_12, t9.izena AS izena_13, t9.path AS path_14, t9.itxura AS itxura_15, t9.fontawesome AS fontawesome_16, t9.target AS target_17, t9.parentmenu AS parentmenu_18, t9.gutxienekobaimena AS gutxienekobaimena_19 FROM baimena t0 LEFT JOIN menuitem t9 ON t9.gutxienekobaimena = t0.ID_baimena WHERE t0.kodea = 'Matr_admins' LIMIT 1;

SELECT
  i0_.ID_ikaslea AS ID_ikaslea_0,
  i0_.berria AS berria_1,
  i0_.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_2,
  i0_.egoera AS egoera_3,
  i0_.kontukorrontea AS kontukorrontea_4,
  i0_.ID_pertsonala AS ID_pertsonala_5,
  i0_.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_6,
  i0_.tutorea AS tutorea_7
FROM
  ikaslea i0_
  INNER JOIN pertsonala p1_ ON i0_.ID_pertsonala = p1_.ID_pertsonala
WHERE
  p1_.izenabizenak LIKE ?
ORDER BY
  p1_.izenabizenak ASC

SELECT i0_.ID_ikaslea AS ID_ikaslea_0, i0_.berria AS berria_1, i0_.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_2, i0_.egoera AS egoera_3, i0_.kontukorrontea AS kontukorrontea_4, i0_.ID_pertsonala AS ID_pertsonala_5, i0_.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_6, i0_.tutorea AS tutorea_7 FROM ikaslea i0_ INNER JOIN pertsonala p1_ ON i0_.ID_pertsonala = p1_.ID_pertsonala WHERE p1_.izenabizenak LIKE '%CaLMA%' ORDER BY p1_.izenabizenak ASC;

SELECT
  t0.ID_setup AS ID_setup_1,
  t0.infoEmail AS infoEmail_2,
  t0.infoIzena AS infoIzena_3,
  t0.infoLOPD AS infoLOPD_4,
  t0.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_5,
  t0.matrikulaznb AS matrikulaznb_6,
  t0.zenbatebaluaketa AS zenbatebaluaketa_7,
  t0.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_8,
  t0.modulogainditzekoazterketa AS modulogainditzekoazterketa_9,
  t0.multisede AS multisede_10,
  t0.multibilera AS multibilera_11,
  t0.remesaksortu AS remesaksortu_12,
  t0.eskeintzaMuga AS eskeintzaMuga_13,
  t0.urtekoakuota AS urtekoakuota_14,
  t0.zenbatkuota AS zenbatkuota_15,
  t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_16,
  t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_17,
  t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_18,
  t0.kuotaproporzionala AS kuotaproporzionala_19,
  t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_20,
  t0.bajanDesaktibazioData AS bajanDesaktibazioData_21,
  t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_22,
  t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_23,
  t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_24,
  t0.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_25,
  t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_26,
  t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_27,
  t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_28,
  t0.matrikulaBerriaEginda AS matrikulaBerriaEginda_29,
  t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_30,
  t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_31
FROM
  appsetup t0
WHERE
  t0.ID_setup = ?

SELECT t0.ID_setup AS ID_setup_1, t0.infoEmail AS infoEmail_2, t0.infoIzena AS infoIzena_3, t0.infoLOPD AS infoLOPD_4, t0.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_5, t0.matrikulaznb AS matrikulaznb_6, t0.zenbatebaluaketa AS zenbatebaluaketa_7, t0.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_8, t0.modulogainditzekoazterketa AS modulogainditzekoazterketa_9, t0.multisede AS multisede_10, t0.multibilera AS multibilera_11, t0.remesaksortu AS remesaksortu_12, t0.eskeintzaMuga AS eskeintzaMuga_13, t0.urtekoakuota AS urtekoakuota_14, t0.zenbatkuota AS zenbatkuota_15, t0.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_16, t0.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_17, t0.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_18, t0.kuotaproporzionala AS kuotaproporzionala_19, t0.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_20, t0.bajanDesaktibazioData AS bajanDesaktibazioData_21, t0.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_22, t0.familiaUgariaDeskontua AS familiaUgariaDeskontua_23, t0.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_24, t0.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_25, t0.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_26, t0.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_27, t0.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_28, t0.matrikulaBerriaEginda AS matrikulaBerriaEginda_29, t0.ikasturteaAkademikoa AS ikasturteaAkademikoa_30, t0.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_31 FROM appsetup t0 WHERE t0.ID_setup = 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.baimendutakorolak AS baimendutakorolak_6,
  t0.langilerola AS langilerola_7,
  t0.ID_menuitem AS ID_menuitem_8,
  t9.ID_menuitem AS ID_menuitem_10,
  t9.ordena AS ordena_11,
  t9.tagId AS tagId_12,
  t9.izena AS izena_13,
  t9.path AS path_14,
  t9.itxura AS itxura_15,
  t9.fontawesome AS fontawesome_16,
  t9.target AS target_17,
  t9.parentmenu AS parentmenu_18,
  t9.gutxienekobaimena AS gutxienekobaimena_19
FROM
  baimena t0
  LEFT JOIN menuitem t9 ON t9.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.baimendutakorolak AS baimendutakorolak_6, t0.langilerola AS langilerola_7, t0.ID_menuitem AS ID_menuitem_8, t9.ID_menuitem AS ID_menuitem_10, t9.ordena AS ordena_11, t9.tagId AS tagId_12, t9.izena AS izena_13, t9.path AS path_14, t9.itxura AS itxura_15, t9.fontawesome AS fontawesome_16, t9.target AS target_17, t9.parentmenu AS parentmenu_18, t9.gutxienekobaimena AS gutxienekobaimena_19 FROM baimena t0 LEFT JOIN menuitem t9 ON t9.gutxienekobaimena = t0.ID_baimena WHERE t0.kodea = 'Matr_eskEpzKanpo' LIMIT 1;

SELECT
  t0.ID_ikasturtea AS ID_ikasturtea_1,
  t0.ikasturtea AS ikasturtea_2,
  t0.lektibakLanaldiOsoa AS lektibakLanaldiOsoa_3,
  t0.matrikulaepeazabalik AS matrikulaepeazabalik_4,
  t0.matrikulaepeabukatu AS matrikulaepeabukatu_5,
  t0.matrikulaepeaberrientzatzabalik AS matrikulaepeaberrientzatzabalik_6,
  t0.ikasturteaHasi AS ikasturteaHasi_7,
  t0.ikasturteaBukatu AS ikasturteaBukatu_8,
  t0.ebaluaketaGaraiaHasi1 AS ebaluaketaGaraiaHasi1_9,
  t0.ebaluaketaGaraiaBukatu1 AS ebaluaketaGaraiaBukatu1_10,
  t0.ebaluaketaBukatu1 AS ebaluaketaBukatu1_11,
  t0.bajamugaepea1 AS bajamugaepea1_12,
  t0.ebaluaketaGaraiaHasi2 AS ebaluaketaGaraiaHasi2_13,
  t0.ebaluaketaGaraiaBukatu2 AS ebaluaketaGaraiaBukatu2_14,
  t0.ebaluaketaBukatu2 AS ebaluaketaBukatu2_15,
  t0.bajamugaepea2 AS bajamugaepea2_16,
  t0.ebaluaketaGaraiaHasi3 AS ebaluaketaGaraiaHasi3_17,
  t0.ebaluaketaGaraiaBukatu3 AS ebaluaketaGaraiaBukatu3_18,
  t0.ebaluaketaBukatu3 AS ebaluaketaBukatu3_19,
  t0.bajamugaepea3 AS bajamugaepea3_20,
  t0.finSubvencion AS finSubvencion_21,
  t0.hurrengoikasturterakooharra AS hurrengoikasturterakooharra_22,
  t0.diploma_data AS diploma_data_23,
  t0.ekarrilagunanoiz AS ekarrilagunanoiz_24,
  t0.bigarrenmusikatresnadeskontua AS bigarrenmusikatresnadeskontua_25,
  t0.familiaugariadeskontua AS familiaugariadeskontua_26,
  t0.remesaDataDef1 AS remesaDataDef1_27,
  t0.remesaDataDef2 AS remesaDataDef2_28,
  t0.remesaDataDef3 AS remesaDataDef3_29,
  t0.remesaDataDef4 AS remesaDataDef4_30,
  t0.remesaDataDef5 AS remesaDataDef5_31,
  t0.remesaDataDef6 AS remesaDataDef6_32,
  t0.remesaDataDef7 AS remesaDataDef7_33,
  t0.remesaDataDef8 AS remesaDataDef8_34,
  t0.remesaDataDef9 AS remesaDataDef9_35,
  t0.remesaDataDef10 AS remesaDataDef10_36,
  t0.dirulaguntzaBukaeraData AS dirulaguntzaBukaeraData_37,
  t0.egutegiaitxita AS egutegiaitxita_38,
  t0.finalizado AS finalizado_39,
  t0.ID_irakaslea AS ID_irakaslea_40,
  t41.ID_setup AS ID_setup_42,
  t41.infoEmail AS infoEmail_43,
  t41.infoIzena AS infoIzena_44,
  t41.infoLOPD AS infoLOPD_45,
  t41.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_46,
  t41.matrikulaznb AS matrikulaznb_47,
  t41.zenbatebaluaketa AS zenbatebaluaketa_48,
  t41.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_49,
  t41.modulogainditzekoazterketa AS modulogainditzekoazterketa_50,
  t41.multisede AS multisede_51,
  t41.multibilera AS multibilera_52,
  t41.remesaksortu AS remesaksortu_53,
  t41.eskeintzaMuga AS eskeintzaMuga_54,
  t41.urtekoakuota AS urtekoakuota_55,
  t41.zenbatkuota AS zenbatkuota_56,
  t41.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_57,
  t41.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_58,
  t41.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_59,
  t41.kuotaproporzionala AS kuotaproporzionala_60,
  t41.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_61,
  t41.bajanDesaktibazioData AS bajanDesaktibazioData_62,
  t41.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_63,
  t41.familiaUgariaDeskontua AS familiaUgariaDeskontua_64,
  t41.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_65,
  t41.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_66,
  t41.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_67,
  t41.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_68,
  t41.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_69,
  t41.matrikulaBerriaEginda AS matrikulaBerriaEginda_70,
  t41.ikasturteaAkademikoa AS ikasturteaAkademikoa_71,
  t41.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_72,
  t73.ID_setup AS ID_setup_74,
  t73.infoEmail AS infoEmail_75,
  t73.infoIzena AS infoIzena_76,
  t73.infoLOPD AS infoLOPD_77,
  t73.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_78,
  t73.matrikulaznb AS matrikulaznb_79,
  t73.zenbatebaluaketa AS zenbatebaluaketa_80,
  t73.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_81,
  t73.modulogainditzekoazterketa AS modulogainditzekoazterketa_82,
  t73.multisede AS multisede_83,
  t73.multibilera AS multibilera_84,
  t73.remesaksortu AS remesaksortu_85,
  t73.eskeintzaMuga AS eskeintzaMuga_86,
  t73.urtekoakuota AS urtekoakuota_87,
  t73.zenbatkuota AS zenbatkuota_88,
  t73.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_89,
  t73.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_90,
  t73.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_91,
  t73.kuotaproporzionala AS kuotaproporzionala_92,
  t73.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_93,
  t73.bajanDesaktibazioData AS bajanDesaktibazioData_94,
  t73.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_95,
  t73.familiaUgariaDeskontua AS familiaUgariaDeskontua_96,
  t73.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_97,
  t73.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_98,
  t73.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_99,
  t73.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_100,
  t73.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_101,
  t73.matrikulaBerriaEginda AS matrikulaBerriaEginda_102,
  t73.ikasturteaAkademikoa AS ikasturteaAkademikoa_103,
  t73.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_104
FROM
  ikasturtea t0
  LEFT JOIN appsetup t41 ON t41.ikasturteaAkademikoa = t0.ID_ikasturtea
  LEFT JOIN appsetup t73 ON t73.ikasturteaMatrikulazioa = t0.ID_ikasturtea
WHERE
  t0.ID_ikasturtea = ?

SELECT t0.ID_ikasturtea AS ID_ikasturtea_1, t0.ikasturtea AS ikasturtea_2, t0.lektibakLanaldiOsoa AS lektibakLanaldiOsoa_3, t0.matrikulaepeazabalik AS matrikulaepeazabalik_4, t0.matrikulaepeabukatu AS matrikulaepeabukatu_5, t0.matrikulaepeaberrientzatzabalik AS matrikulaepeaberrientzatzabalik_6, t0.ikasturteaHasi AS ikasturteaHasi_7, t0.ikasturteaBukatu AS ikasturteaBukatu_8, t0.ebaluaketaGaraiaHasi1 AS ebaluaketaGaraiaHasi1_9, t0.ebaluaketaGaraiaBukatu1 AS ebaluaketaGaraiaBukatu1_10, t0.ebaluaketaBukatu1 AS ebaluaketaBukatu1_11, t0.bajamugaepea1 AS bajamugaepea1_12, t0.ebaluaketaGaraiaHasi2 AS ebaluaketaGaraiaHasi2_13, t0.ebaluaketaGaraiaBukatu2 AS ebaluaketaGaraiaBukatu2_14, t0.ebaluaketaBukatu2 AS ebaluaketaBukatu2_15, t0.bajamugaepea2 AS bajamugaepea2_16, t0.ebaluaketaGaraiaHasi3 AS ebaluaketaGaraiaHasi3_17, t0.ebaluaketaGaraiaBukatu3 AS ebaluaketaGaraiaBukatu3_18, t0.ebaluaketaBukatu3 AS ebaluaketaBukatu3_19, t0.bajamugaepea3 AS bajamugaepea3_20, t0.finSubvencion AS finSubvencion_21, t0.hurrengoikasturterakooharra AS hurrengoikasturterakooharra_22, t0.diploma_data AS diploma_data_23, t0.ekarrilagunanoiz AS ekarrilagunanoiz_24, t0.bigarrenmusikatresnadeskontua AS bigarrenmusikatresnadeskontua_25, t0.familiaugariadeskontua AS familiaugariadeskontua_26, t0.remesaDataDef1 AS remesaDataDef1_27, t0.remesaDataDef2 AS remesaDataDef2_28, t0.remesaDataDef3 AS remesaDataDef3_29, t0.remesaDataDef4 AS remesaDataDef4_30, t0.remesaDataDef5 AS remesaDataDef5_31, t0.remesaDataDef6 AS remesaDataDef6_32, t0.remesaDataDef7 AS remesaDataDef7_33, t0.remesaDataDef8 AS remesaDataDef8_34, t0.remesaDataDef9 AS remesaDataDef9_35, t0.remesaDataDef10 AS remesaDataDef10_36, t0.dirulaguntzaBukaeraData AS dirulaguntzaBukaeraData_37, t0.egutegiaitxita AS egutegiaitxita_38, t0.finalizado AS finalizado_39, t0.ID_irakaslea AS ID_irakaslea_40, t41.ID_setup AS ID_setup_42, t41.infoEmail AS infoEmail_43, t41.infoIzena AS infoIzena_44, t41.infoLOPD AS infoLOPD_45, t41.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_46, t41.matrikulaznb AS matrikulaznb_47, t41.zenbatebaluaketa AS zenbatebaluaketa_48, t41.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_49, t41.modulogainditzekoazterketa AS modulogainditzekoazterketa_50, t41.multisede AS multisede_51, t41.multibilera AS multibilera_52, t41.remesaksortu AS remesaksortu_53, t41.eskeintzaMuga AS eskeintzaMuga_54, t41.urtekoakuota AS urtekoakuota_55, t41.zenbatkuota AS zenbatkuota_56, t41.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_57, t41.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_58, t41.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_59, t41.kuotaproporzionala AS kuotaproporzionala_60, t41.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_61, t41.bajanDesaktibazioData AS bajanDesaktibazioData_62, t41.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_63, t41.familiaUgariaDeskontua AS familiaUgariaDeskontua_64, t41.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_65, t41.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_66, t41.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_67, t41.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_68, t41.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_69, t41.matrikulaBerriaEginda AS matrikulaBerriaEginda_70, t41.ikasturteaAkademikoa AS ikasturteaAkademikoa_71, t41.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_72, t73.ID_setup AS ID_setup_74, t73.infoEmail AS infoEmail_75, t73.infoIzena AS infoIzena_76, t73.infoLOPD AS infoLOPD_77, t73.lopdOrriaMatrikulaOrrian AS lopdOrriaMatrikulaOrrian_78, t73.matrikulaznb AS matrikulaznb_79, t73.zenbatebaluaketa AS zenbatebaluaketa_80, t73.notetanHurrengoOrdutegiak AS notetanHurrengoOrdutegiak_81, t73.modulogainditzekoazterketa AS modulogainditzekoazterketa_82, t73.multisede AS multisede_83, t73.multibilera AS multibilera_84, t73.remesaksortu AS remesaksortu_85, t73.eskeintzaMuga AS eskeintzaMuga_86, t73.urtekoakuota AS urtekoakuota_87, t73.zenbatkuota AS zenbatkuota_88, t73.berrientzatmatrikulaepeberezia AS berrientzatmatrikulaepeberezia_89, t73.matrikulaeskubideaordaindu AS matrikulaeskubideaordaindu_90, t73.lehenengoikasgaiaprezioberezia AS lehenengoikasgaiaprezioberezia_91, t73.kuotaproporzionala AS kuotaproporzionala_92, t73.kuotarikEzOrdaindu AS kuotarikEzOrdaindu_93, t73.bajanDesaktibazioData AS bajanDesaktibazioData_94, t73.matrikulaBerritzeAutomatikoa AS matrikulaBerritzeAutomatikoa_95, t73.familiaUgariaDeskontua AS familiaUgariaDeskontua_96, t73.bigarrenMusikatresnaDeskontua AS bigarrenMusikatresnaDeskontua_97, t73.hurrengoIkasturtekoOharra AS hurrengoIkasturtekoOharra_98, t73.onartuIkasleaEmailPertsonala AS onartuIkasleaEmailPertsonala_99, t73.onartuIrakasleaEmailPertsonala AS onartuIrakasleaEmailPertsonala_100, t73.onartuLangileaEmailPertsonala AS onartuLangileaEmailPertsonala_101, t73.matrikulaBerriaEginda AS matrikulaBerriaEginda_102, t73.ikasturteaAkademikoa AS ikasturteaAkademikoa_103, t73.ikasturteaMatrikulazioa AS ikasturteaMatrikulazioa_104 FROM ikasturtea t0 LEFT JOIN appsetup t41 ON t41.ikasturteaAkademikoa = t0.ID_ikasturtea LEFT JOIN appsetup t73 ON t73.ikasturteaMatrikulazioa = t0.ID_ikasturtea WHERE t0.ID_ikasturtea = 2025;

SELECT
  t0.ID_pertsonala AS ID_pertsonala_1,
  t0.izenabizenak AS izenabizenak_2,
  t0.avatar AS avatar_3,
  t0.izena AS izena_4,
  t0.abizena1 AS abizena1_5,
  t0.abizena2 AS abizena2_6,
  t0.nan AS nan_7,
  t0.jaiotzedata AS jaiotzedata_8,
  t0.sexua AS sexua_9,
  t0.nazionalitatea AS nazionalitatea_10,
  t0.ikastola AS ikastola_11,
  t0.baimenalopd AS baimenalopd_12,
  t0.sinaduralopd AS sinaduralopd_13,
  t0.oharrak AS oharrak_14,
  t0.aboutyou AS aboutyou_15,
  t0.helbidea AS helbidea_16,
  t0.herria AS herria_17,
  t0.postakodea AS postakodea_18,
  t0.errolduta AS errolduta_19,
  t0.informazioahizkuntza AS informazioahizkuntza_20,
  t0.telefonoa AS telefonoa_21,
  t0.bestetelefonoa AS bestetelefonoa_22,
  t0.mobila AS mobila_23,
  t0.baimenawhatsapp AS baimenawhatsapp_24,
  t0.emaila AS emaila_25,
  t0.emailcorporativo AS emailcorporativo_26,
  t0.norenmobila1 AS norenmobila1_27,
  t0.bestemobila1 AS bestemobila1_28,
  t0.bestemobila1whatsapp AS bestemobila1whatsapp_29,
  t0.norenmobila2 AS norenmobila2_30,
  t0.bestemobila2 AS bestemobila2_31,
  t0.bestemobila2whatsapp AS bestemobila2whatsapp_32,
  t0.familiaugaria AS familiaugaria_33,
  t0.familiaugariaepemuga AS familiaugariaepemuga_34,
  t0.registeredDatetime AS registeredDatetime_35,
  t0.lastUpdateDatetime AS lastUpdateDatetime_36,
  t0.exentoLM AS exentoLM_37,
  t0.oharrakExentoLM AS oharrakExentoLM_38,
  t0.udalzorra AS udalzorra_39,
  t0.zenbatekodeskontua AS zenbatekodeskontua_40,
  t0.alumni AS alumni_41,
  t0.verify AS verify_42,
  t0.hilda AS hilda_43,
  t44.ID_ikaslea AS ID_ikaslea_45,
  t44.berria AS berria_46,
  t44.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_47,
  t44.egoera AS egoera_48,
  t44.kontukorrontea AS kontukorrontea_49,
  t44.ID_pertsonala AS ID_pertsonala_50,
  t44.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_51,
  t44.tutorea AS tutorea_52,
  t53.ID_irakaslea AS ID_irakaslea_54,
  t53.kontratomota AS kontratomota_55,
  t53.altadata AS altadata_56,
  t53.bajadata AS bajadata_57,
  t53.titulazioak AS titulazioak_58,
  t53.egoera AS egoera_59,
  t53.ID_pertsonala AS ID_pertsonala_60,
  t53.ID_ohikogela AS ID_ohikogela_61,
  t62.ID_langilea AS ID_langilea_63,
  t62.mota AS mota_64,
  t62.roles AS roles_65,
  t62.kontratomota AS kontratomota_66,
  t62.altadata AS altadata_67,
  t62.bajadata AS bajadata_68,
  t62.titulazioak AS titulazioak_69,
  t62.egoera AS egoera_70,
  t62.ID_pertsonala AS ID_pertsonala_71
FROM
  pertsonala t0
  LEFT JOIN ikaslea t44 ON t44.ID_pertsonala = t0.ID_pertsonala
  LEFT JOIN irakaslea t53 ON t53.ID_pertsonala = t0.ID_pertsonala
  LEFT JOIN langilea t62 ON t62.ID_pertsonala = t0.ID_pertsonala
WHERE
  t0.ID_pertsonala = ?

SELECT t0.ID_pertsonala AS ID_pertsonala_1, t0.izenabizenak AS izenabizenak_2, t0.avatar AS avatar_3, t0.izena AS izena_4, t0.abizena1 AS abizena1_5, t0.abizena2 AS abizena2_6, t0.nan AS nan_7, t0.jaiotzedata AS jaiotzedata_8, t0.sexua AS sexua_9, t0.nazionalitatea AS nazionalitatea_10, t0.ikastola AS ikastola_11, t0.baimenalopd AS baimenalopd_12, t0.sinaduralopd AS sinaduralopd_13, t0.oharrak AS oharrak_14, t0.aboutyou AS aboutyou_15, t0.helbidea AS helbidea_16, t0.herria AS herria_17, t0.postakodea AS postakodea_18, t0.errolduta AS errolduta_19, t0.informazioahizkuntza AS informazioahizkuntza_20, t0.telefonoa AS telefonoa_21, t0.bestetelefonoa AS bestetelefonoa_22, t0.mobila AS mobila_23, t0.baimenawhatsapp AS baimenawhatsapp_24, t0.emaila AS emaila_25, t0.emailcorporativo AS emailcorporativo_26, t0.norenmobila1 AS norenmobila1_27, t0.bestemobila1 AS bestemobila1_28, t0.bestemobila1whatsapp AS bestemobila1whatsapp_29, t0.norenmobila2 AS norenmobila2_30, t0.bestemobila2 AS bestemobila2_31, t0.bestemobila2whatsapp AS bestemobila2whatsapp_32, t0.familiaugaria AS familiaugaria_33, t0.familiaugariaepemuga AS familiaugariaepemuga_34, t0.registeredDatetime AS registeredDatetime_35, t0.lastUpdateDatetime AS lastUpdateDatetime_36, t0.exentoLM AS exentoLM_37, t0.oharrakExentoLM AS oharrakExentoLM_38, t0.udalzorra AS udalzorra_39, t0.zenbatekodeskontua AS zenbatekodeskontua_40, t0.alumni AS alumni_41, t0.verify AS verify_42, t0.hilda AS hilda_43, t44.ID_ikaslea AS ID_ikaslea_45, t44.berria AS berria_46, t44.azkenMatrikulaDataordua AS azkenMatrikulaDataordua_47, t44.egoera AS egoera_48, t44.kontukorrontea AS kontukorrontea_49, t44.ID_pertsonala AS ID_pertsonala_50, t44.ID_kontukorrontearentitularra AS ID_kontukorrontearentitularra_51, t44.tutorea AS tutorea_52, t53.ID_irakaslea AS ID_irakaslea_54, t53.kontratomota AS kontratomota_55, t53.altadata AS altadata_56, t53.bajadata AS bajadata_57, t53.titulazioak AS titulazioak_58, t53.egoera AS egoera_59, t53.ID_pertsonala AS ID_pertsonala_60, t53.ID_ohikogela AS ID_ohikogela_61, t62.ID_langilea AS ID_langilea_63, t62.mota AS mota_64, t62.roles AS roles_65, t62.kontratomota AS kontratomota_66, t62.altadata AS altadata_67, t62.bajadata AS bajadata_68, t62.titulazioak AS titulazioak_69, t62.egoera AS egoera_70, t62.ID_pertsonala AS ID_pertsonala_71 FROM pertsonala t0 LEFT JOIN ikaslea t44 ON t44.ID_pertsonala = t0.ID_pertsonala LEFT JOIN irakaslea t53 ON t53.ID_pertsonala = t0.ID_pertsonala LEFT JOIN langilea t62 ON t62.ID_pertsonala = t0.ID_pertsonala WHERE t0.ID_pertsonala = 21868;