title: ORDER BY on multiple conditions
body: <p>I need a query that will give me the result that is either (a) the highest price or (b) the one with the oldest timestamp.  In all cases, price should trump timestamp (ie if a record has a really old timestamp by higher price than all others, it should always return the record with the highest price)</p>
  
  <p>Here are a few scenarios:</p>
  
  <pre><code>id | price | date
  1 | 5 | 2012-02-20 08:59:06
  2 | 5 | 2012-02-20 09:59:06
  3 | 7 | 2012-02-20 10:59:06
  </code></pre>
  
  <p>Should return id 3 because it is highest price</p>
  
  <pre><code>id | price | date
  1 | 5 | 2012-02-20 08:59:06
  2 | 5 | 2012-02-20 09:59:06
  3 | 5 | 2012-02-20 10:59:06
  </code></pre>
  
  <p>should return id 1 since it is the oldest</p>
  
  <p>In my current query i am doing this:</p>
  
  <pre><code>SELECT * FROM table ORDER BY price, date DESC LIMIT 1
  </code></pre>
  
  <p>Unfortunately this query is not working how i've outlined it above.</p>
  
  <p>Thanks for your help</p>