Progress toward the Illuminator badge

3

Please login or register to vote for this query.

(click on this box to dismiss)

How Close are you to getting your badge? enter your UserID below.

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select count(*) Count
  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