title: cakephp 3 sort by deeply associated table
body: <p>We are not able to sort our data by deeply associated data</p>
  
  <p>Even though the tables are defined with belongsTo and hasOne associations type CakePHP use subqueries on the deep levels to get the data and the fields we need to order are not present in the main query</p>
  
  <p>Example:</p>
  
  <p>Users.Articles.Posts</p>
  
  <p>If i try to order by Articles.id it works fine because Articles is present as an INNER JOIN in the query</p>
  
  <p>But by ordering with Users.Articles.Posts.id it doesn't work because the Posts are being retrieved using a separate query</p>
  
  <p>Is there any other way to force CakePHP to retrieve all the data in a single query?</p>