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

with answer_edits as (
  select UserId, PostId
  from Posts q
       join PostHistory on PostId = q.Id
                           --and UserId = a.OwnerUserId
       join Posts a on a.ParentId = q.Id
                       and q.OwnerUserId <> a.OwnerUserId
  where PostHistoryTypeId in (4, 5, 6) -- Edit title, body, or tags
        and q.PostTypeId = 1
        and a.PostTypeId = 2
  group by UserId, PostId
)

select *
from answer_edits
where UserId = ##UserId##

Enter Parameters

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