Posts which were locked, unlocked and locked again

1

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT
  ph1.PostId AS [Post Link],
  'site://posts/' + CAST(ph1.PostId AS varchar)+'/revisions' AS [Revision History], 
  ph1.CreationDate, ph2.CreationDate, ph3.CreationDate
FROM PostHistory ph1 INNER JOIN PostHistory ph2 ON ph1.PostId=ph2.PostId
  INNER JOIN PostHistory ph3 ON ph1.PostId=ph3.PostId
WHERE (ph1.PostHistoryTypeId=14) AND (ph2.PostHistoryTypeId=15) AND (ph3.PostHistoryTypeId=14) 
AND (ph1.CreationDate<ph2.CreationDate) and (ph2.CreationDate<ph3.CreationDate)
ORDER BY ph1.PostId DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results