Unlocked historically locked questions


Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

     , 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

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