title: MySQL LEFT JOIN only one row, ordered by column without subquery
body: <p>Is there a possibility to do LEFT JOIN with only one row from other table ordered by column (date) without using sub query. My query is below. It works but it's  super slow.</p>
  
  <pre><code>SELECT * FROM clients c 
  LEFT JOIN loan l ON c.id = l.id_client AND l.id = (
      SELECT id FROM loan ll
      WHERE ll.id_client = c.id
      ORDER BY `create_date` DESC
      LIMIT 1) 
  GROUP BY k.id DESC 
  ORDER BY c.register_date DESC 
  LIMIT n , m; (n,m is from pagination)
  </code></pre>
  
  <p>Is there a way to speed it up?</p>