Mihir | #2031 | adding left join on address and handling null address cases