title: SQL, Order By - How to give more authority to other columns?
body: <p>I have this SQL statement:</p>
  
  <pre><code>SELECT * FROM converts 
  WHERE email='myemail@googlemail.com' AND status!='1' 
  ORDER BY date ASC, priority DESC
  </code></pre>
  
  <p>This just orders by date but I want to give my column "priority" more authority. How can I do this? </p>
  
  <p>It should order by date first but if the time between two records is 10 mintues then I want priority to take over. How can I do this in my SQL statement or does this have to be in my application logic? I was hoping I could do it in my SQL statement.</p>
  
  <p>Thank you all for any help</p>