title: SQL update with sub request
body: <p>i have some trouble with sql request</p>
  <pre><code>    UPDATE tvi SET tvi.template_item_configuration_id = (
      SELECT id FROM template_item_configuration tic WHERE tic.template_id = t.id AND tic.`position` = tvi.`position` 
  )
  FROM template_version_item tvi
  LEFT JOIN template_version tv ON tvi.template_version_id = tv.id
  LEFT JOIN template t ON t.id = tv.template_id
  </code></pre>
  <p>Can you help me to find the fix ? Here is the error message :
  SQL Error [1064] [42000]: (conn=103) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM template_version_item tvi</p>