Users by privilege bracket

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT MinReputation, COUNT(*) AS Number, MaxPrivilege
FROM Users INNER JOIN
(SELECT 25000 AS MinReputation, 2147483647 AS MaxReputation, 'View Site Statistics' AS MaxPrivilege
UNION SELECT 20000 AS MinReputation, 24999 AS MaxReputation, 'Vote to Delete Answers' AS MaxPrivilege
UNION SELECT 15000 AS MinReputation, 19999 AS MaxReputation, 'Protect/Unprotect Questions' AS MaxPrivilege
UNION SELECT 10000 AS MinReputation, 14999 AS MaxReputation, 'View Moderation Reports, Deleted Posts, Vote to Delete Questions' AS MaxPrivilege
UNION SELECT  5000 AS MinReputation,  9999 AS MaxReputation, 'Review Tag Wiki Suggestions' AS MaxPrivilege
UNION SELECT  3000 AS MinReputation,  4999 AS MaxReputation, 'Vote to Close/Reopen' AS MaxPrivilege
UNION SELECT  2500 AS MinReputation,  2999 AS MaxReputation, 'Suggest Tag Synonyms' AS MaxPrivilege
UNION SELECT  2000 AS MinReputation,  2499 AS MaxReputation, 'Edit' AS MaxPrivilege
/*UNION SELECT  1500 AS MinReputation,  1999 AS MaxReputation, 'Create Tags' AS MaxPrivilege*/
UNION SELECT  1000 AS MinReputation,  1999 AS MaxReputation, 'View Vote Breakdown, Create Gallery Chat Rooms, Create Tags' AS MaxPrivilege
UNION SELECT   500 AS MinReputation,   999 AS MaxReputation, 'Review First Posts, Late Answers, Triage' AS MaxPrivilege
UNION SELECT   250 AS MinReputation,   499 AS MaxReputation, 'Self-Close/Reopen' AS MaxPrivilege
/*UNION SELECT   200 AS MinReputation,   249 AS MaxReputation, 'Reduce Ads, Rep Leagues' AS MaxPrivilege*/
UNION SELECT   125 AS MinReputation,   249 AS MaxReputation, 'Downvote' AS MaxPrivilege
UNION SELECT   100 AS MinReputation,   124 AS MaxReputation, 'Create Chat Rooms, Edit Wiki' AS MaxPrivilege
UNION SELECT    75 AS MinReputation,    99 AS MaxReputation, 'Bounty' AS MaxPrivilege
UNION SELECT    50 AS MinReputation,    74 AS MaxReputation, 'Comment' AS MaxPrivilege
UNION SELECT    20 AS MinReputation,    49 AS MaxReputation, 'Chat' AS MaxPrivilege
UNION SELECT    15 AS MinReputation,    19 AS MaxReputation, 'Upvote, Flag' AS MaxPrivilege
UNION SELECT    10 AS MinReputation,    14 AS MaxReputation, 'Create Wiki, New User' AS MaxPrivilege
UNION SELECT     5 AS MinReputation,     9 AS MaxReputation, 'Meta' AS MaxPrivilege
UNION SELECT     1 AS MinReputation,     4 AS MaxReputation, 'Post' AS MaxPrivilege) Brackets
ON Users.Reputation >= Brackets.MinReputation AND Users.Reputation <= Brackets.MaxReputation
GROUP BY MinReputation, MaxPrivilege
ORDER BY MinReputation DESC

Enter Parameters

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