Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select rank.filme_id, film.titulo, film.permalink, film.chaveImagem, sum(rank.pontos) as total
- from filmes film
- left join ranking_filmes rank
- on rank.filme_id = film.id
- group by rank.filme_id, film.titulo, film.permalink, film.chaveImagem
- order by total desc limit 5
Add Comment
Please, Sign In to add comment