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.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 = 'Ord_jarri' LIMIT 1;

SELECT
  t0.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_1,
  t0.orduaHasi AS orduaHasi_2,
  t0.orduaBukatu AS orduaBukatu_3,
  t0.astekoEguna AS astekoEguna_4,
  t0.ordutegiMota AS ordutegiMota_5,
  t0.ID_irakaslea AS ID_irakaslea_6,
  t0.ID_gela AS ID_gela_7,
  t0.ID_ikasturtea AS ID_ikasturtea_8,
  t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_9
FROM
  irakasleordutegia t0
WHERE
  t0.ID_IrakasleOrdutegia = ?

SELECT t0.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_1, t0.orduaHasi AS orduaHasi_2, t0.orduaBukatu AS orduaBukatu_3, t0.astekoEguna AS astekoEguna_4, t0.ordutegiMota AS ordutegiMota_5, t0.ID_irakaslea AS ID_irakaslea_6, t0.ID_gela AS ID_gela_7, t0.ID_ikasturtea AS ID_ikasturtea_8, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_9 FROM irakasleordutegia t0 WHERE t0.ID_IrakasleOrdutegia = 296;

SELECT
  t0.ID_gela AS ID_gela_1,
  t0.ordena AS ordena_2,
  t0.solairua AS solairua_3,
  t0.gela AS gela_4,
  t0.aforo AS aforo_5,
  t0.argazkia AS argazkia_6,
  t0.ekipamendua AS ekipamendua_7,
  t0.aktiba AS aktiba_8,
  t0.ID_Sedea AS ID_Sedea_9
FROM
  gela t0
WHERE
  t0.ID_gela = ?

SELECT t0.ID_gela AS ID_gela_1, t0.ordena AS ordena_2, t0.solairua AS solairua_3, t0.gela AS gela_4, t0.aforo AS aforo_5, t0.argazkia AS argazkia_6, t0.ekipamendua AS ekipamendua_7, t0.aktiba AS aktiba_8, t0.ID_Sedea AS ID_Sedea_9 FROM gela t0 WHERE t0.ID_gela = 69;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  irakasleordutegia
SET
  ID_gela = ?
WHERE
  ID_IrakasleOrdutegia = ?

UPDATE irakasleordutegia SET ID_gela = 69 WHERE ID_IrakasleOrdutegia = 296;

"COMMIT"

"COMMIT";

SELECT
  t0.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_1,
  t0.orduaHasi AS orduaHasi_2,
  t0.orduaBukatu AS orduaBukatu_3,
  t0.astekoEguna AS astekoEguna_4,
  t0.ordutegiMota AS ordutegiMota_5,
  t0.ID_irakaslea AS ID_irakaslea_6,
  t0.ID_gela AS ID_gela_7,
  t0.ID_ikasturtea AS ID_ikasturtea_8,
  t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_9
FROM
  irakasleordutegia t0
WHERE
  t0.ID_IrakasleOrdutegia = ?

SELECT t0.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_1, t0.orduaHasi AS orduaHasi_2, t0.orduaBukatu AS orduaBukatu_3, t0.astekoEguna AS astekoEguna_4, t0.ordutegiMota AS ordutegiMota_5, t0.ID_irakaslea AS ID_irakaslea_6, t0.ID_gela AS ID_gela_7, t0.ID_ikasturtea AS ID_ikasturtea_8, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_9 FROM irakasleordutegia t0 WHERE t0.ID_IrakasleOrdutegia = 296;

SELECT
  t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1,
  t0.aukeraIzena AS aukeraIzena_2,
  t0.dataHasi AS dataHasi_3,
  t0.dataBukatu AS dataBukatu_4,
  t0.ID_eskeintza AS ID_eskeintza_5
FROM
  ordutegiaukera t0
WHERE
  t0.ID_OrdutegiAukera = ?

SELECT t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_1, t0.aukeraIzena AS aukeraIzena_2, t0.dataHasi AS dataHasi_3, t0.dataBukatu AS dataBukatu_4, t0.ID_eskeintza AS ID_eskeintza_5 FROM ordutegiaukera t0 WHERE t0.ID_OrdutegiAukera = 212;

SELECT
  t0.ID_Ordutegia AS ID_Ordutegia_1,
  t0.orduaHasi AS orduaHasi_2,
  t0.orduaBukatu AS orduaBukatu_3,
  t0.astekoEguna AS astekoEguna_4,
  t0.ID_gela AS ID_gela_5,
  t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_6
FROM
  ordutegia t0
WHERE
  t0.ID_OrdutegiAukera = ?
