CW posts edited by few users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

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)

Enter Parameters

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