How To Translate Mysql Query To Sequelize Orm

I need to perform this multiple LEFT JOIN query with sequelize: SELECT movie, genre FROM `yt_movies` M LEFT JOIN `genres_link` GL ON M.id = GL.movie_id LEFT JOIN `genres` G ON GL.

Solution 1:

To join A->B->C, you should nest the include for C inside the include for B, e.g.

A.findAll({    
    include: [
       {
         model: B,
         include: [
             {model: C}
             ]
         }
     ]
     })

But, if table genres_link has no attributes other than PKs of movie and genre, then use through.

YtMovies.belongsToMany(Genres, {through:GenresLink, foreignKey:'movie_id' });Genres.belongsToMany(YtMovies,{through:GenresLink,foreignKey:'genre_id '});YtMovies.findAll({include: [
          {
           model:Genres, 
           required :true,
           through:GenresLink 
          }
          ]
       });

The manual has some helpful info on this topic...