ORDER BY
  t0.astekoEguna ASC,
  t0.orduaHasi ASC

SELECT t0.ID_Ordutegia AS ID_Ordutegia_1, t0.orduaHasi AS orduaHasi_2, t0.orduaBukatu AS orduaBukatu_3, t0.astekoEguna AS astekoEguna_4, t0.ID_gela AS ID_gela_5, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_6 FROM ordutegia t0 WHERE t0.ID_OrdutegiAukera = 212 ORDER BY t0.astekoEguna ASC, t0.orduaHasi ASC;

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  ordutegia
WHERE
  ID_Ordutegia = ?

DELETE FROM ordutegia WHERE ID_Ordutegia = 605;

"COMMIT"

"COMMIT";

SELECT
  i0_.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_0,
  i0_.orduaHasi AS orduaHasi_1,
  i0_.orduaBukatu AS orduaBukatu_2,
  i0_.astekoEguna AS astekoEguna_3,
  i0_.ordutegiMota AS ordutegiMota_4,
  i0_.ID_irakaslea AS ID_irakaslea_5,
  i0_.ID_gela AS ID_gela_6,
  i0_.ID_ikasturtea AS ID_ikasturtea_7,
  i0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_8
FROM
  irakasleordutegia i0_
WHERE
  i0_.ID_OrdutegiAukera = ?
ORDER BY
  i0_.astekoEguna ASC,
  i0_.orduaHasi ASC

