title: Sequelize - Limiting and ordering inside include
body: <p>I have associated 3 tables in Sequelize.
  <a href="https://i.stack.imgur.com/4EDFW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4EDFW.png" alt="enter image description here"></a>
  Using findOne am trying to retrieve one room with all messages limited to 10 and with order by message_timestamp but to no avail. </p>
  
  <pre><code>models.Room.findOne({
  where: {
    room_id: room_id
  },
  include: [ {
    model: models.Message,
    limit: 10,
    offset: 0,
    order: 'message_timestamp DESC'
  } ] })
  </code></pre>
  
  <p>The above code retrieves all the messages (not limited to 10) and are not ordered according to message_timestamp.</p>
  
  <p>Is there a solution? How can I go about doing this?</p>
  
  <p>Thank You.</p>