How far along are you for the Illuminator badge? You need 500 qualifying answers; 50 for the Refiner and 1 for Explainer.
Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
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 and a.Score >= 1 group by UserId, PostId ), currator_badges as ( select UserId, case when count(*) >= 10 then 1 else 0 end bronze, case when count(*) >= 50 then 1 else 0 end silver, case when count(*) >= 500 then 1 else 0 end gold from answer_edits group by UserId ) /* --Debugging select PostId as [Post Link] from answer_edits where UserId = ##UserId## */ select sum(bronze) keepers, sum(silver) archivists, sum(gold) curators from currator_badges