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.

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

DECLARE @Minimum int = ##Minimum?20##;
-- Minimum: Minimum count:   "Returns all users with at least this many qualifying edits"

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(*) >= @Minimum) AnswerQEditor
order by Count desc

Enter Parameters

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