MySQL does not allow referring to a table in a subquery which is the target for a delete/update.

For example

This is not allowed, but in SQL, we can use double nesting to workaround this limitation