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

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

Enter Parameters

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