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.

Gardening and Landscaping Meta

Q&A for gardeners and landscapers

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