How to find those old gems on SO?

2

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/questions/408959 postnotices historical lock

Stack Overflow

Q&A for professional and enthusiast programmers

select distinct
       concat(
         'site://q/'
       , postid
       , '|'
       , case 
         when p.deletiondate is not null 
         then concat('deleted (tags:', tags, ')') 
         else title
         end
      ) [Locked Link]
      , p.creationdate
      , p.score
      , p.answercount
      , p.deletiondate
from postnotices pn
inner join postswithdeleted p on p.id = pn.postid 
where postnoticetypeid = 22 -- hist lock

Enter Parameters

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