Users that qualify for the Illuminator badge, ranked by qualifying edit count.
Q&A for those who study, teach, research and apply economics and econometrics
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 > 0 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