This is more of a SQL provider independent way of doing the deletes
but MySQL’s IN subselect statement performance is less than fantastic.
We need to avoid these like the plague.