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

0

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

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