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

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 (se.title is not null or se.text is not null)
and a.score > 0
and q.closeddate is null

fork query

edited may 25 anonymous

created may 23 rene