Users by privilege bracket in beta sites

1

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

SELECT MinReputation, COUNT(*) AS Number, MaxPrivilege
FROM Users INNER JOIN
(SELECT  5000 AS MinReputation, 2147483647 AS MaxReputation, 'View Site Statistics' AS MaxPrivilege
UNION SELECT  4000 AS MinReputation,  4999 AS MaxReputation, 'Expanded Editing, Deletion, Undeletion Privileges' AS MaxPrivilege
UNION SELECT  3500 AS MinReputation,  3999 AS MaxReputation, 'Protect/Unprotect Questions' AS MaxPrivilege
UNION SELECT  2000 AS MinReputation,  3499 AS MaxReputation, 'Access Reports, Delete Questions, Review Reviews' AS MaxPrivilege
UNION SELECT  1500 AS MinReputation,  1999 AS MaxReputation, 'Review Tag Wiki Suggestions' AS MaxPrivilege
UNION SELECT  1250 AS MinReputation,  1499 AS MaxReputation, 'Suggest Tag Synonyms' AS MaxPrivilege
UNION SELECT  1000 AS MinReputation,  1249 AS MaxReputation, 'Edit, Create Gallery Chat Rooms' AS MaxPrivilege
UNION SELECT   750 AS MinReputation,   999 AS MaxReputation, 'View Vote Breakdown' AS MaxPrivilege
UNION SELECT   500 AS MinReputation,   749 AS MaxReputation, 'Vote to Close/Reopen' AS MaxPrivilege
UNION SELECT   350 AS MinReputation,   499 AS MaxReputation, 'Review First Posts, Late Answers' AS MaxPrivilege
UNION SELECT   250 AS MinReputation,   349 AS MaxReputation, 'Self-Close/Reopen' AS MaxPrivilege
/*UNION SELECT   200 AS MinReputation,   249 AS MaxReputation, 'Reduce Ads, Rep Leagues' AS MaxPrivilege*/
UNION SELECT   150 AS MinReputation,   249 AS MaxReputation, 'Create Tags' AS MaxPrivilege
UNION SELECT   125 AS MinReputation,   149 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