mysql:wikiadmin@db1056 [enwiki]> select count(*) as cnt, up_value as val from user_properties where up_property = 'stubthreshold' group by up_value order by cnt desc; +------+----------------------------------------------+ | cnt | val | +------+----------------------------------------------+ | 1596 | 10000 | | 1222 | 50 | | 955 | 100 | | 717 | 500 | | 713 | 1000 | | 251 | 2000 | | 207 | 5000 | | 202 | 200 | | 178 | 1 | | 159 | 10 | | 145 | 5 | | 83 | 2 | | 57 | 20 | | 49 | 3 | | 48 | 300 | | 46 | 250 | | 33 | 400 | | 27 | 1500 | | 27 | 1024 | | 27 | 2147483647 | | 26 | 25 | | 20 | 4 | | 18 | 150 | | 16 | 30 | | 15 | 2500 | | 14 | 256 | | 14 | 512 | | 13 | 15 | | 13 | 12 | | 12 | 6 | | 11 | 80 | | 9 | 700 | | 9 | 800 | | 9 | 3000 | | 8 | 9 | | 8 | 8 | | 7 | 750 | | 7 | 100000 | | 6 | 350 | | 6 | 2048 | | 6 | 10000000 | | 5 | 5120 | | 5 | 23 | | 5 | 600 | | 4 | 99999999 | | 4 | 13 | | 4 | 999 | | 4 | 60 | | 4 | 10240 | | 4 | 30000 | | 4 | 7 | | 4 | 999999 | | 4 | 1000000 | | 3 | 1200 | | 3 | 120 | | 3 | 70 | | 3 | 99 | | 3 | 4000 | | 3 | 100000000 | | 3 | 33 | | 3 | 14 | | 3 | 1000000 B | | 3 | 6000 | | 2 | 768 | | 2 | 255 | | 2 | 128 | | 2 | 900 | | 2 | 2400 | | 2 | 4096 | | 2 | 40 | | 2 | 199 | | 2 | 24 | | 2 | 64 | | 2 | 99999 | | 2 | 666 | | 2 | 16 | | 2 | 21 | | 2 | 8192 | | 2 | 999999999 | | 2 | 20000 | | 2 | 3500 | | 2 | 8000 | | 2 | 1000000000 | | 1 | 5024 | | 1 | 725 | | 1 | 130 | | 1 | 5012 | | 1 | 995 | | 1 | 247 | | 1 | 49 | | 1 | 2560 | | 1 | 2424 | | 1 | 2223 | | 1 | 12500 | | 1 | 1 B | | 1 | 499 | | 1 | 9999999 | | 1 | 2024 | | 1 | 99999999999999999999999999999999999999999999 | | 1 | 45 | | 1 | 98 | | 1 | 897 | | 1 | 27 | | 1 | 2272 | | 1 | 46 | | 1 | 28 | | 1 | 1600 | | 1 | 421 | | 1 | 54546424 | | 1 | 17 | | 1 | 78 | | 1 | 90000000 | | 1 | 56000 | | 1 | 7000 | | 1 | 2200 | | 1 | 127 | | 1 | 440 | | 1 | 53 | | 1 | 1980 | | 1 | 9999 | | 1 | 5000000 | | 1 | 50000 | | 1 | 3000000 | | 1 | 90 | | 1 | 365 | | 1 | 89 | | 1 | 32 | | 1 | 1048576 | | 1 | 90000 | | 1 | 55 | | 1 | 23331 | | 1 | 500000 | | 1 | 58635 | | 1 | 56 | | 1 | 700000 | | 1 | 1000 GB | | 1 | 15Gb | | 1 | 20 B | | 1 | 250 B | | 1 | 1b | | 1 | 1GB | | 1 | 6666666666666666666666666666666666666666 | | 1 | 100000000000000000 | | 1 | 250B | | 1 | 3214 | | 1 | 999999999999999999 | | 1 | 8367894536793 B | | 1 | 99999999999999999999999999999999999 | | 1 | 1450 | | 1 | 3000 B | | 1 | 100,000,000B | | 1 | 322 | | 1 | 100000mb | | 1 | 1000000000000 | | 1 | 100000000000000000000 | | 1 | 650 | | 1 | 99999999999999999999 | | 1 | 100,000 | | 1 | 225 | | 1 | 100000000000 | | 1 | 555 | | 1 | 999999999999 | | 1 | 450 | | 1 | 35 | | 1 | 110 | | 1 | 25000 | | 1 | 337 | | 1 | 2147483646 | | 1 | 1024000 | | 1 | 2 YB | | 1 | 6GB | | 1 | 254 | | 1 | 1924 | | 1 | 767 | | 1 | 25600 B | | 1 | 250000 | | 1 | 2250 | | 1 | 75 | | 1 | 29 | | 1 | 275 | | 1 | 1024 B | | 1 | 2100 | | 1 | 215 | | 1 | 2800 B | | 1 | 100000000 MB | | 1 | 9999999999999999999999 | | 1 | 1800 | | 1 | 200 B | | 1 | 999999999999999 | | 1 | 3451 | | 1 | 2750 | | 1 | 73 | +------+----------------------------------------------+ 192 rows in set (0.08 sec)