mysql> select a.username, a.email, r.ip, count(1) AS votes
    -> FROM HeapReaction AS r
    -> INNER JOIN HeapAccount AS a ON a.id=r.owner_id
    -> WHERE type='vote' AND ip LIKE '%75.93.27.248%'
    -> GROUP BY owner_id ORDER BY count(1) DESC;
+------------------+-----------------------------+-----------------------------+-------+
| username         | email                       | ip                          | votes |
+------------------+-----------------------------+-----------------------------+-------+
| bridgets6        | bridgets6@hotmail.com       | 75.93.27.248, 192.168.255.3 |     8 |
| FunkierWinner    | lu_sorenson@live.com        | 75.93.27.248, 192.168.255.3 |     8 |
| bridget          | moneyearn2011@live.com      | 75.93.27.248, 192.168.255.3 |     8 |
| bridget6         | bridget6@live.com           | 75.93.27.248, 192.168.255.3 |     7 |
| kyra             | kyra_sorenson@hotmail.com   | 75.93.27.248, 192.168.255.3 |     7 |
| bsorenson        | bsorenson@cvtc.student.edu  | 75.93.27.248, 192.168.255.3 |     7 |
| travis_sparton   | travis_sorenson@hotmail.com | 75.93.27.248, 192.168.255.3 |     6 |
| fallinggamer     | dylan_sorenson@live.com     | 75.93.27.248, 192.168.255.3 |     5 |
| travis-grunt     | money981@live.com           | 75.93.27.248, 192.168.255.3 |     4 |
| halo123isthebest | bule1taem@live.com          | 75.93.27.248, 192.168.255.3 |     4 |
| doglover         | kyle_sorenson@hotmail.com   | 75.93.27.248, 192.168.255.3 |     4 |
| Fieldelite       | drew_sorenson@hotmail.com   | 75.93.27.248, 192.168.255.3 |     4 |
| halolover9999    | jsorenson6@gmail.com        | 75.93.27.248, 192.168.255.3 |     3 |
| fallinggame      | sorenson1dylan@live.com     | 75.93.27.248, 192.168.255.3 |     3 |
| halomand         | kyle_sorenson@live.com      | 75.93.27.248, 192.168.255.3 |     2 |
| itsbulething     | bule1team@live.com          | 75.93.27.248, 192.168.255.3 |     1 |
| Ratar            | chris54703@clearwire.net    | 75.93.27.248, 192.168.255.3 |     1 |
+------------------+-----------------------------+-----------------------------+-------+