title: MySQL LEFT JOIN AND ORDER BY ERROR?
body: <p>I'm working on some code and I came across some problems.</p>
  
  <p>I have 2 tables "Table1" and "Table2" and I wanna combine both of them (<code>LEFT JOIN</code>). When I do everything works fine. But when I add <code>ORDER BY</code> at the end my website stops working for a few minutes.</p>
  
  <p>The code:</p>
  
  <pre><code>SELECT table1.id, table2.id 
  FROM table1 
      LEFT JOIN table2 ON table1.id=table2.id 
  ORDER BY table1.name 
  LIMIT 0, 20 
  </code></pre>
  
  <p>for some reason this code crashes the server.
  any help would be appreciated!</p>