title: How to group by field then order by different field then limit
body: <p>I have a query like:</p>
  
  <pre><code>SELECT _threads.*, _messages.*
  FROM _threads
  LEFT JOIN _messages
  ON _threads.thread_id = _messages.message_thread_id
  WHERE _threads.thread_servicer_id = 'jG5s2b6TRs'
  GROUP BY _threads.thread_customer_id
  </code></pre>
  
  <p>Which returns something like:
  <img src="https://i.stack.imgur.com/dgx1B.png" alt="enter image description here"></p>
  
  <p>How can i modify the query to be able to group by <code>thread_customer_id</code> THEN order by <code>message_time</code> and only pick the row with the latest <code>message_time</code>.</p>