title: Multiple order by data in mysql doesn't show right
body: <p>i have been order by data with multiple field, i don't know is it possible or not. here is my <a href="http://sqlfiddle.com/#!9/723a6/4" rel="nofollow">demo</a> please guide me how to code get the results</p>
  
  <pre><code>SELECT product_date, TIME_FORMAT(`product_time`,'%H:%i') as time  ,product_akurat, product_tidak_akurat
  FROM `li_product_post` 
  order by product_date desc, time desc, product_akurat desc, product_tidak_akurat asc
  </code></pre>
  
  <p>i have been trying many times how can i get data by order by</p>
  
  <ol>
  <li>New data inserted by date and time</li>
  <li>Data with big number in field product_akurat</li>
  <li>Data with big number in field product_tidak_akurat</li>
  </ol>
  
  <p>all i want is data came with this</p>
  
  <pre><code>november, 01 2015  | 10:41  |   1          0  
  november, 01 2015  | 11:27  |   1          1  
  november, 10 2015  | 10:39  |   0          1
  
  november, 14 2015  | 17:16  |   0          6
  </code></pre>
  
  <p>want to order by date and time desc but in other hand i want to put values with highest product_akurat in the first rows then put in the bottom which is product has highest product_tidak_akurat</p>