Add lock reasons to Data Explorer


Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

     , phl.creationdate
     , pn.postid as [Post Link]
from postnotices pn
inner join postnoticetypes pnt on = pn.postnoticetypeid
inner join posthistory phl on phl.postid = pn.postid
-- exclude posts that are no longer locked
left outer join posthistory phu on phu.postid = pn.postid 
                          and phu.posthistorytypeid = 15 -- unlock
                          and > -- later
where pnt.classid <> 2 -- bounty
and phl.posthistorytypeid = 14 -- locked
and is null

select *
from postnoticetypes

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results