List all answers that count for the Illuminator badge


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.


Q&A for those who study, teach, research and apply economics and econometrics

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

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