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 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