Currently Historically Locked Posts


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

  CONCAT('site://q/', pn.PostId, '|', CASE 
    WHEN pwd.DeletionDate IS NULL 
    THEN pwd.Title
    ELSE '[deleted]' 
    END) AS [Link],
  pwd.ViewCount AS [Views],
  pwd.CreationDate AS [Post Date],
  pn.CreationDate AS [Lock Date (Most Recent)]
FROM PostNotices pn
JOIN PostsWithDeleted pwd ON pwd.Id = pn.PostId
WHERE pn.PostNoticeTypeId = 22 -- Id for Historical Locks
  AND pn.DeletionDate IS NULL
ORDER BY pwd.CreationDate

Enter Parameters

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