Q&A for Ubuntu users and developers
SELECT pl.PostId AS [Post Link], url = 'site://q/' + CAST(pl.PostId AS varchar), p.Score, p.ViewCount, p.Tags FROM PostLinks pl INNER JOIN PostsWithDeleted p ON p.Id=pl.PostId WHERE (pl.RelatedPostId=##id?30732##) AND (pl.LinkTypeId=3) AND (p.DeletionDate IS NOT NULL) ---LinkTypeId type of link ---1 = Linked (PostId contains a link to RelatedPostId) ---3 = Duplicate (PostId is a duplicate of RelatedPostId)