Q&A for active researchers, academics and students of physics
SELECT TOP 100 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 FROM Posts p INNER JOIN PostHistory h ON p.Id = h.PostId WHERE ( h.PostHistoryTypeId = 10 ) AND ( h.Text LIKE '{"OriginalQuestionIds":%' )