Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.abreviatura AS abreviatura_2,
  t0.descripcion AS descripcion_3,
  t0.idmaterial AS idmaterial_4,
  t0.cambridgefee AS cambridgefee_5,
  t0.speakingwindow AS speakingwindow_6,
  t0.maxslots AS maxslots_7,
  t0.preciocambridge AS preciocambridge_8,
  t0.preciocolegio AS preciocolegio_9,
  t0.preciofomento AS preciofomento_10,
  t0.preciouco AS preciouco_11,
  t0.preciouja AS preciouja_12,
  t0.precioual AS precioual_13,
  t0.preciocsanfrancisco AS preciocsanfrancisco_14,
  t0.preciougibraltar AS preciougibraltar_15,
  t0.preciogranadacollege AS preciogranadacollege_16,
  t0.precioceuta AS precioceuta_17,
  t0.creacionfecha AS creacionfecha_18,
  t0.modificacionfecha AS modificacionfecha_19,
  t0.logo AS logo_20,
  t0.duracionprevista AS duracionprevista_21,
  t0.nombre AS nombre_22,
  t0.descripcionpublica AS descripcionpublica_23,
  t0.color AS color_24,
  t0.candidatenumberstart AS candidatenumberstart_25,
  t0.duracionreading AS duracionreading_26,
  t0.duracionwriting AS duracionwriting_27,
  t0.duracionlistening AS duracionlistening_28,
  t0.duracionspeaking AS duracionspeaking_29,
  t0.esspeaking AS esspeaking_30,
  t0.orden AS orden_31,
  t0.descripcionexamen AS descripcionexamen_32,
  t0.slug AS slug_33,
  t0.lateEntry1Importe AS lateEntry1Importe_34,
  t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_35,
  t0.lateEntry1Dias AS lateEntry1Dias_36,
  t0.lateEntry2Importe AS lateEntry2Importe_37,
  t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_38,
  t0.lateEntry2Dias AS lateEntry2Dias_39,
  t0.lateEntry3Importe AS lateEntry3Importe_40,
  t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_41,
  t0.lateEntry3Dias AS lateEntry3Dias_42,
  t0.dniObligatorio AS dniObligatorio_43,
  t0.creacionusuario_id AS creacionusuario_id_44,
  t0.modificacionusuario_id AS modificacionusuario_id_45
