select max (to_number(substr(NOT_ID_NOTICIA,4,10))) as maximo from FAR_NOTICIAS, GLO_PLANTILLAS_COL where not_pclave_publicacion = 'FARPANAAAAAAAAAAAA' AND NOT_BORRADO = 'N' AND NOT_PLANTILLA = PLAN_ID AND PLAN_NIVEL_1 = 'FAR' AND PLAN_TYPE = 'N' AND NOT_TIPO='N' AND PLAN_ACTIVA = 1