Q&A for aircraft pilots, mechanics, and enthusiasts
---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