FROM
  tipos_certificacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.abreviatura AS abreviatura_2, t0.descripcion AS descripcion_3, t0.idmaterial AS idmaterial_4, t0.cambridgefee AS cambridgefee_5, t0.speakingwindow AS speakingwindow_6, t0.maxslots AS maxslots_7, t0.preciocambridge AS preciocambridge_8, t0.preciocolegio AS preciocolegio_9, t0.preciofomento AS preciofomento_10, t0.preciouco AS preciouco_11, t0.preciouja AS preciouja_12, t0.precioual AS precioual_13, t0.preciocsanfrancisco AS preciocsanfrancisco_14, t0.preciougibraltar AS preciougibraltar_15, t0.preciogranadacollege AS preciogranadacollege_16, t0.precioceuta AS precioceuta_17, t0.creacionfecha AS creacionfecha_18, t0.modificacionfecha AS modificacionfecha_19, t0.logo AS logo_20, t0.duracionprevista AS duracionprevista_21, t0.nombre AS nombre_22, t0.descripcionpublica AS descripcionpublica_23, t0.color AS color_24, t0.candidatenumberstart AS candidatenumberstart_25, t0.duracionreading AS duracionreading_26, t0.duracionwriting AS duracionwriting_27, t0.duracionlistening AS duracionlistening_28, t0.duracionspeaking AS duracionspeaking_29, t0.esspeaking AS esspeaking_30, t0.orden AS orden_31, t0.descripcionexamen AS descripcionexamen_32, t0.slug AS slug_33, t0.lateEntry1Importe AS lateEntry1Importe_34, t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_35, t0.lateEntry1Dias AS lateEntry1Dias_36, t0.lateEntry2Importe AS lateEntry2Importe_37, t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_38, t0.lateEntry2Dias AS lateEntry2Dias_39, t0.lateEntry3Importe AS lateEntry3Importe_40, t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_41, t0.lateEntry3Dias AS lateEntry3Dias_42, t0.dniObligatorio AS dniObligatorio_43, t0.creacionusuario_id AS creacionusuario_id_44, t0.modificacionusuario_id AS modificacionusuario_id_45 FROM tipos_certificacion t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_4,
  t0.nombre AS nombre_5,
  t0.apellido1 AS apellido1_6,
  t0.apellido2 AS apellido2_7,
  t0.nif_cif AS nif_cif_8,
  t0.usuario AS usuario_9,
  t0.email AS email_10,
  t0.password AS password_11,
  t0.salt AS salt_12,
  t0.activo AS activo_13,
  t0.role AS role_14,
  t0.permisocambridge AS permisocambridge_15,
  t0.permisopagos AS permisopagos_16,
  t0.permisomatriculacion AS permisomatriculacion_17,
  t0.creacionusuario AS creacionusuario_18,
  t0.creacionfecha AS creacionfecha_19,
  t0.modificacionusuario AS modificacionusuario_20,
  t0.modificacionfecha AS modificacionfecha_21,
  t0.permisoacademia AS permisoacademia_22,
  t0.codigorecuperacion AS codigorecuperacion_23,
  t0.direccion AS direccion_24,
  t0.cp AS cp_25,
  t0.telefono1 AS telefono1_26,
  t0.telefono2 AS telefono2_27,
  t0.eliminadologico AS eliminadologico_28,
  t0.tipos_documento_id AS tipos_documento_id_29,
  t0.idtipousuario_id AS idtipousuario_id_30,
  t0.idpoblacion_id AS idpoblacion_id_31,
  t0.idprovincia_id AS idprovincia_id_32,
  t0.tipo,
  t1.latitud AS latitud_33,
  t1.longitud AS longitud_34,
  t1.personacontacto AS personacontacto_35,
  t1.pathacademia AS pathacademia_36,
  t1.numerosubidasimagen AS numerosubidasimagen_37,
  t1.orden AS orden_38,
  t1.indverificado AS indverificado_39,
  t1.hastaultimodia AS hastaultimodia_40,
  t1.indadmitecerradas AS indadmitecerradas_41,
  t1.estadovisual AS estadovisual_42,
  t1.centrenumber AS centrenumber_43,
  t1.observaciones AS observaciones_44,
  t1.web AS web_45,
  t1.directorcentro AS directorcentro_46,
  t1.premium AS premium_47,
  t1.beneficiospremium AS beneficiospremium_48,
  t1.sendemail AS sendemail_49,
  t1.showedescription AS showedescription_50,
  t1.canjeoespecial AS canjeoespecial_51,
  t1.tipoacuerdo AS tipoacuerdo_52,
  t1.centropreparador AS centropreparador_53,
  t1.ispublic AS ispublic_54,
  t1.mostrarenmapa AS mostrarenmapa_55,
  t1.codigoacademia AS codigoacademia_56,
  t1.emailcoe AS emailcoe_57,
  t1.passopen AS passopen_58,
  t1.accesoinicial AS accesoinicial_59,
  t1.contraseniaaleatoria AS contraseniaaleatoria_60,
  t1.descuento AS descuento_61,
  t1.tituloposicionamiento AS tituloposicionamiento_62,
  t1.textoposicionamiento AS textoposicionamiento_63,
  t1.ordenadores AS ordenadores_64,
  t1.slug AS slug_65,
  t1.sluglinguaskill AS sluglinguaskill_66,
  t1.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_67,
  t1.seleccionhorario AS seleccionhorario_68,
  t1.informacion AS informacion_69,
  t1.codecenter AS codecenter_70,
  t1.isinstitucion AS isinstitucion_71,
  t1.tipoenlace AS tipoenlace_72,
  t1.conversiondinero AS conversiondinero_73,
  t1.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_74,
  t1.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_75,
  t1.puedematricularotroscentros AS puedematricularotroscentros_76,
  t1.cuentacontable AS cuentacontable_77,
  t1.razonsocial AS razonsocial_78,
  t1.direccionfacturacion AS direccionfacturacion_79,
  t1.cpfacturacion AS cpfacturacion_80,
  t1.poblacionfacturacion AS poblacionfacturacion_81,
  t1.provinciafacturacion AS provinciafacturacion_82,
  t1.paisfacturacion AS paisfacturacion_83,
  t1.convocatorias_slug AS convocatorias_slug_84,
  t1.puede_solicitar_facturas AS puede_solicitar_facturas_85,
  t1.datos_rellenos AS datos_rellenos_86,
  t1.pagalateentry1 AS pagalateentry1_87,
  t1.pagalateentry2 AS pagalateentry2_88,
  t1.pagalateentry3 AS pagalateentry3_89,
  t1.saltardni AS saltardni_90,
  t1.condicionesSlugQualifications AS condicionesSlugQualifications_91,
  t1.tipovenue_id AS tipovenue_id_92,
  t1.poblacion_info_id AS poblacion_info_id_93,
  t2.fechanacimiento AS fechanacimiento_94,
  t2.genero AS genero_95,
  t2.codigopostal AS codigopostal_96,
  t2.numerocandidato AS numerocandidato_97,
  t2.documentacionespecial AS documentacionespecial_98,
  t2.telefonocontacto AS telefonocontacto_99,
  t2.alumnopropio AS alumnopropio_100,
  t2.dni AS dni_101,
  t2.comunicaciones AS comunicaciones_102,
  t2.md5registro AS md5registro_103,
  t2.idtipoespecial_id AS idtipoespecial_id_104,
  t2.codigoacademia_id AS codigoacademia_id_105,
  t3.centrotrabajo AS centrotrabajo_106,
  t3.coche AS coche_107,
  t3.cuentaBanco AS cuentaBanco_108,
  t3.examLevel AS examLevel_109,
  t3.fechanacimiento AS fechanacimiento_110,
  t3.idtiponivelexterno_id AS idtiponivelexterno_id_111,
  t3.idocupacionexternos_id AS idocupacionexternos_id_112
