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