How to find those old gems on SO?


Please login or register to vote for this query.

(click on this box to dismiss) postnotices historical lock

Stack Overflow

Q&A for professional and enthusiast programmers

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

Enter Parameters

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