title: how to make conditional ordering in sqlite?
body: <p>I have table with fields <code>task_priority</code>, <code>task_completed_time</code>,<code>task_completed</code>. Completed colume have values <code>0</code> and <code>1</code> and it is a primary sort. I want to make secondary sort to be <code>priority</code> if <code>completed</code> is <code>0</code> and <code>completed_time</code> if <code>completed</code> is <code>1</code>. How can i get it?  </p>