Total number of users with a stub threshold setting
edit
mysql> SELECT COUNT(*) FROM user_properties WHERE up_property='stubthreshold';
+----------+
| COUNT(*) |
+----------+
| 2580 |
+----------+
Number of active users with a stub threshold setting
edit
mysql> SELECT COUNT(*) FROM user_properties WHERE up_property='stubthreshold' AND up_user NOT IN (SELECT rev_user FROM revision WHERE rev_timestamp < '20090801000000');
+----------+
| COUNT(*) |
+----------+
| 1411 |
+----------+
Frequency of stub thresholds among all users
edit
mysql> SELECT up_value, COUNT(*) AS count FROM user_properties WHERE up_property='stubthreshold' GROUP BY up_value ORDER BY count DESC;
+----------------------------------------------+-------+
| up_value | count |
+----------------------------------------------+-------+
| 50 | 495 |
| 10000 | 447 |
| 100 | 324 |
| 500 | 268 |
| 1000 | 240 |
| 200 | 108 |
| 2000 | 101 |
| 1 | 65 |
| 5000 | 62 |
| 10 | 43 |
| 5 | 37 |
| 250 | 31 |
| 300 | 30 |
| 400 | 26 |
| 20 | 22 |
| 1500 | 21 |
| 2 | 21 |
| 1024 | 14 |
| 150 | 12 |
| 256 | 12 |
| 512 | 12 |
| 2500 | 11 |
| 25 | 11 |
| 3 | 10 |
| 800 | 7 |
| 15 | 7 |
| 12 | 6 |
| 750 | 5 |
| 80 | 5 |
| 600 | 5 |
| 4000 | 5 |
| 3000 | 5 |
| 350 | 4 |
| 700 | 4 |
| 4 | 4 |
| 2048 | 4 |
| 1200 | 3 |
| 30 | 3 |
| 99999999 | 3 |
| 999999 | 3 |
| 60 | 3 |
| 6000 | 3 |
| 999 | 2 |
| 2250 | 2 |
| 8000 | 2 |
| 5120 | 2 |
| 4096 | 2 |
| 16 | 2 |
| 6 | 2 |
| 1000000000 | 2 |
| 8192 | 2 |
| 10000000 | 2 |
| 225 | 1 |
| 2100 | 1 |
| 180 | 1 |
| 768 | 1 |
| 650 | 1 |
| 5024 | 1 |
| 255 | 1 |
| 14 | 1 |
| 128 | 1 |
| 900 | 1 |
| 29 | 1 |
| 3200 | 1 |
| 1800 | 1 |
| 275 | 1 |
| 199 | 1 |
| 666 | 1 |
| 70 | 1 |
| 50000 | 1 |
| 767 | 1 |
| 7 | 1 |
| 120 | 1 |
| 2223 | 1 |
| 1 B | 1 |
| 2750 | 1 |
| 75 | 1 |
| 499 | 1 |
| 2800 B | 1 |
| 1924 | 1 |
| 9999999 | 1 |
| 2024 | 1 |
| 99999999999999999999999999999999999999999999 | 1 |
| 11 | 1 |
| 1600 | 1 |
| 33 | 1 |
| 3500 | 1 |
| 215 | 1 |
| 254 | 1 |
| 127 | 1 |
| 1980 | 1 |
| 1048576 | 1 |
| 23 | 1 |
| 700000 | 1 |
| 1000 GB | 1 |
| 20000 | 1 |
| 20 B | 1 |
| 100000000 | 1 |
| 1000000 B | 1 |
| 250 B | 1 |
| 1b | 1 |
| 1GB | 1 |
| 6666666666666666666666666666666666666666 | 1 |
| 100000000000000000 | 1 |
| 1000000 | 1 |
| 3214 | 1 |
| 999999999999999999 | 1 |
| 8367894536793 B | 1 |
| 99999999999999999999999999999999999 | 1 |
| 1450 | 1 |
+----------------------------------------------+-------+
110 rows in set (0.06 sec)
Frequency of stub thresholds among active users
edit
mysql> SELECT up_value, COUNT(*) AS count FROM user_properties WHERE up_property='stubthreshold' AND up_user NOT IN (SELECT rev_user FROM revision WHERE rev_timestamp < '2009080100
0000') GROUP BY up_value ORDER BY count DESC;
+------------------------------------------+-------+
| up_value | count |
+------------------------------------------+-------+
| 10000 | 397 |
| 50 | 379 |
| 100 | 224 |
| 500 | 139 |
| 1000 | 117 |
| 2000 | 52 |
| 5000 | 49 |
| 10 | 7 |
| 3 | 6 |
| 200 | 3 |
| 20 | 3 |
| 5 | 3 |
| 1 | 3 |
| 2 | 2 |
| 999999 | 2 |
| 9999999 | 1 |
| 16 | 1 |
| 127 | 1 |
| 1000000000 | 1 |
| 700000 | 1 |
| 1000 GB | 1 |
| 20000 | 1 |
| 20 B | 1 |
| 100000000 | 1 |
| 1000000 B | 1 |
| 250 B | 1 |
| 1b | 1 |
| 10240 | 1 |
| 1GB | 1 |
| 150 | 1 |
| 6666666666666666666666666666666666666666 | 1 |
| 100000000000000000 | 1 |
| 300 | 1 |
| 1000000 | 1 |
| 3214 | 1 |
| 10000000 | 1 |
| 999999999999999999 | 1 |
| 8367894536793 B | 1 |
| 99999999999999999999999999999999999 | 1 |
| 1450 | 1 |
+------------------------------------------+-------+