FROM
  usuarios t0
  LEFT JOIN academias t1 ON t0.id = t1.id
  LEFT JOIN alumnos t2 ON t0.id = t2.id
  LEFT JOIN personalexterno t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.nombre AS nombre_5, t0.apellido1 AS apellido1_6, t0.apellido2 AS apellido2_7, t0.nif_cif AS nif_cif_8, t0.usuario AS usuario_9, t0.email AS email_10, t0.password AS password_11, t0.salt AS salt_12, t0.activo AS activo_13, t0.role AS role_14, t0.permisocambridge AS permisocambridge_15, t0.permisopagos AS permisopagos_16, t0.permisomatriculacion AS permisomatriculacion_17, t0.creacionusuario AS creacionusuario_18, t0.creacionfecha AS creacionfecha_19, t0.modificacionusuario AS modificacionusuario_20, t0.modificacionfecha AS modificacionfecha_21, t0.permisoacademia AS permisoacademia_22, t0.codigorecuperacion AS codigorecuperacion_23, t0.direccion AS direccion_24, t0.cp AS cp_25, t0.telefono1 AS telefono1_26, t0.telefono2 AS telefono2_27, t0.eliminadologico AS eliminadologico_28, t0.tipos_documento_id AS tipos_documento_id_29, t0.idtipousuario_id AS idtipousuario_id_30, t0.idpoblacion_id AS idpoblacion_id_31, t0.idprovincia_id AS idprovincia_id_32, t0.tipo, t1.latitud AS latitud_33, t1.longitud AS longitud_34, t1.personacontacto AS personacontacto_35, t1.pathacademia AS pathacademia_36, t1.numerosubidasimagen AS numerosubidasimagen_37, t1.orden AS orden_38, t1.indverificado AS indverificado_39, t1.hastaultimodia AS hastaultimodia_40, t1.indadmitecerradas AS indadmitecerradas_41, t1.estadovisual AS estadovisual_42, t1.centrenumber AS centrenumber_43, t1.observaciones AS observaciones_44, t1.web AS web_45, t1.directorcentro AS directorcentro_46, t1.premium AS premium_47, t1.beneficiospremium AS beneficiospremium_48, t1.sendemail AS sendemail_49, t1.showedescription AS showedescription_50, t1.canjeoespecial AS canjeoespecial_51, t1.tipoacuerdo AS tipoacuerdo_52, t1.centropreparador AS centropreparador_53, t1.ispublic AS ispublic_54, t1.mostrarenmapa AS mostrarenmapa_55, t1.codigoacademia AS codigoacademia_56, t1.emailcoe AS emailcoe_57, t1.passopen AS passopen_58, t1.accesoinicial AS accesoinicial_59, t1.contraseniaaleatoria AS contraseniaaleatoria_60, t1.descuento AS descuento_61, t1.tituloposicionamiento AS tituloposicionamiento_62, t1.textoposicionamiento AS textoposicionamiento_63, t1.ordenadores AS ordenadores_64, t1.slug AS slug_65, t1.sluglinguaskill AS sluglinguaskill_66, t1.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_67, t1.seleccionhorario AS seleccionhorario_68, t1.informacion AS informacion_69, t1.codecenter AS codecenter_70, t1.isinstitucion AS isinstitucion_71, t1.tipoenlace AS tipoenlace_72, t1.conversiondinero AS conversiondinero_73, t1.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_74, t1.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_75, t1.puedematricularotroscentros AS puedematricularotroscentros_76, t1.cuentacontable AS cuentacontable_77, t1.razonsocial AS razonsocial_78, t1.direccionfacturacion AS direccionfacturacion_79, t1.cpfacturacion AS cpfacturacion_80, t1.poblacionfacturacion AS poblacionfacturacion_81, t1.provinciafacturacion AS provinciafacturacion_82, t1.paisfacturacion AS paisfacturacion_83, t1.convocatorias_slug AS convocatorias_slug_84, t1.puede_solicitar_facturas AS puede_solicitar_facturas_85, t1.datos_rellenos AS datos_rellenos_86, t1.pagalateentry1 AS pagalateentry1_87, t1.pagalateentry2 AS pagalateentry2_88, t1.pagalateentry3 AS pagalateentry3_89, t1.saltardni AS saltardni_90, t1.condicionesSlugQualifications AS condicionesSlugQualifications_91, t1.tipovenue_id AS tipovenue_id_92, t1.poblacion_info_id AS poblacion_info_id_93, t2.fechanacimiento AS fechanacimiento_94, t2.genero AS genero_95, t2.codigopostal AS codigopostal_96, t2.numerocandidato AS numerocandidato_97, t2.documentacionespecial AS documentacionespecial_98, t2.telefonocontacto AS telefonocontacto_99, t2.alumnopropio AS alumnopropio_100, t2.dni AS dni_101, t2.comunicaciones AS comunicaciones_102, t2.md5registro AS md5registro_103, t2.idtipoespecial_id AS idtipoespecial_id_104, t2.codigoacademia_id AS codigoacademia_id_105, t3.centrotrabajo AS centrotrabajo_106, t3.coche AS coche_107, t3.cuentaBanco AS cuentaBanco_108, t3.examLevel AS examLevel_109, t3.fechanacimiento AS fechanacimiento_110, t3.idtiponivelexterno_id AS idtiponivelexterno_id_111, t3.idocupacionexternos_id AS idocupacionexternos_id_112 FROM usuarios t0 LEFT JOIN academias t1 ON t0.id = t1.id LEFT JOIN alumnos t2 ON t0.id = t2.id LEFT JOIN personalexterno t3 ON t0.id = t3.id WHERE t0.id = 5800;

