Locked questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT DISTINCT PostHistory.PostId AS [Post Link] 
FROM PostHistory
   LEFT JOIN (SELECT DISTINCT PostId, CreationDate 
               FROM PostHistory 
               WHERE PostHistoryTypeId = 15) AS Unlocked
   ON PostHistory.PostId = Unlocked.PostId 
     AND PostHistory.CreationDate < Unlocked.CreationDate
   WHERE PostHistory.PostHistoryTypeId = 14
     AND Unlocked.PostId IS NULL

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results