Most frequent editors of my posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT
  ph.UserId AS [User Link], ph.UserDisplayName,
  COUNT(DISTINCT RevisionGUID) AS [Count]
FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id
WHERE (p.OwnerUserId=##userid?8297##)
GROUP BY ph.UserId, ph.UserDisplayName
ORDER BY COUNT(DISTINCT RevisionGUID) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results