title: Query to order on different tables doesn't work
body: <p>I have some entities/tables:</p>
  <p>-Content
  -ContentCategory
  -Editor who can be premium and who create Contents
  -Star (gold contents)like that: Star(IdContent, IdCategoryContent, IdEditor), because there can be only one star for each category for each editor.</p>
  <p>I want a query to get every Contents but ordered to shows  only one content from each editor at first (star content of premium plan editors) and then every other contents.</p>
  <p>What I tried, thanks for any help :</p>
  <pre><code>$query = $this-&gt;getEntityManager()-&gt;createQueryBuilder()
      -&gt;select('c')
      -&gt;from('ContentBundle:Content', 'c')
      -&gt;leftJoin('c.user', 'user')
      -&gt;leftJoin('user.editoreditor', 'editor')
      -&gt;leftJoin(
          'loic\ContentBundle\Entity\Star',
          'star',
          \Doctrine\ORM\Query\Expr\Join::WITH,
          'c.idcontent = star.idContent'
      )
      -&gt;orderBy('editor.plan', 'DESC')
      -&gt;addOrderBy('star.idContent', 'DESC')
      -&gt;addOrderBy('c.creationDate', 'DESC');
  </code></pre>