Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.eliminado AS eliminado_1,
  c0_.codigoexam AS codigoexam_2,
  c0_.aliasprivada AS aliasprivada_3,
  c0_.indcbpb AS indcbpb_4,
  c0_.indpublicada AS indpublicada_5,
  c0_.incidencia AS incidencia_6,
  c0_.fechapublicacion AS fechapublicacion_7,
  c0_.indcerradaabierta AS indcerradaabierta_8,
  c0_.observacion AS observacion_9,
  c0_.indacademia AS indacademia_10,
  c0_.numplazasmaximo AS numplazasmaximo_11,
  c0_.examdate AS examdate_12,
  c0_.fechacierreiml AS fechacierreiml_13,
  c0_.venuedetailsdate AS venuedetailsdate_14,
  c0_.speakingwindowstart AS speakingwindowstart_15,
  c0_.speakingwindowstart2 AS speakingwindowstart2_16,
  c0_.speakingwindowend AS speakingwindowend_17,
  c0_.resultreleasestart AS resultreleasestart_18,
  c0_.resultreleaseend AS resultreleaseend_19,
  c0_.certificatedispatch AS certificatedispatch_20,
  c0_.color AS color_21,
  c0_.logo AS logo_22,
  c0_.creacionfecha AS creacionfecha_23,
  c0_.modificacionfecha AS modificacionfecha_24,
  c0_.serializado AS serializado_25,
  c0_.numsupervisores AS numsupervisores_26,
  c0_.numvigilantes AS numvigilantes_27,
  c0_.fechaultimoavisoexternos AS fechaultimoavisoexternos_28,
  c0_.numhorasprevistas AS numhorasprevistas_29,
  c0_.entryclosingdate AS entryclosingdate_30,
  c0_.precio AS precio_31,
  c0_.poblacion AS poblacion_32,
  c0_.visto AS visto_33,
  c0_.matriculadosespeciales AS matriculadosespeciales_34,
  c0_.maximosCandidatos AS maximosCandidatos_35,
  c0_.lateEntry1Importe AS lateEntry1Importe_36,
  c0_.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_37,
  c0_.lateEntry1Fecha AS lateEntry1Fecha_38,
  c0_.lateEntry1Permitido AS lateEntry1Permitido_39,
  c0_.lateEntry2Importe AS lateEntry2Importe_40,
  c0_.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_41,
  c0_.lateEntry2Fecha AS lateEntry2Fecha_42,
  c0_.lateEntry2Permitido AS lateEntry2Permitido_43,
  c0_.lateEntry3Importe AS lateEntry3Importe_44,
  c0_.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_45,
  c0_.lateEntry3Fecha AS lateEntry3Fecha_46,
  c0_.lateEntry3Permitido AS lateEntry3Permitido_47,
  c0_.necesidadesEspecialesFecha AS necesidadesEspecialesFecha_48,
  c0_.tramo0 AS tramo0_49,
  c0_.tramo1 AS tramo1_50,
  c0_.tramo2 AS tramo2_51,
  c0_.tramo3 AS tramo3_52,
  c0_.infoExtra AS infoExtra_53,
  c0_.extraImporte AS extraImporte_54,
  c0_.aclaracionExamen AS aclaracionExamen_55,
  c0_.idtipocertificacion_id AS idtipocertificacion_id_56,
  c0_.creacionusuario_id AS creacionusuario_id_57,
  c0_.modificacionusuario_id AS modificacionusuario_id_58,
  c0_.convocatoriapoblacion_id AS convocatoriapoblacion_id_59,
  c0_.vistopor_id AS vistopor_id_60
FROM
  convocatorias c0_
WHERE
  c0_.indcerradaabierta = 1
  AND c0_.fechacierreiml >= ?
ORDER BY
  c0_.fechacierreiml ASC

