Fixed that join queries ignore SoftDeleteXXX features