Added SubQuery in join to show and exclude deleted