Illuminator badge progress

18

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.

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

with answer_edits as (
  select UserId, PostId
  from Posts q
       join PostHistory e on PostId = q.Id
       join Posts a on a.ParentId = q.Id
                       and q.OwnerUserId <> a.OwnerUserId
                       and UserId = a.OwnerUserId
                       and abs(datediff(hour, a.CreationDate, e.CreationDate))
                           < 12
                           
  where PostHistoryTypeId in (4, 5, 6) -- Edit title, body, or tags
        and q.PostTypeId = 1
        and a.PostTypeId = 2
        and q.ClosedDate is null
  group by UserId, PostId
),

currator_badges as (
  select UserId,
         case when count(*) > 10 then 1 else 0 end bronze
  from answer_edits
  group by UserId
)

/* --Debugging
select PostId as [Post Link]
from answer_edits
where UserId = ##UserId##
*/

select sum(bronze) bronzes
from currator_badges

Enter Parameters

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