Had to put this comment here... MySQL does not support delete or update operations on collections which are used in subqueries of `FROM` statement. It will throw an error.