Illuminator badge progress

19

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.

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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

select *
from answer_edits
where UserId = ##UserId##

Enter Parameters

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