Most effective Illuminators


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 AS [User Link], 
       ROUND(Accepted / Count, 2) AS [Accept Rate],
       COUNT(ta.Id) AS [Total Answers],
       ROUND((Count * 100.0) / count(ta.Id), 2) AS Percentage,
       ROUND(Count * (Count / count(ta.Id)), 2) AS Weighting
from (select a.OwnerUserId AOwnerId,
             CAST(count(*) AS float) AS Count,
             CAST(sum(CASE WHEN q.AcceptedAnswerId = a.Id THEN 1 ELSE 0 END) AS float) AS Accepted
        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
              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
inner join Posts ta on ta.OwnerUserId = AOwnerId
group by AOwnerId, Count, Accepted
order by Weighting desc

Enter Parameters

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