Most effective Illuminators

0

Please login or register to vote for this query.

(click on this box to dismiss)

Illuminator badge holders ranked by their effectiveness; percentage of their answers that qualify for the badge times the number of qualifying answers. This gives a better ranking for how effectively people have improved the original question (how often they edited the question compared to the number of answers they gave).

Stack Overflow

Q&A for professional and enthusiast programmers

select AOwnerId [User Link], 
       Count,
       count(ta.Id) as [Total Answer Count],
       CAST(Count AS float) / CAST(count(ta.Id) as float) * 100.0 as Percentage,
       CAST(Count AS float) * (CAST(Count AS float) / CAST(count(ta.Id) as float)) as Weighting
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 >= 2 and 
              a.AcceptedAnswerId = q.id 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(*) >= 200) AnswerQEditor
inner join Posts ta on ta.OwnerUserId = AOwnerId
group by AOwnerId, Count
order by Weighting desc

Enter Parameters

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