title: Mysql order a table based on two criterias
body: <p>I have a problem on how to order a table based on two criterias. i have in my table games with their start and end time. so i want to show at the top games that will start soon. that's easy we can just do order by time asc. but i want when a game is ended to go to the bottom.
  simple schema :</p>
  
  <ol>
  <li>game1 start_at 10:00 ended at 12:00</li>
  <li>game2 start_at 14:00 ended at 16:00</li>
  <li>game3 start_at 20:00 ended at 22:00</li>
  </ol>
  
  <p>so if it's 16:00 now. the result of the query display</p>
  
  <ol>
  <li>game1</li>
  <li>game2</li>
  <li>game3</li>
  </ol>
  
  <p>i don't want that because game1 is ended at 12:00 it's 16:00 at time now.
  i want the result to be like this if its 16:00 now</p>
  
  <ol>
  <li>game2</li>
  <li>game3</li>
  <li>game1</li>
  </ol>