Explainer Refiner Illuminator Badge Progress

6

Please login or register to vote for this query.

(click on this box to dismiss)

These badges are awarded based on the number of questions both edited and answered within 12 hours where the answer score is positive. Edited questions with multiple positive score answers only get counted once.

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

select
  case when edits >= 1 then 'Yes' else concat(edits, '/', 1) end as Explainer,
  case when edits >= 50 then 'Yes' else concat(edits, '/', 50) end as Refiner,
  case when edits >= 500 then 'Yes' else concat(edits, '/', 500) end as Illuminator
from (select count(distinct q.Id) as edits
  from Posts a
  join Posts q on q.Id = a.ParentId
    and q.PostTypeId = 1
    and q.ClosedDate is null
    and (q.OwnerUserId != ##UserId## or q.OwnerUserId is null)
  join PostHistory ph on ph.PostId = a.ParentId
    and ph.PostHistoryTypeId in (4,5)
    and ph.UserId = ##UserId##
    and abs(datediff(hh, ph.CreationDate, a.CreationDate)) <= 12
  where a.OwnerUserId = ##UserId##
  and a.PostTypeId = 2
  and a.Score >= 1
) x

Enter Parameters

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