mysql> select sum(word_count), sum(lines_talked), sum(timeout_power), sum(banned_until), sum(total_bans) from users where nick in (select nick from users group by nick having count(nick) > 1) group by nick;
+-----------------+-------------------+--------------------+-------------------+-----------------+
| sum(word_count) | sum(lines_talked) | sum(timeout_power) | sum(banned_until) | sum(total_bans) |
+-----------------+-------------------+--------------------+-------------------+-----------------+
|            1052 |               188 |                  6 |                 0 |              10 | 
|            4778 |               520 |                  0 |                 0 |               9 | 
|             404 |                60 |                  0 |                 0 |               2 | 
|             824 |                47 |                 17 |        1221588655 |              21 | 
|            1846 |               267 |                  6 |                 0 |              10 | 
|             233 |                53 |                  6 |        1205717633 |              10 | 
|             182 |                20 |                  0 |                 0 |               1 | 
|            1034 |               136 |                  0 |                 0 |               7 | 
|             158 |                36 |                  0 |                 0 |               4 | 
+-----------------+-------------------+--------------------+-------------------+-----------------+
9 rows in set (0.03 sec)