title: Sequelize limit include association
body: <p>I have a problem with Sequelize when limiting results and including associated models.</p>
  
  <p>The following produces the correct result, limited by 10 and sorted correctly.</p>
  
  <pre><code>Visit.findAll({
    limit: 10,
    order: 'updatedAt DESC',
  }).success(function(visits) {
    res.jsonp(visits);
  }).failure(function(err) {
    res.jsonp(err);
  })
  </code></pre>
  
  <p>SQL</p>
  
  <pre><code>SELECT * FROM `Visits` ORDER BY updatedAt DESC LIMIT 10;
  </code></pre>
  
  <p>However when I add an association it suddently limits on the subquery instead and thus the ordering never happens because of a limited result set.</p>
  
  <pre><code>Visit.findAll({
    limit: 10,
    order: 'updatedAt DESC',
    include: [
      { model: Account, required: true }
    ]
  }).success(function(visits) {
    res.jsonp(visits);
  }).failure(function(err) {
    res.jsonp(err);
  })
  </code></pre>
  
  <p>SQL</p>
  
  <pre><code>SELECT 
    `Visits`.* 
  FROM 
    (SELECT 
      `Visits`.*, `Account`.`id` AS `Account.id`, `Account`.`email` AS `Account.email`, `Account`.`password` AS `Account.password`, `Account`.`role` AS `Account.role`, `Account`.`active` AS `Account.active`, `Account`.`createdAt` AS `Account.createdAt`, `Account`.`updatedAt` AS `Account.updatedAt`, `Account`.`practice_id` AS `Account.practice_id` 
    FROM 
      `Visits` INNER JOIN `Accounts` AS `Account` ON `Account`.`id` = `visits`.`account_id` LIMIT 10) AS `visits` 
  ORDER BY updatedAt DESC;
  </code></pre>
  
  <p>What I'm was expecting was having the limit on the top query as so:</p>
  
  <pre><code>SELECT 
    ...
  FROM 
    (SELECT ...) AS `Visits`
  ORDER BY `Visits`.updatedAt DESC LIMIT 10
  LIMIT 10;
  </code></pre>