Protected questions by tag


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 as [Post Link], pq.creationdate as [Protection date]
from posthistory as pq
inner join posts on pq.postid =
inner join posttags on posttags.postid =
inner join tags on posttags.tagid =
left outer join posthistory as uq
  on uq.postid =
  and uq.posthistorytypeid = 20
  and uq.creationdate > pq.creationdate
where pq.posthistorytypeid = 19
  and uq.posthistorytypeid is null
  and tags.tagname = ##TagName:string##
order by pq.creationdate desc

Enter Parameters

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