questions that got a suggested edit after an answer within 12 hours

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/250777/delay-in-approval-leads-to-missing-out-on-being-awarded-an-explainer-badge

Stack Overflow

Q&A for professional and enthusiast programmers

select a.creationdate
     , se.creationdate
     , se.approvaldate
     , a.id [Post Link]
     , a.owneruserid [User Link]
from posts a
inner join posts q on q.id = a.parentid
inner join suggestededits se on se.postid = a.parentid
where a.posttypeid = 2 -- A
and a.owneruserid = se.owneruserid
and se.creationdate between dateadd(hh, -12, a.creationdate) and dateadd(hh,12, a.creationdate)
and se.approvaldate > dateadd(hh, 12, a.creationdate)
and a.score > 1
and q.closeddate is null

Enter Parameters

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