SELECT i0_.ID_IrakasleOrdutegia AS ID_IrakasleOrdutegia_0, i0_.orduaHasi AS orduaHasi_1, i0_.orduaBukatu AS orduaBukatu_2, i0_.astekoEguna AS astekoEguna_3, i0_.ordutegiMota AS ordutegiMota_4, i0_.ID_irakaslea AS ID_irakaslea_5, i0_.ID_gela AS ID_gela_6, i0_.ID_ikasturtea AS ID_ikasturtea_7, i0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_8 FROM irakasleordutegia i0_ WHERE i0_.ID_OrdutegiAukera = 212 ORDER BY i0_.astekoEguna ASC, i0_.orduaHasi ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ordutegia (
  orduaHasi, orduaBukatu, astekoEguna,
  ID_gela, ID_OrdutegiAukera
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO ordutegia (orduaHasi, orduaBukatu, astekoEguna, ID_gela, ID_OrdutegiAukera) VALUES ('19:00:00', '19:30:00', 5, 69, 212);

"COMMIT"

"COMMIT";

SELECT
  t0.ID_eskeintza AS ID_eskeintza_1,
  t0.zerrenda AS zerrenda_2,
  t0.maila AS maila_3,
  t0.kurtsoa AS kurtsoa_4,
  t0.taldea AS taldea_5,
  t0.gutxienekoAdina AS gutxienekoAdina_6,
  t0.gehienekoAdina AS gehienekoAdina_7,
  t0.bileraordutegia AS bileraordutegia_8,
  t0.bileraordutegiaerderaz AS bileraordutegiaerderaz_9,
  t0.prezioa AS prezioa_10,
  t0.prezioa1ikasgaia AS prezioa1ikasgaia_11,
  t0.remesable AS remesable_12,
  t0.subvencionable AS subvencionable_13,
  t0.ordutegiaerakutsi AS ordutegiaerakutsi_14,
  t0.ikasleakklasebakoitzean AS ikasleakklasebakoitzean_15,
  t0.klaseareniraupena AS klaseareniraupena_16,
  t0.banakakoa AS banakakoa_17,
  t0.kolorea AS kolorea_18,
  t0.aktibazioData AS aktibazioData_19,
  t0.desaktibazioData AS desaktibazioData_20,
  t0.ID_ikasgaia AS ID_ikasgaia_21,
  t0.ID_irakaslea AS ID_irakaslea_22,
  t0.ID_kuotamatrikula AS ID_kuotamatrikula_23,
  t0.ID_sedea AS ID_sedea_24,
  t0.ID_ikasturtea AS ID_ikasturtea_25
FROM
  eskeintza t0
WHERE
  t0.ID_eskeintza = ?

SELECT t0.ID_eskeintza AS ID_eskeintza_1, t0.zerrenda AS zerrenda_2, t0.maila AS maila_3, t0.kurtsoa AS kurtsoa_4, t0.taldea AS taldea_5, t0.gutxienekoAdina AS gutxienekoAdina_6, t0.gehienekoAdina AS gehienekoAdina_7, t0.bileraordutegia AS bileraordutegia_8, t0.bileraordutegiaerderaz AS bileraordutegiaerderaz_9, t0.prezioa AS prezioa_10, t0.prezioa1ikasgaia AS prezioa1ikasgaia_11, t0.remesable AS remesable_12, t0.subvencionable AS subvencionable_13, t0.ordutegiaerakutsi AS ordutegiaerakutsi_14, t0.ikasleakklasebakoitzean AS ikasleakklasebakoitzean_15, t0.klaseareniraupena AS klaseareniraupena_16, t0.banakakoa AS banakakoa_17, t0.kolorea AS kolorea_18, t0.aktibazioData AS aktibazioData_19, t0.desaktibazioData AS desaktibazioData_20, t0.ID_ikasgaia AS ID_ikasgaia_21, t0.ID_irakaslea AS ID_irakaslea_22, t0.ID_kuotamatrikula AS ID_kuotamatrikula_23, t0.ID_sedea AS ID_sedea_24, t0.ID_ikasturtea AS ID_ikasturtea_25 FROM eskeintza t0 WHERE t0.ID_eskeintza = 1565;

SELECT
  o0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_0,
  o0_.aukeraIzena AS aukeraIzena_1,
  o0_.dataHasi AS dataHasi_2,
  o0_.dataBukatu AS dataBukatu_3,
  o0_.ID_eskeintza AS ID_eskeintza_4
FROM
  ordutegiaukera o0_
  LEFT JOIN eskeintza e1_ ON o0_.ID_eskeintza = e1_.ID_eskeintza
  LEFT JOIN ikasgaia i2_ ON e1_.ID_ikasgaia = i2_.ID_ikasgaia
WHERE
  e1_.ID_irakaslea = ?
  AND e1_.ID_ikasturtea = ?
  OR EXISTS (
    SELECT
      a3_.ID_akademikoa
    FROM
      akademikoa a3_
    WHERE
      o0_.ID_OrdutegiAukera = a3_.ID_OrdutegiAukera
      AND a3_.ID_irakaslea = ?
      AND a3_.ID_ikasturtea = ?
  )
ORDER BY
  o0_.aukeraIzena ASC,
  i2_.ikasgaiMota ASC,
  i2_.tutoretzarakolehentasuna ASC

SELECT o0_.ID_OrdutegiAukera AS ID_OrdutegiAukera_0, o0_.aukeraIzena AS aukeraIzena_1, o0_.dataHasi AS dataHasi_2, o0_.dataBukatu AS dataBukatu_3, o0_.ID_eskeintza AS ID_eskeintza_4 FROM ordutegiaukera o0_ LEFT JOIN eskeintza e1_ ON o0_.ID_eskeintza = e1_.ID_eskeintza LEFT JOIN ikasgaia i2_ ON e1_.ID_ikasgaia = i2_.ID_ikasgaia WHERE e1_.ID_irakaslea = 7321 AND e1_.ID_ikasturtea = 2025 OR EXISTS (SELECT a3_.ID_akademikoa FROM akademikoa a3_ WHERE o0_.ID_OrdutegiAukera = a3_.ID_OrdutegiAukera AND a3_.ID_irakaslea = 7321 AND a3_.ID_ikasturtea = 2025) ORDER BY o0_.aukeraIzena ASC, i2_.ikasgaiMota ASC, i2_.tutoretzarakolehentasuna ASC;

SELECT
  t0.ID_gela AS ID_gela_1,
  t0.ordena AS ordena_2,
  t0.solairua AS solairua_3,
  t0.gela AS gela_4,
  t0.aforo AS aforo_5,
  t0.argazkia AS argazkia_6,
  t0.ekipamendua AS ekipamendua_7,
  t0.aktiba AS aktiba_8,
  t0.ID_Sedea AS ID_Sedea_9
FROM
  gela t0

SELECT t0.ID_gela AS ID_gela_1, t0.ordena AS ordena_2, t0.solairua AS solairua_3, t0.gela AS gela_4, t0.aforo AS aforo_5, t0.argazkia AS argazkia_6, t0.ekipamendua AS ekipamendua_7, t0.aktiba AS aktiba_8, t0.ID_Sedea AS ID_Sedea_9 FROM gela t0;

SELECT
  t0.ID_akademikoa AS ID_akademikoa_1,
  t0.maila AS maila_2,
  t0.kurtsoa AS kurtsoa_3,
  t0.taldea AS taldea_4,
  t0.hurrengokurtsoa AS hurrengokurtsoa_5,
  t0.bigarrenmusikatresna AS bigarrenmusikatresna_6,
  t0.funtsezkoikaskuntza AS funtsezkoikaskuntza_7,
  t0.oharraknotetan1 AS oharraknotetan1_8,
  t0.oharraknotetan2 AS oharraknotetan2_9,
  t0.oharraknotetan3 AS oharraknotetan3_10,
  t0.kurtsokoNotaOrokorra AS kurtsokoNotaOrokorra_11,
  t0.notaInprimatu AS notaInprimatu_12,
  t0.egoera AS egoera_13,
  t0.itxarotezerrendaordena AS itxarotezerrendaordena_14,
  t0.matrikulazioData AS matrikulazioData_15,
  t0.bajadata AS bajadata_16,
  t0.ezohikobaja AS ezohikobaja_17,
  t0.ezohikobajaarrazoia AS ezohikobajaarrazoia_18,
  t0.aktibazioData AS aktibazioData_19,
  t0.desaktibazioData AS desaktibazioData_20,
  t0.ezOhikoPrezioa AS ezOhikoPrezioa_21,
  t0.prezioaIkasgaia AS prezioaIkasgaia_22,
  t0.porzentaia1 AS porzentaia1_23,
  t0.porzentaia2 AS porzentaia2_24,
  t0.porzentaia3 AS porzentaia3_25,
  t0.porzentaia4 AS porzentaia4_26,
  t0.porzentaia5 AS porzentaia5_27,
  t0.porzentaia6 AS porzentaia6_28,
  t0.porzentaia7 AS porzentaia7_29,
  t0.porzentaia8 AS porzentaia8_30,
  t0.porzentaia9 AS porzentaia9_31,
  t0.porzentaia10 AS porzentaia10_32,
  t0.kobraezin AS kobraezin_33,
  t0.lehenengoikasgaia AS lehenengoikasgaia_34,
  t0.zenbatklase AS zenbatklase_35,
  t0.aprobetxamentua AS aprobetxamentua_36,
  t0.faltakbehartu AS faltakbehartu_37,
  t0.matrikulaznb AS matrikulaznb_38,
  t0.eskaeraznb AS eskaeraznb_39,
  t0.zenbatzenso AS zenbatzenso_40,
  t0.zenbatajustezenso AS zenbatajustezenso_41,
  t0.ikasleakonartutakoa AS ikasleakonartutakoa_42,
  t0.ID_ikaslea AS ID_ikaslea_43,
  t0.ID_irakaslea AS ID_irakaslea_44,
  t0.ID_hurrengoikasturtekoakademikoa AS ID_hurrengoikasturtekoakademikoa_45,
  t0.ID_eskeintza AS ID_eskeintza_46,
  t47.ID_matrikula AS ID_matrikula_48,
  t47.eskatzailearenemaila AS eskatzailearenemaila_49,
  t47.maila AS maila_50,
  t47.kurtsoa AS kurtsoa_51,
  t47.taldea AS taldea_52,
  t47.matrikulazioData AS matrikulazioData_53,
  t47.itxarotezerrendaordena AS itxarotezerrendaordena_54,
  t47.oharrak AS oharrak_55,
  t47.ezohikoprezioa AS ezohikoprezioa_56,
  t47.lehenengoikasgaia AS lehenengoikasgaia_57,
  t47.matrikulaznb AS matrikulaznb_58,
  t47.onartua AS onartua_59,
  t47.verify AS verify_60,
  t47.ID_ikaslea AS ID_ikaslea_61,
  t47.ID_ikasgaia AS ID_ikasgaia_62,
  t47.ID_sedea AS ID_sedea_63,
  t47.aukera1 AS aukera1_64,
  t47.aukera2 AS aukera2_65,
  t47.ID_ikasturtea AS ID_ikasturtea_66,
  t47.ID_akademikoa AS ID_akademikoa_67,
  t0.ID_ikasgaia AS ID_ikasgaia_68,
  t0.ID_aukera1 AS ID_aukera1_69,
  t0.ID_aukera2 AS ID_aukera2_70,
  t0.taldekomusikatresna AS taldekomusikatresna_71,
  t0.ID_zenso AS ID_zenso_72,
  t0.ID_zensoajuste AS ID_zensoajuste_73,
  t0.ID_sedea AS ID_sedea_74,
  t0.ID_ikasturtea AS ID_ikasturtea_75,
  t0.ID_Multibilera AS ID_Multibilera_76,
  t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_77
FROM
  akademikoa t0
  LEFT JOIN matrikula t47 ON t47.ID_akademikoa = t0.ID_akademikoa
WHERE
  t0.ID_OrdutegiAukera = ?

SELECT t0.ID_akademikoa AS ID_akademikoa_1, t0.maila AS maila_2, t0.kurtsoa AS kurtsoa_3, t0.taldea AS taldea_4, t0.hurrengokurtsoa AS hurrengokurtsoa_5, t0.bigarrenmusikatresna AS bigarrenmusikatresna_6, t0.funtsezkoikaskuntza AS funtsezkoikaskuntza_7, t0.oharraknotetan1 AS oharraknotetan1_8, t0.oharraknotetan2 AS oharraknotetan2_9, t0.oharraknotetan3 AS oharraknotetan3_10, t0.kurtsokoNotaOrokorra AS kurtsokoNotaOrokorra_11, t0.notaInprimatu AS notaInprimatu_12, t0.egoera AS egoera_13, t0.itxarotezerrendaordena AS itxarotezerrendaordena_14, t0.matrikulazioData AS matrikulazioData_15, t0.bajadata AS bajadata_16, t0.ezohikobaja AS ezohikobaja_17, t0.ezohikobajaarrazoia AS ezohikobajaarrazoia_18, t0.aktibazioData AS aktibazioData_19, t0.desaktibazioData AS desaktibazioData_20, t0.ezOhikoPrezioa AS ezOhikoPrezioa_21, t0.prezioaIkasgaia AS prezioaIkasgaia_22, t0.porzentaia1 AS porzentaia1_23, t0.porzentaia2 AS porzentaia2_24, t0.porzentaia3 AS porzentaia3_25, t0.porzentaia4 AS porzentaia4_26, t0.porzentaia5 AS porzentaia5_27, t0.porzentaia6 AS porzentaia6_28, t0.porzentaia7 AS porzentaia7_29, t0.porzentaia8 AS porzentaia8_30, t0.porzentaia9 AS porzentaia9_31, t0.porzentaia10 AS porzentaia10_32, t0.kobraezin AS kobraezin_33, t0.lehenengoikasgaia AS lehenengoikasgaia_34, t0.zenbatklase AS zenbatklase_35, t0.aprobetxamentua AS aprobetxamentua_36, t0.faltakbehartu AS faltakbehartu_37, t0.matrikulaznb AS matrikulaznb_38, t0.eskaeraznb AS eskaeraznb_39, t0.zenbatzenso AS zenbatzenso_40, t0.zenbatajustezenso AS zenbatajustezenso_41, t0.ikasleakonartutakoa AS ikasleakonartutakoa_42, t0.ID_ikaslea AS ID_ikaslea_43, t0.ID_irakaslea AS ID_irakaslea_44, t0.ID_hurrengoikasturtekoakademikoa AS ID_hurrengoikasturtekoakademikoa_45, t0.ID_eskeintza AS ID_eskeintza_46, t47.ID_matrikula AS ID_matrikula_48, t47.eskatzailearenemaila AS eskatzailearenemaila_49, t47.maila AS maila_50, t47.kurtsoa AS kurtsoa_51, t47.taldea AS taldea_52, t47.matrikulazioData AS matrikulazioData_53, t47.itxarotezerrendaordena AS itxarotezerrendaordena_54, t47.oharrak AS oharrak_55, t47.ezohikoprezioa AS ezohikoprezioa_56, t47.lehenengoikasgaia AS lehenengoikasgaia_57, t47.matrikulaznb AS matrikulaznb_58, t47.onartua AS onartua_59, t47.verify AS verify_60, t47.ID_ikaslea AS ID_ikaslea_61, t47.ID_ikasgaia AS ID_ikasgaia_62, t47.ID_sedea AS ID_sedea_63, t47.aukera1 AS aukera1_64, t47.aukera2 AS aukera2_65, t47.ID_ikasturtea AS ID_ikasturtea_66, t47.ID_akademikoa AS ID_akademikoa_67, t0.ID_ikasgaia AS ID_ikasgaia_68, t0.ID_aukera1 AS ID_aukera1_69, t0.ID_aukera2 AS ID_aukera2_70, t0.taldekomusikatresna AS taldekomusikatresna_71, t0.ID_zenso AS ID_zenso_72, t0.ID_zensoajuste AS ID_zensoajuste_73, t0.ID_sedea AS ID_sedea_74, t0.ID_ikasturtea AS ID_ikasturtea_75, t0.ID_Multibilera AS ID_Multibilera_76, t0.ID_OrdutegiAukera AS ID_OrdutegiAukera_77 FROM akademikoa t0 LEFT JOIN matrikula t47 ON t47.ID_akademikoa = t0.ID_akademikoa WHERE t0.ID_OrdutegiAukera = 212;