SELECT
  u0_.id AS id_0,
  u0_.nombre AS nombre_1,
  u0_.apellido1 AS apellido1_2,
  u0_.apellido2 AS apellido2_3,
  u0_.nif_cif AS nif_cif_4,
  u0_.usuario AS usuario_5,
  u0_.email AS email_6,
  u0_.password AS password_7,
  u0_.salt AS salt_8,
  u0_.activo AS activo_9,
  u0_.role AS role_10,
  u0_.permisocambridge AS permisocambridge_11,
  u0_.permisopagos AS permisopagos_12,
  u0_.permisomatriculacion AS permisomatriculacion_13,
  u0_.creacionusuario AS creacionusuario_14,
  u0_.creacionfecha AS creacionfecha_15,
  u0_.modificacionusuario AS modificacionusuario_16,
  u0_.modificacionfecha AS modificacionfecha_17,
  u0_.permisoacademia AS permisoacademia_18,
  u0_.codigorecuperacion AS codigorecuperacion_19,
  u0_.direccion AS direccion_20,
  u0_.cp AS cp_21,
  u0_.telefono1 AS telefono1_22,
  u0_.telefono2 AS telefono2_23,
  u0_.eliminadologico AS eliminadologico_24,
  a1_.latitud AS latitud_25,
  a1_.longitud AS longitud_26,
  a1_.personacontacto AS personacontacto_27,
  a1_.pathacademia AS pathacademia_28,
  a1_.numerosubidasimagen AS numerosubidasimagen_29,
  a1_.orden AS orden_30,
  a1_.indverificado AS indverificado_31,
  a1_.hastaultimodia AS hastaultimodia_32,
  a1_.indadmitecerradas AS indadmitecerradas_33,
  a1_.estadovisual AS estadovisual_34,
  a1_.centrenumber AS centrenumber_35,
  a1_.observaciones AS observaciones_36,
  a1_.web AS web_37,
  a1_.directorcentro AS directorcentro_38,
  a1_.premium AS premium_39,
  a1_.beneficiospremium AS beneficiospremium_40,
  a1_.sendemail AS sendemail_41,
  a1_.showedescription AS showedescription_42,
  a1_.canjeoespecial AS canjeoespecial_43,
  a1_.tipoacuerdo AS tipoacuerdo_44,
  a1_.centropreparador AS centropreparador_45,
  a1_.ispublic AS ispublic_46,
  a1_.mostrarenmapa AS mostrarenmapa_47,
  a1_.codigoacademia AS codigoacademia_48,
  a1_.emailcoe AS emailcoe_49,
  a1_.passopen AS passopen_50,
  a1_.accesoinicial AS accesoinicial_51,
  a1_.contraseniaaleatoria AS contraseniaaleatoria_52,
  a1_.descuento AS descuento_53,
  a1_.tituloposicionamiento AS tituloposicionamiento_54,
  a1_.textoposicionamiento AS textoposicionamiento_55,
  a1_.ordenadores AS ordenadores_56,
  a1_.slug AS slug_57,
  a1_.sluglinguaskill AS sluglinguaskill_58,
  a1_.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_59,
  a1_.seleccionhorario AS seleccionhorario_60,
  a1_.informacion AS informacion_61,
  a1_.codecenter AS codecenter_62,
  a1_.isinstitucion AS isinstitucion_63,
  a1_.tipoenlace AS tipoenlace_64,
  a1_.conversiondinero AS conversiondinero_65,
  a1_.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_66,
  a1_.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_67,
  a1_.puedematricularotroscentros AS puedematricularotroscentros_68,
  a1_.cuentacontable AS cuentacontable_69,
  a1_.razonsocial AS razonsocial_70,
  a1_.direccionfacturacion AS direccionfacturacion_71,
  a1_.cpfacturacion AS cpfacturacion_72,
  a1_.poblacionfacturacion AS poblacionfacturacion_73,
  a1_.provinciafacturacion AS provinciafacturacion_74,
  a1_.paisfacturacion AS paisfacturacion_75,
  a1_.convocatorias_slug AS convocatorias_slug_76,
  a1_.puede_solicitar_facturas AS puede_solicitar_facturas_77,
  a1_.datos_rellenos AS datos_rellenos_78,
  a1_.pagalateentry1 AS pagalateentry1_79,
  a1_.pagalateentry2 AS pagalateentry2_80,
  a1_.pagalateentry3 AS pagalateentry3_81,
  a1_.saltardni AS saltardni_82,
  a1_.condicionesSlugQualifications AS condicionesSlugQualifications_83,
  u0_.tipo AS tipo_84,
  u0_.tipos_documento_id AS tipos_documento_id_85,
  u0_.idtipousuario_id AS idtipousuario_id_86,
  u0_.idpoblacion_id AS idpoblacion_id_87,
  u0_.idprovincia_id AS idprovincia_id_88,
  a1_.tipovenue_id AS tipovenue_id_89,
  a1_.poblacion_info_id AS poblacion_info_id_90
