Notorious R.I.M. posted:

Here it is with the 100,000 hour probations removed:

code:

MariaDB [test]> SELECT TargetUserName, SUM(BanLength)/86400 as probate_days, COUNT(BanLength) AS probate_instances
    -> FROM lepers
    -> WHERE BanType = 'probation'
    -> AND BanLength <> '360000000'
    -> GROUP BY TargetUserName
    -> ORDER BY probate_days DESC LIMIT 50;
+----------------------+--------------+-------------------+
| TargetUserName       | probate_days | probate_instances |
+----------------------+--------------+-------------------+
| TenementFunster      |     439.0000 |                83 |
| Narciss              |     395.7500 |                39 |
| Zeitgueist           |     345.2500 |                43 |
| autopsy-turvey       |     298.5000 |                33 |
| Never Post Again     |     288.2500 |               185 |
| Black Baby Goku      |     282.2500 |                71 |
| I.N.R.I              |     274.2500 |               110 |
| Iseeyouseemeseeyou   |     263.0000 |                58 |
| Retarded_Clown_      |     254.7500 |                37 |
| Nonviolent J         |     242.7500 |                49 |
| Cabbagepots          |     235.2500 |                38 |
| Rass P               |     231.5000 |                41 |
| Duck and Cover       |     231.5000 |                34 |
| Grandpas a Racist    |     227.0000 |                19 |
| Iluvlortab           |     226.5000 |                43 |
| Dirty Rob            |     226.2500 |                22 |
| IzzyFnStradlin       |     220.2500 |                31 |
| Vaerai Archon        |     219.5000 |                29 |
| Dr. Gitmo Moneyson   |     216.2500 |                68 |
| rbis4rbb             |     213.0000 |                16 |
| T-Paine              |     209.0000 |                32 |
| a Loving Dog         |     204.0000 |                62 |
| Emden                |     203.0000 |                23 |
| mootmoot             |     202.7500 |                15 |
| Cool Bear            |     202.5000 |                20 |
| MOVIE MAJICK         |     200.5000 |                29 |
| SpeedGem             |     198.2500 |                29 |
| Lord Waffle Beard    |     196.7500 |                30 |
| gowb                 |     196.2500 |                27 |
| doritos              |     196.0000 |                25 |
| Vile                 |     196.0000 |                39 |
| Particle Board       |     195.7500 |                15 |
| Devour               |     195.0000 |                32 |
| LostCause            |     192.5000 |                25 |
| Turn left Dale!! Noo |     192.5000 |                19 |
| Morphix              |     192.2500 |                24 |
| asbo subject         |     189.0000 |                19 |
| actionjackson        |     188.7500 |                29 |
| echinopsis           |     187.7500 |                48 |
| Shakespearean Beef   |     187.7500 |                29 |
| Paul Pot             |     182.2500 |                19 |
| Willa Rogers         |     182.2500 |                20 |
| All Of The Dicks     |     181.2500 |                22 |
| Teabiscuit           |     180.7500 |                13 |
| Mr. Unlucky          |     178.2500 |                28 |
| Matlock, BRB         |     178.0000 |                17 |
| Goatstein            |     178.0000 |                26 |
| a creepy colon       |     177.7500 |                41 |
| gently caress da Mods         |     176.5000 |                25 |
| Casino               |     175.5000 |                13 |
+----------------------+--------------+-------------------+