How far along are you for the Illuminator badge? You need 500 qualifying answers; 50 for the Refiner and 1 for Explainer.
Q&A for scientists using computers to solve scientific problems
with answer_edits as ( select UserId, PostId from Posts q join PostHistory e on PostId = q.Id join Posts a on a.ParentId = q.Id and q.OwnerUserId <> a.OwnerUserId and UserId = a.OwnerUserId and abs(datediff(hour, a.CreationDate, e.CreationDate)) < 12 where PostHistoryTypeId in (4, 5, 6) -- Edit title, body, or tags and q.PostTypeId = 1 and a.PostTypeId = 2 and q.ClosedDate is null group by UserId, PostId ), currator_badges as ( select UserId, case when count(*) > 10 then 1 else 0 end bronze from answer_edits group by UserId ) /* --Debugging select PostId as [Post Link] from answer_edits where UserId = ##UserId## */ select sum(bronze) bronzes from currator_badges