Unlocked historically locked questions

0

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  
       pnt.name
     , pnt.id
     , phl.creationdate
     , pn.postid as [Post Link]
from postnotices pn
inner join postnoticetypes pnt on pnt.id = pn.postnoticetypeid
inner join posthistory phl on phl.postid = pn.postid
where pnt.classid <> 2 -- bounty
and phl.posthistorytypeid = 15 -- unlocked
and pnt.id = 22 -- historical lock

Enter Parameters

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