patrick.net

Who pisses off the other users the most? Let's see.

mysql> select username, dislikes / likes as trollishness from users where dislikes > 100 order by trollishness desc limit 10;

+-----------------+--------------+
| username        | trollishness |
+-----------------+--------------+
| Cloud           |       4.7667 |
| Honest Abe      |       3.3540 |
| Bap33           |       2.1308 |
| CaptainShuddup  |       1.8116 |
| KILLERJANE      |       1.6750 |
| Ruki            |       1.5085 |
| AlexS           |       1.4444 |
| thomas.wong1986 |       1.4337 |
| clambo          |       1.2775 |
| robertoaribas   |       1.2278 |
+-----------------+--------------+

mysql> select username, ignoredby from users order by ignoredby desc limit 10;

+--------------------------------+-----------+
| username                       | ignoredby |
+--------------------------------+-----------+
| APOCALYPSEFUCK is Shostakovich |        22 |
| PermaRenter                    |        18 |
| ArtimusMaxtor                  |        17 |
| Ruki                           |        14 |
| CaptainShuddup                 |        13 |
| repo4sale                      |        12 |
| Honest Abe                     |        12 |
| Dan8267                        |        11 |
| Bigsby                         |        11 |
| Cloud                          |        10 |
+--------------------------------+-----------+

The intersection of those sets is Ruki, CaptainShuddup, Honest Abe, Cloud.