SELECT * FROM ( select `colegio`.`codigo` AS `codigo`,`colegio`.`ID_COLEGIO` AS `ID_COLEGIO`,`colegio`.`ID_JORNADA` AS `ID_JORNADA`,`colegio`.`ID_CIUDAD` AS `ID_CIUDAD`,`colegio`.`NOMBRE` AS `NOMBRE`,`colegio`.`CALENDARIO` AS `CALENDARIO`,`colegio`.`DIRECCION` AS `DIRECCION`,`colegio`.`localidad` AS `localidad`,`colegio`.`ASOCIACION` AS `ASOCIACION`,`colegio`.`TELEFONOS` AS `TELEFONOS`,`colegio`.`FAX` AS `FAX`,`colegio`.`EMAIL` AS `EMAIL`,`colegio`.`CONTACTO` AS `CONTACTO`,`colegio`.`RECTOR` AS `RECTOR`,`colegio`.`URL` AS `URL`,`colegio`.`TIPO` AS `TIPO`,`colegio`.`EDUCACION` AS `EDUCACION`,`colegio`.`SUSCRIPCION` AS `SUSCRIPCION`,`colegio`.`FECHASUSCRIPCION` AS `FECHASUSCRIPCION`,`colegio`.`VENCESUSCRIPCION` AS `VENCESUSCRIPCION`,`colegio`.`Hosting` AS `Hosting`,`colegio`.`VENCEHOSTING` AS `VENCEHOSTING`,`colegio`.`id_en` AS `id_en`,`colegio`.`hits` AS `hits`,`colegio`.`objetivo` AS `objetivo`,`colegio`.`IMAGEN` AS `IMAGEN`,`colegio`.`ALUMNOS` AS `ALUMNOS`,`colegio`.`ICFES` AS `ICFES`,`colegio`.`ESTRATO` AS `ESTRATO`,`colegio`.`FORMULARIO` AS `FORMULARIO`,`colegio`.`INSCRIPCIONES` AS `INSCRIPCIONES`,`colegio`.`costos` AS `costos`,`colegio`.`NATURALEZA` AS `NATURALEZA`,`colegio`.`CODIGOICFES` AS `CODIGOICFES`,`colegio`.`SUSCRIBIR` AS `SUSCRIBIR`,`colegio`.`VALORAR` AS `VALORAR`,`colegio`.`idiomas` AS `idiomas`,`colegio`.`lema` AS `lema`,`colegio`.`USUARIOHOSTING` AS `USUARIOHOSTING`,`colegio`.`CLAVEHOSTING` AS `CLAVEHOSTING`,`colegio`.`dominio` AS `dominio`,`colegio`.`vencedominio` AS `vencedominio`,`colegio`.`email_admisiones` AS `email_admisiones`,`colegio`.`envio_email` AS `envio_email`,`colegio`.`Nit` AS `Nit`,`colegio`.`razon_social` AS `razon_social`,`colegio`.`vencebansup` AS `vencebansup`,`colegio`.`vencebaninf` AS `vencebaninf`,`colegio`.`venceboton` AS `venceboton`,`colegio`.`direccion_mapa` AS `direccion_mapa`,`colegio`.`acerca` AS `acerca`,`colegio`.`interes` AS `interes`,`colegio`.`secretaria` AS `secretaria`,`colegio`.`codigo_min` AS `codigo_min`,`colegio`.`nombre_min` AS `nombre_min`,`colegio`.`direccion_min` AS `direccion_min`,`colegio`.`telefono_min` AS `telefono_min`,`colegio`.`rector_min` AS `rector_min`,`colegio`.`tipo_establecimiento` AS `tipo_establecimiento`,`colegio`.`sector` AS `sector`,`colegio`.`zona` AS `zona`,`colegio`.`jornadas` AS `jornadas`,`colegio`.`niveles` AS `niveles`,`colegio`.`grados` AS `grados`,`colegio`.`modelos_educativos` AS `modelos_educativos`,`colegio`.`capacidades_excepcionales` AS `capacidades_excepcionales`,`colegio`.`discapacidades` AS `discapacidades`,`colegio`.`idiomas_min` AS `idiomas_min`,`colegio`.`nro_sedes` AS `nro_sedes`,`colegio`.`estado` AS `estado`,`colegio`.`calendario_min` AS `calendario_min`,`colegio`.`email_min` AS `email_min`,`colegio`.`observaciones` AS `observaciones`,`colegio`.`comentarios` AS `comentarios`,`colegio`.`calificacion` AS `calificacion`,`colegio`.`periodo_admisiones` AS `periodo_admisiones`,`colegio`.`vpension` AS `vpension`,`colegio`.`vtransporte` AS `vtransporte`,`colegio`.`vcafeteria` AS `vcafeteria`,`colegio`.`area` AS `area`,`colegio`.`instalaciones` AS `instalaciones`,`colegio`.`biblioteca` AS `biblioteca`,`colegio`.`informatica` AS `informatica`,`colegio`.`laboratorios` AS `laboratorios`,`colegio`.`comedor` AS `comedor`,`colegio`.`servicios` AS `servicios`,`colegio`.`activ_artisticas` AS `activ_artisticas`,`colegio`.`activ_deportivas` AS `activ_deportivas`,`colegio`.`Facebook` AS `Facebook`,`colegio`.`Twitter` AS `Twitter`,`colegio`.`YouTube` AS `YouTube`,`colegio`.`Google` AS `Google`,`colegio`.`instagram` AS `instagram`,`colegio`.`costos_filtro` AS `costos_filtro`,`colegio`.`costos_filtro_desde` AS `costos_filtro_desde`,`colegio`.`costos_filtro_hasta` AS `costos_filtro_hasta`,`colegio`.`religion` AS `religion`,`colegio`.`tipo_bachillerato` AS `tipo_bachillerato`,`colegio`.`recibe_hasta` AS `recibe_hasta`,`colegio`.`contacto_admisiones` AS `contacto_admisiones`,`colegio`.`barrio` AS `barrio`,`colegio`.`video1` AS `video1`,`colegio`.`video2` AS `video2`,`ciudad`.`ID_CIUDAD` AS `codigo_municipio`,`ciudad`.`NOMBRE` AS `municipio`,`ciudad`.`codigo_dpto` AS `codigo_dpto`,`ciudad`.`dpto` AS `dpto`,`tipo`.`nombre` AS `nombretipo`,`jornada`.`NOMBRE` AS `nombrejornada`,`barrios`.`barrio` AS `nombarrio`,`barrios`.`localidad` AS `nomlocalidad`,`colegio`.`latitudlongitud` AS `latitudlongitud`,`colegio`.`keywords` AS `keywords`,`colegio`.`ciudad_filtro` AS `ciudad_filtro`,`colegio`.`ultima_actualizacion` AS `ultima_actualizacion`,`colegio`.`foto1` AS `foto1`,`colegio`.`foto2` AS `foto2`,`colegio`.`whatsapp` AS `whatsapp`,`colegio`.`proceso_admisiones` AS `proceso_admisiones`,colegio.urlcolegios as urlcolegios,`codigo_dane`, `genero`, `correo_rector`, `CELULAR`, `CELULAR_ADMISIONES`, `CONTACTO_TESORERIA`, `EMAIL_TESORERIA`, `TELEFONO_TESORERIA`, `bono`, `instalaciones_otro`, `certificacion_1`, `fecha_certificacion_1`, `adjunto_certificacion_1`, `certificacion_2`, `fecha_certificacion_2`, `adjunto_certificacion_2`, `certificacion_3`, `fecha_certificacion_3`, `adjunto_certificacion_3`, `TikTok`, `LinkedIn`, `WhatsAppDigital`, `fotos_secundarias`, `actualizado_por_nombre`, `actualizado_por_cargo`, `actualizado_por_email`, `actualizado_por_whatsapp`, `fecha_actualizacion_datos` ,colegio.slug as slug from ((((`colegio` left outer join `ciudad` on((`ciudad`.`ID_CIUDAD` = `colegio`.`ID_CIUDAD`))) left outer join `jornada` on((`colegio`.`ID_JORNADA` = `jornada`.`ID_JORNADA`))) left outer join `tipo` on((`tipo`.`tipo` = `colegio`.`TIPO`))) left outer join `barrios` on((`barrios`.`codigo` = `colegio`.`barrio`))) ) as colegiov  WHERE estado is not null AND codigo_municipio IN (73275) AND id_en = '1' ORDER BY CASE WHEN (UPPER(REPLACE(TRIM(SUSCRIPCION), 'Í', 'I')) IN ('SI','YES')
                              AND VENCESUSCRIPCION IS NOT NULL
                              AND VENCESUSCRIPCION <> ''
                              AND VENCESUSCRIPCION <> '0000-00-00'
                              AND DATE(VENCESUSCRIPCION) >= CURDATE()) THEN 0 ELSE 1 END ASC,
                     CASE WHEN (UPPER(REPLACE(TRIM(SUSCRIPCION), 'Í', 'I')) IN ('SI','YES')
                              AND VENCESUSCRIPCION IS NOT NULL
                              AND VENCESUSCRIPCION <> ''
                              AND VENCESUSCRIPCION <> '0000-00-00'
                              AND DATE(VENCESUSCRIPCION) >= CURDATE()) THEN DATE(VENCESUSCRIPCION) ELSE '0000-00-00' END DESC,
                     RAND(CRC32(CONCAT(CURDATE(), ID_COLEGIO))),
                     NOMBRE ASC LIMIT 12, 12