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.

Japanese Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

select count(PostId) as [Answer Edits]
  from Posts q
       join PostHistory e on PostId = q.Id
       join Posts a on a.ParentId = q.Id
                       and IsNull(q.OwnerUserId, -1) <> 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
        and a.Score >= 1
        and a.OwnerUserId = ##UserId##

Enter Parameters

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