title: Symfony2 - Query Builder multiple orderBy
body: <p>I have the following code</p>
  
  <pre><code>public function queryAssociationsSorted($id){
      $qb = $this-&gt;createQueryBuilder('a')
              -&gt;leftJoin('a.category', 'c')
              -&gt;where('a.job = :id')
              -&gt;setParameter('id', $id)
              //-&gt;addOrderBy('c.rank', 'DESC')
              //-&gt;addOrderBy('a.updated', 'DESC')    
              -&gt;add('orderBy','c.rank DESC THEN a.updated DESC')       
              ;
  
      return $query = $qb-&gt;getQuery();
  }
  </code></pre>
  
  <p>and this or the commented out options both only sort by a.updated. I have looked at other posts on this subject and can't find a solution. Can anyone suggest where I am going wrong?</p>