title: How to set multiple "order by"?
body: <p>I'm about to make a subscriptions list to my website, but I can't find a solution for multiple "order by" in my query, that actually works.</p>
  
  <p>My current code is:</p>
  
  <pre><code> select name from data_subscriptions 
   where authVal="1" 
   order by id desc, name asc limit 100
  </code></pre>
  
  <p>But I only order by id desc, and not the name asc.</p>
  
  <p>Database:</p>
  
  <pre><code>[1] ( id=1, authVal=1, name=Alex )
  [2] ( id=2, authVal=1, name=Jens )
  </code></pre>
  
  <p>It shows Jens, and then Alex - What do I do wrong?</p>