User:Nixeagle/toolserver/people with most blocks
Current as of —— nixeagle 20:30, 10 November 2008 (UTC)
QUERY: select distinct log_title, count(*) as counter from logging where log_action = "block" group by log_title order by counter desc limit 100;
Note that the first two are test accounts.
+---------------------------+---------+ | log_title | counter | +---------------------------+---------+ | ThisIsaTest | 187 | | Animum's_Electric_Pajamas | 169 | | 207.200.116.0/24 | 154 | | 202.156.6.54 | 145 | | 217.33.207.195 | 129 | | 152.163.100.0/24 | 112 | | 194.80.20.10 | 100 | | 217.33.74.20 | 96 | | 64.12.116.0/24 | 83 | | 63.19.128.0/17 | 83 | | Misza | 76 | | 205.188.0.0/16 | 73 | | 192.0.2.16 | 72 | | SPUI | 66 | | 169.244.143.115 | 65 | | 205.188.116.0/24 | 63 | | 142.22.16.58 | 58 | | 152.163.0.0/16 | 57 | | 205.188.116.139 | 57 | | 195.93.21.0/24 | 55 | | 168.213.1.134 | 54 | | 142.22.186.13 | 51 | | Freaksock | 51 | | Curps | 49 | | 64.12.0.0/16 | 49 | | 205.188.116.0/23 | 49 | | 38.116.192.13 | 48 | | 203.14.53.45 | 47 | | 207.200.116.13 | 47 | | 194.80.21.10 | 46 | | 217.65.149.50 | 46 | | 169.244.70.148 | 45 | | 24.66.94.140 | 45 | | BetacommandBot | 45 | | 24.70.95.203 | 44 | | 64.12.117.11 | 43 | | 203.14.53.46 | 42 | | 152.163.101.5 | 42 | | 202.6.138.33 | 42 | | 194.187.32.1 | 42 | | 159.191.12.24 | 41 | | 152.163.100.65 | 41 | | 24.64.223.203 | 41 | | 152.163.101.0/24 | 41 | | 205.188.117.0/24 | 41 | | 210.15.254.45 | 40 | | 205.188.116.200 | 39 | | 64.12.116.201 | 38 | | 207.200.64.0/18 | 38 | | 64.12.117.5 | 37 | | 209.202.75.74 | 37 | | 169.139.180.100 | 37 | | 203.173.8.12 | 37 | | 64.12.116.0/23 | 37 | | 217.23.232.194 | 37 | | Giovanni33 | 37 | | 64.12.116.202 | 36 | | 64.12.117.0/24 | 36 | | 202.6.138.34 | 36 | | Nixer | 36 | | 193.39.158.195 | 35 | | 64.235.102.2 | 35 | | Mistress_Selina_Kyle | 34 | | 152.163.100.133 | 34 | | 210.8.110.36 | 34 | | 152.163.100.131 | 34 | | 64.12.116.139 | 34 | | 199.43.172.254 | 33 | | 216.208.8.227 | 33 | | 207.200.116.68 | 33 | | 207.200.116.201 | 33 | | 205.188.117.70 | 33 | | 152.163.100.13 | 33 | | 192.139.27.18 | 32 | | 203.10.121.83 | 32 | | 212.69.231.226 | 32 | | 198.20.32.254 | 32 | | 203.62.10.3 | 32 | | 203.122.254.26 | 32 | | 152.163.100.10 | 32 | | 85.31.137.11 | 32 | | 202.146.15.20 | 32 | | 209.226.36.10 | 31 | | 203.62.10.9 | 31 | | 64.12.116.198 | 31 | | 152.163.100.9 | 31 | | 168.9.35.14 | 31 | | 198.169.140.30 | 31 | | 207.200.116.203 | 31 | | 205.188.116.65 | 31 | | 152.163.100.197 | 31 | | 205.188.116.199 | 31 | | 82.148.97.69 | 31 | | 205.188.116.7 | 30 | | 64.12.116.197 | 30 | | 193.112.229.153 | 30 | | 205.188.117.69 | 30 | | 207.200.116.136 | 30 | | 216.221.81.98 | 30 | | 125.236.44.45 | 30 | +---------------------------+---------+