Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
SELECT TOP 10 p.Id AS Post, p.Title AS Question, p.AcceptedAnswerId AS Answer, SUBSTRING(h.Text, CHARINDEX('[', h.Text), CHARINDEX(']', h.Text) - CHARINDEX('[', h.Text) + 1) AS Duplicate, a.Score FROM Posts p INNER JOIN PostHistory h ON p.Id = h.PostId INNER JOIN Posts a ON p.AcceptedAnswerId = a.Id WHERE ( h.Text LIKE '{"OriginalQuestionIds":%' ) AND ( p.AcceptedAnswerId = NULL )