title: MYSQL DATE function running insanely slow in LEFT JOIN
body: <p>When adding the line:</p>
  
  <pre><code>LEFT JOIN core_records_sales as sales ON DATE(appointments.date) = DATE(sales.date_sold)
  </code></pre>
  
  <p>To my query, it boosts the time for the script to run from about 8 seconds, to 2-3 minutes.</p>
  
  <p>Would there be some data causing this problem or am I not implementing the function correctly?</p>
  
  <p>I need to use DATE() because I need them to be the same day but the date fields are DATETIME</p>