Negatively scored posts edited by the most different users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT TOP 100
  Posts.Id AS [Post Link],
  MIN(Posts.Score) AS Score,
  COUNT(DISTINCT UserId) AS Count
FROM PostHistory, Posts
WHERE
  PostHistory.PostId = Posts.Id
  AND
  PostHistory.PostHistoryTypeId BETWEEN 4 AND 9
  AND
  Posts.Score < 0
GROUP BY Posts.Id
ORDER BY Count DESC, Posts.Id DESC

Enter Parameters

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