Thinking about this post: Suggested edit system is causing grief, needs to be rethought
I'm looking for a Data Explorer query to see how many users have received the full 1000 rep limit from accepted edit suggestions. It shouldn't be many because you don't earn them any more after 2000 (with the exception of tag wiki edits), I know I'd personally only made about 20 edits before I hit 2000 rep.
I'm interested in this because I'm concerned about the users who may be submitting low quality edits only to gain rep.
Ideally the results would be sorted by lowest rep first, to see who only has 1001 rep, with all 1000 coming from edits.
Just think, all those people are presumably "established users" who have "been around for a while"! Even if it's just from a few hours of adding tags!
TargetRepChange
in the database, but it seems to only pop up 0 for whatever reason. I wonder if it isn't actually possible other than creating a query to see who has over 500 approved suggested edits under 2000 rep... – jmac Feb 18 '14 at 7:08TargetRepChange
ever actually returns anything but zero:SELECT TOP 100 SUM(TargetRepChange) AS [Rep Change], TargetUserId AS [User Link] FROM SuggestedEditVotes GROUP BY TargetUserId
– jmac Feb 18 '14 at 7:10