title: Use JOIN in Sequelize
body: <p>prompt how to use JOIN in Sequelize ?
  I have the following code:</p>
  
  <pre><code>        db.User.findAll({
          attributes: ['id'],
          where: {vipEnd: {lt: expiresVip}, vip: true},
          limit: 100,
          order: 'id'
      }).then(function(users) {
  </code></pre>
  
  <p>In terms of 4, it looks like this:</p>
  
  <pre><code>SELECT "vkId" AS "id" 
  FROM "user" AS "user" 
  WHERE "user"."vipEnd" &lt; 1469699683 --expiresVip
  AND "user"."vip" = true 
  ORDER BY id 
  LIMIT '100';
  </code></pre>
  
  <p>How to achieve such a result? </p>
  
  <pre><code>SELECT "vkId" AS "id" 
  FROM "user" AS "user" 
  
  LEFT JOIN "notification" ON "notification"."userId" = "user"."vkId"
  
  WHERE "user"."vipEnd" &lt; 1469699683
  AND "user"."vip" = true 
  
  AND "notification"."type" = 4
  AND "notification"."expiresVipDate" &lt; 1469699683
  
  ORDER BY id 
  LIMIT '100';
  </code></pre>
  
  <p>Thank you!</p>