fix(deep): prevent false unique constraint errors and combine delete queries

fix(deep): prevent false unique constraint errors and combine delete queries #4143