SELECT c0_.id AS id_0, c0_.eliminado AS eliminado_1, c0_.codigoexam AS codigoexam_2, c0_.aliasprivada AS aliasprivada_3, c0_.indcbpb AS indcbpb_4, c0_.indpublicada AS indpublicada_5, c0_.incidencia AS incidencia_6, c0_.fechapublicacion AS fechapublicacion_7, c0_.indcerradaabierta AS indcerradaabierta_8, c0_.observacion AS observacion_9, c0_.indacademia AS indacademia_10, c0_.numplazasmaximo AS numplazasmaximo_11, c0_.examdate AS examdate_12, c0_.fechacierreiml AS fechacierreiml_13, c0_.venuedetailsdate AS venuedetailsdate_14, c0_.speakingwindowstart AS speakingwindowstart_15, c0_.speakingwindowstart2 AS speakingwindowstart2_16, c0_.speakingwindowend AS speakingwindowend_17, c0_.resultreleasestart AS resultreleasestart_18, c0_.resultreleaseend AS resultreleaseend_19, c0_.certificatedispatch AS certificatedispatch_20, c0_.color AS color_21, c0_.logo AS logo_22, c0_.creacionfecha AS creacionfecha_23, c0_.modificacionfecha AS modificacionfecha_24, c0_.serializado AS serializado_25, c0_.numsupervisores AS numsupervisores_26, c0_.numvigilantes AS numvigilantes_27, c0_.fechaultimoavisoexternos AS fechaultimoavisoexternos_28, c0_.numhorasprevistas AS numhorasprevistas_29, c0_.entryclosingdate AS entryclosingdate_30, c0_.precio AS precio_31, c0_.poblacion AS poblacion_32, c0_.visto AS visto_33, c0_.matriculadosespeciales AS matriculadosespeciales_34, c0_.maximosCandidatos AS maximosCandidatos_35, c0_.lateEntry1Importe AS lateEntry1Importe_36, c0_.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_37, c0_.lateEntry1Fecha AS lateEntry1Fecha_38, c0_.lateEntry1Permitido AS lateEntry1Permitido_39, c0_.lateEntry2Importe AS lateEntry2Importe_40, c0_.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_41, c0_.lateEntry2Fecha AS lateEntry2Fecha_42, c0_.lateEntry2Permitido AS lateEntry2Permitido_43, c0_.lateEntry3Importe AS lateEntry3Importe_44, c0_.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_45, c0_.lateEntry3Fecha AS lateEntry3Fecha_46, c0_.lateEntry3Permitido AS lateEntry3Permitido_47, c0_.necesidadesEspecialesFecha AS necesidadesEspecialesFecha_48, c0_.tramo0 AS tramo0_49, c0_.tramo1 AS tramo1_50, c0_.tramo2 AS tramo2_51, c0_.tramo3 AS tramo3_52, c0_.infoExtra AS infoExtra_53, c0_.extraImporte AS extraImporte_54, c0_.aclaracionExamen AS aclaracionExamen_55, c0_.idtipocertificacion_id AS idtipocertificacion_id_56, c0_.creacionusuario_id AS creacionusuario_id_57, c0_.modificacionusuario_id AS modificacionusuario_id_58, c0_.convocatoriapoblacion_id AS convocatoriapoblacion_id_59, c0_.vistopor_id AS vistopor_id_60 FROM convocatorias c0_ WHERE c0_.indcerradaabierta = 1 AND c0_.fechacierreiml >= '2025-12-06 00:00:00' ORDER BY c0_.fechacierreiml ASC;

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
  t0_.id AS id_0,
  t0_.abreviatura AS abreviatura_1,
  t0_.descripcion AS descripcion_2,
  t0_.idmaterial AS idmaterial_3,
  t0_.cambridgefee AS cambridgefee_4,
  t0_.speakingwindow AS speakingwindow_5,
  t0_.maxslots AS maxslots_6,
  t0_.preciocambridge AS preciocambridge_7,
  t0_.preciocolegio AS preciocolegio_8,
  t0_.preciofomento AS preciofomento_9,
  t0_.preciouco AS preciouco_10,
  t0_.preciouja AS preciouja_11,
  t0_.precioual AS precioual_12,
  t0_.preciocsanfrancisco AS preciocsanfrancisco_13,
  t0_.preciougibraltar AS preciougibraltar_14,
  t0_.preciogranadacollege AS preciogranadacollege_15,
  t0_.precioceuta AS precioceuta_16,
  t0_.creacionfecha AS creacionfecha_17,
  t0_.modificacionfecha AS modificacionfecha_18,
  t0_.logo AS logo_19,
  t0_.duracionprevista AS duracionprevista_20,
  t0_.nombre AS nombre_21,
  t0_.descripcionpublica AS descripcionpublica_22,
  t0_.color AS color_23,
  t0_.candidatenumberstart AS candidatenumberstart_24,
  t0_.duracionreading AS duracionreading_25,
  t0_.duracionwriting AS duracionwriting_26,
  t0_.duracionlistening AS duracionlistening_27,
  t0_.duracionspeaking AS duracionspeaking_28,
  t0_.esspeaking AS esspeaking_29,
  t0_.orden AS orden_30,
  t0_.descripcionexamen AS descripcionexamen_31,
  t0_.slug AS slug_32,
  t0_.lateEntry1Importe AS lateEntry1Importe_33,
  t0_.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_34,
  t0_.lateEntry1Dias AS lateEntry1Dias_35,
  t0_.lateEntry2Importe AS lateEntry2Importe_36,
  t0_.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_37,
  t0_.lateEntry2Dias AS lateEntry2Dias_38,
  t0_.lateEntry3Importe AS lateEntry3Importe_39,
  t0_.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_40,
  t0_.lateEntry3Dias AS lateEntry3Dias_41,
  t0_.dniObligatorio AS dniObligatorio_42,
  t0_.creacionusuario_id AS creacionusuario_id_43,
  t0_.modificacionusuario_id AS modificacionusuario_id_44
