title: Multiple-table DELETE LIMIT
body: <p>I'm trying to run following query but it throws an error.</p>
  
  <pre><code>DELETE b 
  FROM parim_lang a 
  JOIN parim_lang b 
      ON b.lang_hash = a.lang_hash 
      AND b.lang_language = SUBSTRING(a.lang_google_translation, LOCATE('-', a.lang_google_translation) + 1)
  WHERE a.lang_google_translation REGEXP '^[a-z]+-[a-z]+'
  LIMIT 20
  </code></pre>
  
  <p>Without limit this query works..</p>
  
  <p>Error looks like this:</p>
  
  <blockquote>
    <p>SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 20' at line 7</p>
  </blockquote>
  
  <p>Found this:</p>
  
  <blockquote>
    <p>For the multiple-table syntax, DELETE deletes from each tbl_name the rows that satisfy the conditions. In this case, ORDER BY and LIMIT cannot be used. </p>
  </blockquote>
  
  <p>I there any workarounds for this?</p>