Illuminator Progress


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

select u.Id as [User Link],
       count(*) [Illuminator Progress]
  from Posts q 
  join Posts a on a.ParentId = q.Id
  join Users u on u.Id = a.OwnerUserId
 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 u.Id, DisplayName
 order by [Illuminator Progress] DESC

Enter Parameters

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