Sequelize查询以下SQL：(Sequelize query for the following SQL:)

 我有一个SQL查询，我想写为Sequelize查询。 
 
SELECT users.username, players.points, tournaments.date
FROM USERS
JOIN players ON users.id = players.UserId
JOIN Tournaments ON tournaments.id = players.TournamentId
WHERE players.player_checkedin_flag = 1 AND users.role = "user";
 
 我在玩家表中有以下关联： 
 
classMethods: {
    associate: function(models) {
      // Foreign key to user_id
      Player.belongsTo(models.User, {
        foreignKey: {
          allowNull: false
        }
      });
      // Foreign key to tournament_id
      Player.belongsTo(models.Tournament, {
        foreignKey: {
          allowNull: false
        }
      });
 
 在Users表中， 
 
{
  classMethods: {
    associate: function(models) {
      // User has many Player data
      User.hasMany(models.Player);
    }
  }
}
 
 在锦标赛表中： 
 
{
  classMethods: {
    associate: function(models) {
      // Tournament is connected to many player rows
      Tournament.hasMany(models.Player);
    }
  }
}
 
 对应的sequelize查询是什么？ 

I have a SQL query that I want to write as a Sequelize query.
 
SELECT users.username, players.points, tournaments.date
FROM USERS
JOIN players ON users.id = players.UserId
JOIN Tournaments ON tournaments.id = players.TournamentId
WHERE players.player_checkedin_flag = 1 AND users.role = "user";
 
I have the following association in Players table:
 
classMethods: {
    associate: function(models) {
      // Foreign key to user_id
      Player.belongsTo(models.User, {
        foreignKey: {
          allowNull: false
        }
      });
      // Foreign key to tournament_id
      Player.belongsTo(models.Tournament, {
        foreignKey: {
          allowNull: false
        }
      });
 
In Users table, 
 
{
  classMethods: {
    associate: function(models) {
      // User has many Player data
      User.hasMany(models.Player);
    }
  }
}
 
And in Tournaments table: 
 
{
  classMethods: {
    associate: function(models) {
      // Tournament is connected to many player rows
      Tournament.hasMany(models.Player);
    }
  }
}
 
What is the corresponding sequelize query for it?

原文：https://stackoverflow.com/questions/43126729