Top illuminator hopefuls

3

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

select a.OwnerUserId as [User Link], count(PostId) as [Answer Edits]
  from Posts q
       join PostHistory e on PostId = q.Id
       join Posts a on a.ParentId = q.Id
                       and IsNull(q.OwnerUserId, -1) <> a.OwnerUserId
                       and UserId = a.OwnerUserId
                       and abs(datediff(hour, a.CreationDate, e.CreationDate))
                           < 12
                       and PostHistoryTypeId in (4, 5)
  where q.PostTypeId = 1
        and a.PostTypeId = 2
        and a.Score >= 1
  group by a.OwnerUserId
  having count(PostId) >= 500
  order by count(PostId) desc

Enter Parameters

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