FROM
  academias a1_
  INNER JOIN usuarios u0_ ON a1_.id = u0_.id
WHERE
  u0_.idprovincia_id IS NOT NULL
ORDER BY
  u0_.nombre ASC

SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.apellido1 AS apellido1_2, u0_.apellido2 AS apellido2_3, u0_.nif_cif AS nif_cif_4, u0_.usuario AS usuario_5, u0_.email AS email_6, u0_.password AS password_7, u0_.salt AS salt_8, u0_.activo AS activo_9, u0_.role AS role_10, u0_.permisocambridge AS permisocambridge_11, u0_.permisopagos AS permisopagos_12, u0_.permisomatriculacion AS permisomatriculacion_13, u0_.creacionusuario AS creacionusuario_14, u0_.creacionfecha AS creacionfecha_15, u0_.modificacionusuario AS modificacionusuario_16, u0_.modificacionfecha AS modificacionfecha_17, u0_.permisoacademia AS permisoacademia_18, u0_.codigorecuperacion AS codigorecuperacion_19, u0_.direccion AS direccion_20, u0_.cp AS cp_21, u0_.telefono1 AS telefono1_22, u0_.telefono2 AS telefono2_23, u0_.eliminadologico AS eliminadologico_24, a1_.latitud AS latitud_25, a1_.longitud AS longitud_26, a1_.personacontacto AS personacontacto_27, a1_.pathacademia AS pathacademia_28, a1_.numerosubidasimagen AS numerosubidasimagen_29, a1_.orden AS orden_30, a1_.indverificado AS indverificado_31, a1_.hastaultimodia AS hastaultimodia_32, a1_.indadmitecerradas AS indadmitecerradas_33, a1_.estadovisual AS estadovisual_34, a1_.centrenumber AS centrenumber_35, a1_.observaciones AS observaciones_36, a1_.web AS web_37, a1_.directorcentro AS directorcentro_38, a1_.premium AS premium_39, a1_.beneficiospremium AS beneficiospremium_40, a1_.sendemail AS sendemail_41, a1_.showedescription AS showedescription_42, a1_.canjeoespecial AS canjeoespecial_43, a1_.tipoacuerdo AS tipoacuerdo_44, a1_.centropreparador AS centropreparador_45, a1_.ispublic AS ispublic_46, a1_.mostrarenmapa AS mostrarenmapa_47, a1_.codigoacademia AS codigoacademia_48, a1_.emailcoe AS emailcoe_49, a1_.passopen AS passopen_50, a1_.accesoinicial AS accesoinicial_51, a1_.contraseniaaleatoria AS contraseniaaleatoria_52, a1_.descuento AS descuento_53, a1_.tituloposicionamiento AS tituloposicionamiento_54, a1_.textoposicionamiento AS textoposicionamiento_55, a1_.ordenadores AS ordenadores_56, a1_.slug AS slug_57, a1_.sluglinguaskill AS sluglinguaskill_58, a1_.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_59, a1_.seleccionhorario AS seleccionhorario_60, a1_.informacion AS informacion_61, a1_.codecenter AS codecenter_62, a1_.isinstitucion AS isinstitucion_63, a1_.tipoenlace AS tipoenlace_64, a1_.conversiondinero AS conversiondinero_65, a1_.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_66, a1_.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_67, a1_.puedematricularotroscentros AS puedematricularotroscentros_68, a1_.cuentacontable AS cuentacontable_69, a1_.razonsocial AS razonsocial_70, a1_.direccionfacturacion AS direccionfacturacion_71, a1_.cpfacturacion AS cpfacturacion_72, a1_.poblacionfacturacion AS poblacionfacturacion_73, a1_.provinciafacturacion AS provinciafacturacion_74, a1_.paisfacturacion AS paisfacturacion_75, a1_.convocatorias_slug AS convocatorias_slug_76, a1_.puede_solicitar_facturas AS puede_solicitar_facturas_77, a1_.datos_rellenos AS datos_rellenos_78, a1_.pagalateentry1 AS pagalateentry1_79, a1_.pagalateentry2 AS pagalateentry2_80, a1_.pagalateentry3 AS pagalateentry3_81, a1_.saltardni AS saltardni_82, a1_.condicionesSlugQualifications AS condicionesSlugQualifications_83, u0_.tipo AS tipo_84, u0_.tipos_documento_id AS tipos_documento_id_85, u0_.idtipousuario_id AS idtipousuario_id_86, u0_.idpoblacion_id AS idpoblacion_id_87, u0_.idprovincia_id AS idprovincia_id_88, a1_.tipovenue_id AS tipovenue_id_89, a1_.poblacion_info_id AS poblacion_info_id_90 FROM academias a1_ INNER JOIN usuarios u0_ ON a1_.id = u0_.id WHERE u0_.idprovincia_id IS NOT NULL ORDER BY u0_.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.eliminado AS eliminado_2,
  t0.codigoexam AS codigoexam_3,
  t0.aliasprivada AS aliasprivada_4,
  t0.indcbpb AS indcbpb_5,
  t0.indpublicada AS indpublicada_6,
  t0.incidencia AS incidencia_7,
  t0.fechapublicacion AS fechapublicacion_8,
  t0.indcerradaabierta AS indcerradaabierta_9,
  t0.observacion AS observacion_10,
  t0.indacademia AS indacademia_11,
  t0.numplazasmaximo AS numplazasmaximo_12,
  t0.examdate AS examdate_13,
  t0.fechacierreiml AS fechacierreiml_14,
  t0.venuedetailsdate AS venuedetailsdate_15,
  t0.speakingwindowstart AS speakingwindowstart_16,
  t0.speakingwindowstart2 AS speakingwindowstart2_17,
  t0.speakingwindowend AS speakingwindowend_18,
  t0.resultreleasestart AS resultreleasestart_19,
  t0.resultreleaseend AS resultreleaseend_20,
  t0.certificatedispatch AS certificatedispatch_21,
  t0.color AS color_22,
  t0.logo AS logo_23,
  t0.creacionfecha AS creacionfecha_24,
  t0.modificacionfecha AS modificacionfecha_25,
  t0.serializado AS serializado_26,
  t0.numsupervisores AS numsupervisores_27,
  t0.numvigilantes AS numvigilantes_28,
  t0.fechaultimoavisoexternos AS fechaultimoavisoexternos_29,
  t0.numhorasprevistas AS numhorasprevistas_30,
  t0.entryclosingdate AS entryclosingdate_31,
  t0.precio AS precio_32,
  t0.poblacion AS poblacion_33,
  t0.visto AS visto_34,
  t0.matriculadosespeciales AS matriculadosespeciales_35,
  t0.maximosCandidatos AS maximosCandidatos_36,
  t0.lateEntry1Importe AS lateEntry1Importe_37,
  t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_38,
  t0.lateEntry1Fecha AS lateEntry1Fecha_39,
  t0.lateEntry1Permitido AS lateEntry1Permitido_40,
  t0.lateEntry2Importe AS lateEntry2Importe_41,
  t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_42,
  t0.lateEntry2Fecha AS lateEntry2Fecha_43,
  t0.lateEntry2Permitido AS lateEntry2Permitido_44,
  t0.lateEntry3Importe AS lateEntry3Importe_45,
  t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_46,
  t0.lateEntry3Fecha AS lateEntry3Fecha_47,
  t0.lateEntry3Permitido AS lateEntry3Permitido_48,
  t0.necesidadesEspecialesFecha AS necesidadesEspecialesFecha_49,
  t0.tramo0 AS tramo0_50,
  t0.tramo1 AS tramo1_51,
  t0.tramo2 AS tramo2_52,
  t0.tramo3 AS tramo3_53,
  t0.infoExtra AS infoExtra_54,
  t0.extraImporte AS extraImporte_55,
  t0.aclaracionExamen AS aclaracionExamen_56,
  t0.idtipocertificacion_id AS idtipocertificacion_id_57,
  t0.creacionusuario_id AS creacionusuario_id_58,
  t0.modificacionusuario_id AS modificacionusuario_id_59,
  t0.convocatoriapoblacion_id AS convocatoriapoblacion_id_60,
  t0.vistopor_id AS vistopor_id_61
