SELECT job.JobReferenceUrl
FROM JobsView.Pinpoint.Urls.History.ALL u
LEFT INNER JOIN@20 (SELECT j.UrlKey, j.JobReferenceUrl, j.JobDescription
                    FROM JobsView.Pinpoint.JobPostings j
                    WHERE j.JobExportStatus = 'DELETE') AS job
ON u.UrlKey = job.UrlKey
WHERE u.StatusDistill = 'DISTILL_EXPIRED_DELTA'