mysql> select count(*) c, a.name, a.account from characters a, characters b where a.name = b.name and a.account = b.account and a.account in (25,29,40,152,159,192,251,441,569,628,679,1311,1385,1452,1478,1595,1718,1736,1737,2138,2251,2289,2994,3037,3049,3141,3207,3393,3659,3726,4058,4399,4535,4595,4697,4848,4906,5119,5183,5191,5261,5262,5263,5265,5275,5296,5299,5341,5353,5363,5429,5475,5528,5765,5921,6005,6070,6098,6166,6241,6283,6404,6564,6840,6999,7051,7070,7222,7266,7519,7526,8112,8226,8235,8678,8783,9271,9550,9610,9618,9714,9979,9989,10311,10441,10472,10484,10498,10499,10505,10510,10529,10531,10534,10570,10609,10665,10858,10914,11031,11114,11167,11220,11239,11254,11284,11510,11649,11686,11712,11763,11768,11770,11781,11782,11792,11796,11805,11844,11902,11914,11939,11954,11980,12102,12116,12142,12153,12165,12232,12248,12264,12299,12352,12368,12475,12667,12750,12838,12871,12944,13004,13022,13043,13241,13243,13244,13245,13247,13336,13347,13354,13355,13356,13473,13731,13872,13965,13968,14084,14204,14465,14503,14526,15039,15592,15677,15960,15961,16034,16094,16399,16450,16492,16498,16541,16779,16795,16843,17576,17578,17593,17617,17807,17814,17909,17922,18104,18233,18306,18384,18550,18587,18597,18658,18718,18719,18734,18740,18744,18745,18746,18747,18966,19082,19146,19212,19235,19340,19544,19580,19586,20062,20272,20613,20691,20728,20978,21025,21086,21370,21379,21383,21405,21507,21575,21962,21991,22157,22225,22441,22467,22699,22824,23682,24004,24007,24204,24220,24548,25418,25513,25517,1000149,1006837,1007235,1007656,1007704,1009349,1009674,1010059,1010259,1010401,1010468,1010499,1010532,1011144,1011764,1012381,1013226,1013241,1013970,1019631,1020177,1020335,1022127,1022133,1022852,1024523,1025179) group by name having c > 2;
+---+--------------+---------+
| c | name         | account |
+---+--------------+---------+
| 4 | Actarus      |   10609 |
| 4 | Angello      |   16779 |
| 4 | Arkham       |    9271 |
| 4 | Aska         |     159 |
| 4 | Asylum       |    5528 |
| 4 | Azghal       |    5183 |
| 4 | Bigelow      |   10531 |
| 4 | Borealis     |   10484 |
| 4 | Brand        |    3049 |
| 4 | Cobretto     |   11114 |
| 4 | Cornomozzo   |   10499 |
| 4 | Dalraw       |   11510 |
| 4 | Darknex      |   11796 |
| 4 | Deadhomer    |   11220 |
| 4 | Deadmarge    |   11220 |
| 4 | Druidbull    |   11902 |
| 4 | Dyrmagnos    |   10529 |
| 4 | Esriell      |   10498 |
| 4 | Farthar      |   10498 |
| 4 | Flax         |   10858 |
| 4 | Framman      |   10914 |
| 4 | Gedda        |   11782 |
| 4 | Ghorr        |   11770 |
| 4 | Gnack        |   10472 |
| 4 | Gnagna       |    3659 |
| 4 | Gotai        |    5921 |
| 4 | Harlton      |   10484 |
| 4 | Harmonya     |   11844 |
| 4 | Iceknight    |    6999 |
| 4 | Imene        |      29 |
| 4 | Indugio      |    7222 |
| 4 | Itzpapalotl  |    3037 |
| 4 | Ivellios     |   11284 |
| 4 | Iveniversoom |   10534 |
| 4 | Joleh        |   11031 |
| 4 | Karg         |   12667 |
| 4 | Khamabunta   |     628 |
| 4 | Khiran       |   21025 |
| 4 | Kreghar      |   17807 |
| 4 | Lelith       |   11114 |
| 4 | Lin          |   11781 |
| 4 | Lispad       |    5183 |
| 4 | Lotus        |   11031 |
| 4 | Machoman     |    5353 |
| 4 | Mohana       |   10665 |
| 4 | Mortex       |   20728 |
| 4 | Mughen       |    7222 |
| 4 | Naiphe       |    3393 |
| 4 | Nessuna      |    9979 |
| 4 | Paros        |    3659 |
| 4 | Rhaizen      |   11902 |
| 4 | Riru         |    9550 |
| 4 | Riu          |   10609 |
| 4 | Rossa        |   11712 |
| 4 | Sagiter      |   19146 |
| 4 | Saphir       |   18734 |
| 4 | Scannello    |   11686 |
| 4 | Shaarum      |   17807 |
| 4 | Sincope      |   14526 |
| 4 | Sotark       |   18746 |
| 4 | Spigugio     |   10570 |
| 4 | Starn        |    6999 |
| 4 | Sylia        |    9610 |
| 4 | Tedra        |   10570 |
| 4 | Thoronar     |   11980 |
| 4 | Toruck       |   12232 |
| 4 | Trallami     |    7222 |
| 4 | Wutevaz      |   19212 |
| 4 | Xaarzen      |    6840 |
| 4 | Xaius        |    2251 |
| 4 | Zapbrannigam |   10510 |
+---+--------------+---------+
71 rows in set (0.01 sec)