Salir
Edición de Consulta
Eliminar consulta
Eliminar
Nombre
*
Código
*
Valor
*
Select pay.id as payment_id, pay.user_id, u.name, u.last_name, u.email, pay.amount, pay.concept, pay.created_at, seg.name as segment_name, con.altan_service_id, con.bundle_id, bun.name as bundle_name, sc.iccid, sc.msisdn, sc.id as sim_card_id, sc.sim_card_type FROM public.payments as pay inner join public.altan_service_bundle_orders as con on con.id = pay.payable_id inner join public.segments as seg on pay.segment_id = seg.id inner join public.bundles as bun on bun.id = con.bundle_id inner join public.sim_cards as sc on sc.altan_service_id = con.altan_service_id inner join public.users as u on pay.user_id = u.id where pay.payable_type = 'AltanServiceBundleOrder' and pay.status = '1' and pay.payment_method = 11 and pay.created_at >= date(now()) - interval '3' month
Guardar
Cancelar