Top illuminators

5

Please login or register to vote for this query.

(click on this box to dismiss)

Users that qualify for the Illuminator badge, ranked by qualifying edit count.

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select AOwnerId [User Link], Count
from (select a.OwnerUserId AOwnerId,
             count(*) Count
        from Posts q 
             join Posts a on a.ParentId = q.Id
        where q.PostTypeId = 1 and 
              q.ClosedDate is null and
              a.PostTypeId = 2 and 
              a.Score >= 1 and 
              -- exclude self answered
              IsNull(q.OwnerUserId, -1) <> a.OwnerUserId and 
              exists(select 1 
                       from PostHistory ph 
                      where ph.PostHistoryTypeId in (4,5) 
                        and ph.PostId = a.ParentId 
                        and ph.UserId = a.OwnerUserId 
                        and abs(datediff(hh, ph.CreationDate, a.CreationDate)) < 12)                        
        group by a.OwnerUserId
        having count(*) >= 500) AnswerQEditor
order by Count desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results