Can the asked question ever get undeleted by a moderator?

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/questions/401016

Stack Overflow

Q&A for professional and enthusiast programmers

-- moduserid : the id of the moderator
-- since : start date of the events
select distinct 
       p.id as [Post Link]
     , concat('site://posts/', p.id, '/timeline|timeline') [timeline] 
     , ph.creationdate [undeleted on]
from posts p
inner join posthistory ph on ph.postid = p.id
where ph.posthistorytypeid = 13 -- undelete event
and ph.userid = ##moduserid?100297## -- Martijn
and ph.creationdate > ##since:string?2016-01-01## -- Martijn was elected in 2015
and p.owneruserid <> ph.userid -- not own post
and p.posttypeid = 1 -- Q 
order by ph.creationdate desc

print ##moduserid##
print ##since##

Enter Parameters

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