Number of tag-wikis edited (only body)

1

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

---For the purposes of the Research Assistant badge only edits to body (not excerpt) are counted
---https://meta.stackexchange.com/questions/121517/research-assistant-badge-requirements/121518#121518
---https://meta.stackexchange.com/questions/119550/new-silver-badge-for-editing-n-tag-wikis/121484#121484
SELECT COUNT(DISTINCT h.PostId), h.UserId AS [User Link], h.UserDisplayName
FROM PostHistory h JOIN Posts p ON h.PostId=p.Id
WHERE (p.PostTypeId=5) AND (h.PostHistoryTypeId in (2,5))
GROUP BY UserId, UserDisplayName
ORDER BY COUNT(DISTINCT h.PostId) DESC

Enter Parameters

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