Calculo depuntos

points.sql

select distinct points.user_id as user_id, points.total-redeem.total as total
from (
	select tickets.id_cliente as user_id, sum(tickets.puntos_obtenidos) as total
	from tickets where aprobado=1 and  cancelado=0 group by tickets.id_cliente
) points
left join (
	select articulos_recibidos.id_cliente as user_id, sum(articulos_recibidos.puntos) as total 
	from articulos_recibidos group by articulos_recibidos.id_cliente
) redeem on redeem.user_id=points.user_id
order by user_id asc;