select film.id, film.titulo, film.permalink, film.chaveImagem, sum(rank.pontos) as total
from ranking_filmes rank
right join filmes film
on rank.filme_id = film.id
group by film.id, null, null, null
order by total desc limit 5