MariaDB [Tenda]> select seed,concat(PIN,CRC) PIN8,count(*) n from StaticPINs join TendaAll using (PIN,CRC) group by PIN8 having n>1 order by n DESC;
+------+----------+---+
| seed | PIN8     | n |
+------+----------+---+
|   17 | 12279180 | 4 |
|   14 | 21464065 | 3 |
|   22 | 18576313 | 3 |
|   15 | 76229909 | 2 |
|   58 | 16461536 | 2 |
|   16 | 46264848 | 2 |
+------+----------+---+
6 rows in set (0.44 sec)