title: How to combine two SQL queries with different ORDER BY clauses
body: <p>I looked online, but I could only find two queries combined with the <strong>same</strong> <code>order by</code>. </p>
  
  <p>First query:</p>
  
  <pre><code>SELECT
    Name
    , Priority
  FROM Music
  WHERE `Priority` &gt; 0 AND `date` &gt; '2014-10-27 20:04:25'
  ORDER BY `Priority` DESC
  </code></pre>
  
  <p>Second query:</p>
  
  <pre><code>SELECT
    Name
    , Priority
  FROM Music
  WHERE `Priority` = 0 AND `date` &gt; '2014-10-27 20:04:25'
  ORDER BY `date`
  </code></pre>
  
  <p>I need to combine the first and the second query into one, where the first query is executed and then the second query is executed giving me a complete list.</p>