MariaDB [Tenda]> select tenda_pin8('04:95:E6:53:68:B0');
*************************** 1. row ***************************
tenda_pin8('04:95:E6:53:68:B0'):
|----------------------------------------------------------------------------------------------|
|Опорные точки (ближайшие данные в базе):
|1) 04:95:E6:53:65:A0, -784,    1437 пар, 105 уникальных дельт (1:13.7), 72 мажорных(вес 97.7%)
|2) 04:95:E6:53:65:20, -912,    1328 пар, 140 уникальных дельт (1:9.49), 90 мажорных(вес 96.2%)
|3) 04:95:E6:53:64:50, -1120,   1289 пар,  78 уникальных дельт (1:16.5), 43 мажорных(вес 97.3%)
|4) 04:95:E6:53:64:48, -1128,   1226 пар,  79 уникальных дельт (1:15.5), 54 мажорных(вес 98.0%)
|5) 04:95:E6:53:64:38, -1144,   1195 пар,  59 уникальных дельт (1:20.3), 34 мажорных(вес 97.9%)
|6) 04:95:E6:53:64:28, -1160,   1207 пар,  78 уникальных дельт (1:15.5), 49 мажорных(вес 97.6%)
|7) 04:95:E6:53:64:08, -1192,   1181 пар,  92 уникальных дельт (1:12.8), 68 мажорных(вес 98.0%)
|8) 04:95:E6:53:63:A0, -1296,   1201 пар,  92 уникальных дельт (1:13.1), 57 мажорных(вес 97.1%)
|----------------------------------------------------------------------------------------------|
|После объединения осталось 523 пинов, из них 0 полностью перекрёстных (MaxX=3).
|Эффективность халф-оптимизации: 2.20.
|----------------------------------------------------------------------------------------------|
|ИТОГО: 238 фёст-халфов, 0 полно-перекрёстных.
|----------------------------------------------------------------------------------------------|
1 row in set (1.33 sec)

MariaDB [Tenda]> select * from tmp_TendaHalfs where X>1 order by n;
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| n    | Half | X    | Xh   | m    | m1   | m2   | m3   | m4   | m5   | m6   | m7   | m8   |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
|    1 | 6647 |    3 |    3 | 1010 |    0 |    0 |    7 |  332 |    0 |    0 |  446 |  225 |
|    2 | 6582 |    3 |    3 |  801 |    0 |    0 |   30 |  356 |    0 |    0 |  259 |  156 |
|    3 | 9353 |    3 |    3 |  638 |   90 |   16 |    0 |    0 |  147 |  385 |    0 |    0 |
|    4 | 6581 |    3 |    3 |  601 |    0 |    0 |   22 |   59 |    0 |    0 |   73 |  447 |
|    5 | 7582 |    3 |    3 |  391 |    0 |    0 |  260 |   69 |    0 |    0 |   54 |    8 |
|    6 | 5065 |    3 |    3 |  387 |   91 |  254 |    0 |    0 |    2 |   40 |    0 |    0 |
|    7 | 7581 |    3 |    3 |  370 |    0 |    0 |  312 |   18 |    0 |    0 |   17 |   23 |
|    8 | 5130 |    3 |    3 |  314 |   53 |   97 |    0 |    0 |  133 |   31 |    0 |    0 |
|    9 | 9287 |    3 |    3 |  311 |  118 |   26 |    0 |    0 |    2 |  165 |    0 |    0 |
|   10 | 7647 |    3 |    3 |  287 |    0 |    0 |  125 |   62 |    0 |    0 |   73 |   27 |
|   11 | 5064 |    3 |    3 |   50 |   15 |   32 |    0 |    0 |    2 |    1 |    0 |    0 |
|   12 | 8353 |    2 |    2 |  836 |    0 |   59 |    0 |    0 |  737 |   40 |    0 |    0 |
|   13 | 6065 |    2 |    2 |  483 |  397 |   28 |    0 |    0 |    0 |   58 |    0 |    0 |
|   14 | 6130 |    2 |    2 |  363 |  284 |   12 |    0 |    0 |    0 |   67 |    0 |    0 |
|   15 | 9288 |    2 |    2 |  279 |   61 |   13 |    0 |    0 |    0 |  205 |    0 |    0 |
|   16 | 3359 |    2 |    2 |  175 |    0 |    0 |   51 |  101 |    0 |    0 |   23 |    0 |
|   17 | 5647 |    2 |    2 |  100 |    0 |    0 |    0 |   24 |    0 |    0 |   33 |   43 |
|   18 | 3424 |    2 |    2 |   86 |    0 |    0 |   13 |   49 |    0 |    0 |   24 |    0 |
|   19 | 5582 |    2 |    2 |   86 |    0 |    0 |    0 |   32 |    0 |    0 |   26 |   28 |
|   20 | 8288 |    2 |    2 |   80 |    0 |   61 |    0 |    0 |    1 |   18 |    0 |    0 |
|   21 | 5581 |    2 |    2 |   72 |    0 |    0 |    0 |    9 |    0 |    0 |    4 |   59 |
|   22 | 6064 |    2 |    2 |   58 |   50 |    5 |    0 |    0 |    0 |    3 |    0 |    0 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
22 rows in set (0.00 sec)