Illuminator badge progress (test for showing the question link where earned credit)


Please login or register to vote for this query.

(click on this box to dismiss)

How far along are you for the Illuminator badge? You need 500 qualifying answers; 50 for the Refiner and 1 for Explainer.

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

select q.Id as [Post Link], q.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)

Enter Parameters

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