Salir
Edición de Consulta
Eliminar consulta
Eliminar
Nombre
*
Código
*
Valor
*
Select s.id, s.user_id, s.altan_expires_at, s.service_status, u.name, u.last_name, u.email, sc.iccid, sc.msisdn from public.altan_services as s inner join public.sim_cards as sc on s.id = sc.altan_service_id inner join public.users as u on u.id = s.user_id where user_id in (select user_id from public.altan_services group by user_id having count(*) > 1) and date(s.altan_expires_at) < date(now()) order by user_id
Guardar
Cancelar