Removed soft delete for pivot table. Caused errors in sql statement.