Q&A for community managers, administrators, and moderators
SELECT TOP(##num?100##) p.Id AS [Post Link], revisions = 'site://posts/' + CAST(p.Id AS varchar)+'/revisions', COUNT(DISTINCT ph.RevisionGUID) AS [Number of Revisions], CAST(COUNT(DISTINCT ph.UserId)+COUNT(DISTINCT ph.UserDisplayName) AS Integer) AS [Number of Users], COUNT(DISTINCT ph.UserId) AS [Number of existing Users], COUNT(DISTINCT ph.UserDisplayName) AS [Number of deleted users] FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id WHERE (p.CommunityOwnedDate IS NOT NULL) ---only CW posts AND (ph.PostHistoryTypeId in (1,2,3,4,5,6,7,8,9)) ---only edits GROUP BY p.Id ORDER BY CAST(COUNT(DISTINCT ph.UserId)+COUNT(DISTINCT ph.UserDisplayName) AS Integer)