Number of tag-info edits (including deleted users)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT COUNT(DISTINCT h.RevisionGUID), h.UserId AS [User Link], h.UserDisplayName
FROM PostHistory h JOIN Posts p ON h.PostId=p.Id
WHERE (p.PostTypeId in (4,5)) AND (h.PostHistoryTypeId in (2,5))
GROUP BY UserId, UserDisplayName
ORDER BY COUNT(DISTINCT h.RevisionGUID) DESC

Enter Parameters

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