Add lock reasons to Data Explorer

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/263921/add-lock-reasons-to-data-explorer

Physical Fitness Meta

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

select  
       pnt.name
     , 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
-- exclude posts that are no longer locked
left outer join posthistory phu on phu.postid = pn.postid 
                          and phu.posthistorytypeid = 15 -- unlock
                          and phu.id > phl.id -- later
where pnt.classid <> 2 -- bounty
and phl.posthistorytypeid = 14 -- locked
and phu.id is null

select *
from postnoticetypes

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results