User:Nixeagle/toolserver/people with most blocks

Current as of ——  nix eagle 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 |