What's your Rank in Edits Per User

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

With Edits as (
  SELECT RANK() OVER (ORDER BY COUNT(*) DESC) AS Rank,
         UserID AS [User Link],
         COUNT(*) AS NumRevisions
  FROM PostHistory
  WHERE PostHistoryTypeId BETWEEN 4 AND 9
  GROUP BY UserId
)
SELECT Rank, [User Link], NumRevisions
FROM Edits
WHERE Rank < 100 OR 
      [User Link] = ##UserID##
ORDER BY Rank

Enter Parameters

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