Suggested most edits

1

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT
  SuggestedEdits.OwnerUserId AS [User Link],
  MIN(Users.Reputation) AS Reputation,
  COUNT(*) AS Count
FROM SuggestedEdits, Users, Posts
WHERE
  SuggestedEdits.OwnerUserId = Users.Id
  AND
  SuggestedEdits.PostId = Posts.Id
  AND
  (
    (##ShowQuestions:int?1## <> 0 AND Posts.PostTypeId = 1)
    OR
    (##ShowAnswers:int?1## <> 0 AND Posts.PostTypeId = 2)
    OR
    (##ShowWikiExcerpts:int?1## <> 0 AND Posts.PostTypeId = 4)
    OR
    (##ShowWikis:int?1## <> 0 AND Posts.PostTypeId = 5)
  )
GROUP BY SuggestedEdits.OwnerUserId
ORDER BY Count DESC, SuggestedEdits.OwnerUserId DESC

Enter Parameters

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