title: Syntax error possibly due to multiple ANDs?
body: <pre><code>UPDATE bookings b
  SET reservation_processed = 'archived'
    JOIN reservation_time_data r ON r.id = b.reservation_time
  WHERE premises_code = 'LJJIDHhRN2ho1e3h'
   AND reservation_date LIKE '%2020-09-10%'
   AND CURRENT_TIME &gt; ADDTIME(r.end_time, '0:30:0.000000')
  </code></pre>
  <p>I first got the error in php, and I then tested it in phpmyadmin and I get an error. It doesn't specify why there is an error it just saying an error with the syntax. I thought it maybe because there is multiple AND clauses but I put them in brackets to maybe simplify it but it didn't help :( Anyone any ideas?</p>