ranking query improved

fixed sequelize needed: https://github.com/mekanics/sequelize/tree/fix-left-join-attributes