Top illuminator hopefuls


Please login or register to vote for this query.

(click on this box to dismiss)

Users that are targeting the Illuminator badge, ranked by qualifying edit count.

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results