Q&A about the site for WordPress developers and administrators
select top 100 Id as [Post Link] , datediff(ms, creationdate, closeddate) [milli seconds] , creationdate , closeddate , deletiondate from postswithdeleted where closeddate is not null and posttypeid = 1 and datediff(s, creationdate, closeddate) < 120 order by 1