FROM
  convocatorias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.eliminado AS eliminado_2, t0.codigoexam AS codigoexam_3, t0.aliasprivada AS aliasprivada_4, t0.indcbpb AS indcbpb_5, t0.indpublicada AS indpublicada_6, t0.incidencia AS incidencia_7, t0.fechapublicacion AS fechapublicacion_8, t0.indcerradaabierta AS indcerradaabierta_9, t0.observacion AS observacion_10, t0.indacademia AS indacademia_11, t0.numplazasmaximo AS numplazasmaximo_12, t0.examdate AS examdate_13, t0.fechacierreiml AS fechacierreiml_14, t0.venuedetailsdate AS venuedetailsdate_15, t0.speakingwindowstart AS speakingwindowstart_16, t0.speakingwindowstart2 AS speakingwindowstart2_17, t0.speakingwindowend AS speakingwindowend_18, t0.resultreleasestart AS resultreleasestart_19, t0.resultreleaseend AS resultreleaseend_20, t0.certificatedispatch AS certificatedispatch_21, t0.color AS color_22, t0.logo AS logo_23, t0.creacionfecha AS creacionfecha_24, t0.modificacionfecha AS modificacionfecha_25, t0.serializado AS serializado_26, t0.numsupervisores AS numsupervisores_27, t0.numvigilantes AS numvigilantes_28, t0.fechaultimoavisoexternos AS fechaultimoavisoexternos_29, t0.numhorasprevistas AS numhorasprevistas_30, t0.entryclosingdate AS entryclosingdate_31, t0.precio AS precio_32, t0.poblacion AS poblacion_33, t0.visto AS visto_34, t0.matriculadosespeciales AS matriculadosespeciales_35, t0.maximosCandidatos AS maximosCandidatos_36, t0.lateEntry1Importe AS lateEntry1Importe_37, t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_38, t0.lateEntry1Fecha AS lateEntry1Fecha_39, t0.lateEntry1Permitido AS lateEntry1Permitido_40, t0.lateEntry2Importe AS lateEntry2Importe_41, t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_42, t0.lateEntry2Fecha AS lateEntry2Fecha_43, t0.lateEntry2Permitido AS lateEntry2Permitido_44, t0.lateEntry3Importe AS lateEntry3Importe_45, t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_46, t0.lateEntry3Fecha AS lateEntry3Fecha_47, t0.lateEntry3Permitido AS lateEntry3Permitido_48, t0.necesidadesEspecialesFecha AS necesidadesEspecialesFecha_49, t0.tramo0 AS tramo0_50, t0.tramo1 AS tramo1_51, t0.tramo2 AS tramo2_52, t0.tramo3 AS tramo3_53, t0.infoExtra AS infoExtra_54, t0.extraImporte AS extraImporte_55, t0.aclaracionExamen AS aclaracionExamen_56, t0.idtipocertificacion_id AS idtipocertificacion_id_57, t0.creacionusuario_id AS creacionusuario_id_58, t0.modificacionusuario_id AS modificacionusuario_id_59, t0.convocatoriapoblacion_id AS convocatoriapoblacion_id_60, t0.vistopor_id AS vistopor_id_61 FROM convocatorias t0 WHERE t0.id = 21441;

SELECT
  c0_.poblacion AS poblacion_0
FROM
  convocatorias c0_
WHERE
  c0_.poblacion IS NOT NULL
  AND c0_.eliminado = 0
  AND c0_.examdate >= '2025-12-06 00:00:00'
GROUP BY
  c0_.poblacion
ORDER BY
  c0_.poblacion ASC

SELECT c0_.poblacion AS poblacion_0 FROM convocatorias c0_ WHERE c0_.poblacion IS NOT NULL AND c0_.eliminado = 0 AND c0_.examdate >= '2025-12-06 00:00:00' GROUP BY c0_.poblacion ORDER BY c0_.poblacion ASC;