Salir
Edición de Consulta
Eliminar consulta
Eliminar
Nombre
*
Código
*
Valor
*
Select s.id as altan_service_id, sc.segment_id, seg.name as segment_name, sc.iccid, sc.msisdn, u.name, u.last_name, u.email, s.altan_expires_at from public.altan_services as s inner join public.sim_cards as sc on s.id = sc.altan_service_id inner join public.segments as seg on sc.segment_id = seg.id inner join public.users as u on s.user_id = u.id where date(altan_expires_at) = date(now()) - interval '3' month and sc.segment_id in (2,7,9)
Guardar
Cancelar