select a.numero_linea
from numeros_portados_detalle_ptb a
where a.id_asignatario_original = '555'
and a.id_receptor = '555'
and a.fecha_ventana_programada >= '2019-01-20 00:00:00.0'
and a.fecha_ventana_programada <  '2019-01-21 00:00:00.0';

select b.numero_linea from identificadores a, numeros_portados_ptb b, routing_numbers_ptb c
where a.identificador = b.numero_linea
and b.routing_number = c.routing_number
and b.fecha_evento >= '2019-01-20 00:00:00.0'
and b.fecha_evento <  '2019-01-21 00:00:00.0'
and c.owner = 'Personal'
and a.codigo_estado_comercial != 'PORTA'
order by a.identificador