List all answers that count for the Illuminator badge

3

Please login or register to vote for this query.

(click on this box to dismiss)

This is a list of all answers for a user that count for the Explainer, Refiner and Illuminator badges, sorted by newest answer first.

Stack Overflow

Q&A for professional and enthusiast programmers

select a.Id as [Post Link], a.Score, a.CreationDate
  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 
       a.OwnerUserId = ##UserId## 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)
order by a.CreationDate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results