FROM
  tipos_certificacion t0_
ORDER BY
  t0_.orden ASC

SELECT t0_.id AS id_0, t0_.abreviatura AS abreviatura_1, t0_.descripcion AS descripcion_2, t0_.idmaterial AS idmaterial_3, t0_.cambridgefee AS cambridgefee_4, t0_.speakingwindow AS speakingwindow_5, t0_.maxslots AS maxslots_6, t0_.preciocambridge AS preciocambridge_7, t0_.preciocolegio AS preciocolegio_8, t0_.preciofomento AS preciofomento_9, t0_.preciouco AS preciouco_10, t0_.preciouja AS preciouja_11, t0_.precioual AS precioual_12, t0_.preciocsanfrancisco AS preciocsanfrancisco_13, t0_.preciougibraltar AS preciougibraltar_14, t0_.preciogranadacollege AS preciogranadacollege_15, t0_.precioceuta AS precioceuta_16, t0_.creacionfecha AS creacionfecha_17, t0_.modificacionfecha AS modificacionfecha_18, t0_.logo AS logo_19, t0_.duracionprevista AS duracionprevista_20, t0_.nombre AS nombre_21, t0_.descripcionpublica AS descripcionpublica_22, t0_.color AS color_23, t0_.candidatenumberstart AS candidatenumberstart_24, t0_.duracionreading AS duracionreading_25, t0_.duracionwriting AS duracionwriting_26, t0_.duracionlistening AS duracionlistening_27, t0_.duracionspeaking AS duracionspeaking_28, t0_.esspeaking AS esspeaking_29, t0_.orden AS orden_30, t0_.descripcionexamen AS descripcionexamen_31, t0_.slug AS slug_32, t0_.lateEntry1Importe AS lateEntry1Importe_33, t0_.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_34, t0_.lateEntry1Dias AS lateEntry1Dias_35, t0_.lateEntry2Importe AS lateEntry2Importe_36, t0_.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_37, t0_.lateEntry2Dias AS lateEntry2Dias_38, t0_.lateEntry3Importe AS lateEntry3Importe_39, t0_.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_40, t0_.lateEntry3Dias AS lateEntry3Dias_41, t0_.dniObligatorio AS dniObligatorio_42, t0_.creacionusuario_id AS creacionusuario_id_43, t0_.modificacionusuario_id AS modificacionusuario_id_44 FROM tipos_certificacion t0_ ORDER BY t0_.orden ASC;

SELECT
  c0_.id AS id_0,
  c0_.poblacion AS poblacion_1,
  c0_.slug AS slug_2,
  c0_.texto AS texto_3,
  c0_.eliminada AS eliminada_4
FROM
  convocatoriapoblacion c0_
WHERE
  c0_.eliminada = 0
ORDER BY
  c0_.poblacion ASC

SELECT c0_.id AS id_0, c0_.poblacion AS poblacion_1, c0_.slug AS slug_2, c0_.texto AS texto_3, c0_.eliminada AS eliminada_4 FROM convocatoriapoblacion c0_ WHERE c0_.eliminada = 0 ORDER BY c0_.poblacion ASC;