Q&A about the site for professional linguists and others with an interest in linguistic research and theory
SELECT pl.PostId AS [Post Link], p.Title, p.Score, p.ViewCount, p.AnswerCount, p.Tags FROM PostLinks pl INNER JOIN Posts p ON p.Id=pl.PostId WHERE (pl.RelatedPostId=##id?30732##) AND (pl.LinkTypeId=3) ---LinkTypeId type of link ---1 = Linked (PostId contains a link to RelatedPostId) ---3 = Duplicate (PostId is a duplicate of RelatedPostId)