sqlite> select a1.from_,h.addr,h.contents,h2.hintsrc,h2.contents,count(*) as cnt from hint h join addr as a1 on a1.to_ = h.addr join hint as h2 on h2.addr = a1.from_ and h2.hintsrc = 'BOOTP.Fingerprint' where h.hintsrc = 'BROWSE.OS' group by h.contents,h2.contents order by length(h2.contents) desc, h2.contents desc, cnt desc;
a1.from_           h.addr       h.contents  h2.hintsrc         h2.contents                                                             cnt
-----------------  -----------  ----------  -----------------  ----------------------------------------------------------------------  ----------
00:1a:a0:5f:30:52  10.43.97.62  6.0         BOOTP.Fingerprint  128,Req,"53,61,50,54,12,81,60,55","1,15,3,6,44,46,47,31,33,121,249,43"  1
00:1e:4f:51:fe:e4  169.254.145  5.1         BOOTP.Fingerprint  128,Req,"53,61,50,54,12,81,60,55,43","1,15,3,6,44,46,47,31,33,249,43"   3
00:1a:a0:5f:30:52  10.43.97.62  6.0         BOOTP.Fingerprint  128,Dis,"53,116,61,50,12,60,55","1,15,3,6,44,46,47,31,33,121,249,43"    1
00:1a:a0:5f:30:52  10.43.97.62  6.0         BOOTP.Fingerprint  128,Req,"53,61,50,12,81,60,55","1,15,3,6,44,46,47,31,33,121,249,43"     2
00:1e:4f:51:fe:e4  169.254.145  5.1         BOOTP.Fingerprint  128,Dis,"53,116,61,50,12,60,55,43","1,15,3,6,44,46,47,31,33,249,43"     3
00:0b:db:d6:e1:c4  10.43.99.5   5.1         BOOTP.Fingerprint  128,Req,"53,77,61,50,54,12,60,55","1,15,3,6,44,46,47,31,33,249,43"      1
00:23:7d:3b:5a:30  10.43.97.12  5.2         BOOTP.Fingerprint  128,Req,"53,61,50,54,12,81,60,55","1,15,3,6,44,46,47,31,33,249,43"      2
00:0f:1f:66:5f:78  10.43.97.3   5.1         BOOTP.Fingerprint  128,Req,"53,61,50,54,12,81,60,55","1,15,3,6,44,46,47,31,33,249,43"      1
00:06:5b:bb:1c:37  10.43.97.13  5.1         BOOTP.Fingerprint  128,Req,"53,61,50,12,81,60,55,43","1,15,3,6,44,46,47,31,33,249,43"      18
00:0b:db:66:77:4a  10.43.97.68  5.0         BOOTP.Fingerprint  128,Req,"53,61,50,12,81,60,55,43","1,15,3,6,44,46,47,31,33,249,43"      1
00:06:5b:bb:1c:37  10.43.97.10  5.2         BOOTP.Fingerprint  128,Req,"53,61,50,12,81,60,55,43","1,15,3,6,44,46,47,31,33,249,43"      1
00:1a:a0:5f:30:52  10.43.97.62  6.0         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55","1,15,3,6,44,46,47,31,33,121,249,43,252"       2
00:06:5b:bb:1c:37  10.43.97.13  5.1         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55,43","1,15,3,6,44,46,47,31,33,249,43,252"        22
00:0b:db:66:77:4a  10.43.97.68  5.0         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55,43","1,15,3,6,44,46,47,31,33,249,43,252"        1
00:06:5b:bb:1c:37  10.43.97.10  5.2         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55,43","1,15,3,6,44,46,47,31,33,249,43,252"        1
00:11:43:69:08:f2  10.43.97.75  5.1         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55","1,15,3,6,44,46,47,31,33,249,43,252,12"        3
00:0f:1f:66:5f:78  10.43.97.3   5.2         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55","1,15,3,6,44,46,47,31,33,249,43,252,12"        1
00:0b:db:d6:e1:c4  10.43.99.5   5.1         BOOTP.Fingerprint  128,Dis,"53,77,116,61,12,60,55","1,15,3,6,44,46,47,31,33,249,43"        1
00:23:7d:3b:5a:30  10.43.97.12  5.2         BOOTP.Fingerprint  128,Dis,"53,116,61,50,12,60,55","1,15,3,6,44,46,47,31,33,249,43"        1
00:11:43:30:20:4d  10.43.96.8   5.2         BOOTP.Fingerprint  128,Req,"53,77,61,50,12,60,55","1,15,3,6,44,46,47,31,33,249,43"         1
00:11:43:69:08:f2  10.43.97.75  5.1         BOOTP.Fingerprint  128,Req,"53,61,50,12,81,60,55","1,15,3,6,44,46,47,31,33,249,43"         8
00:23:7d:3b:5a:30  10.43.97.12  5.2         BOOTP.Fingerprint  128,Req,"53,61,50,12,81,60,55","1,15,3,6,44,46,47,31,33,249,43"         4
00:0b:db:e7:9a:c4  10.43.96.5   5.0         BOOTP.Fingerprint  128,Req,"53,77,61,50,54,12,60,55","1,15,3,6,44,46,47,31,33,43"          1
00:c0:4f:8c:c6:15  10.43.97.8   5.0         BOOTP.Fingerprint  128,Req,"53,61,50,54,12,81,60,55","1,15,3,6,44,46,47,31,33,43"          1
00:11:43:69:08:f2  10.43.97.75  5.1         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55","1,15,3,6,44,46,47,31,33,249,43,252"           12
00:0e:0c:38:43:c0  10.43.97.11  5.2         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55","1,15,3,6,44,46,47,31,33,249,43,252"           4
00:0f:1f:66:5f:78  10.43.97.3   5.1         BOOTP.Fingerprint  128,Dis,"53,116,61,12,60,55","1,15,3,6,44,46,47,31,33,249,43"           1
00:0f:1f:66:5f:78  10.43.97.3   5.2         BOOTP.Fingerprint  128,Dis,"53,116,61,12,60,55","1,15,3,6,44,46,47,31,33,249,43"           1
00:19:b9:5b:8f:78  10.43.97.81  5.1         BOOTP.Fingerprint  128,Req,"53,61,12,81,60,55","1,15,3,6,44,46,47,31,33,249,43"            2
00:c0:4f:8c:c6:15  10.43.97.8   5.0         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55","1,15,3,6,44,46,47,31,33,43,252,12"            1
00:0b:db:e7:9a:c4  10.43.96.5   5.0         BOOTP.Fingerprint  128,Dis,"53,77,251,61,12,60,55","1,15,3,6,44,46,47,31,33,43"            1
00:0b:db:e7:9a:c4  10.43.96.5   5.0         BOOTP.Fingerprint  128,Req,"53,77,61,50,12,60,55","1,15,3,6,44,46,47,31,33,43"             1
00:c0:4f:8c:c6:15  10.43.97.8   5.0         BOOTP.Fingerprint  128,Req,"53,61,50,12,81,60,55","1,15,3,6,44,46,47,31,33,43"             3
00:01:02:15:ac:73  10.43.97.63  5.0         BOOTP.Fingerprint  128,Inf,"53,61,12,60,55","1,15,3,6,44,46,47,31,33,43,252"               3
00:c0:4f:8c:c6:15  10.43.97.8   5.0         BOOTP.Fingerprint  128,Dis,"53,251,61,12,60,55","1,15,3,6,44,46,47,31,33,43"               1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,6,3,15","ã                               1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,81,15,3,6",""                                1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,81,15,3,6",""                                 1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Off,"53,1,58,59,51,54,6,15,3",""                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Off,"53,1,58,59,51,54,3,15,6",""                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Off,"53,1,58,59,51,54,15,3,6",""                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,6,3,15",""                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,6,3,15","                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,6,15,3",""                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,3,15,6",""                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,15,3,6",""                                   1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Off,"53,1,58,59,51,54,15,3,6",""                                    1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,6,3,15",""                                    1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,58,59,51,54,1,15,3,6",""                                    1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,54,1,15,3,6",""                                            1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,54,1,15,3,6",""                                             1
00:0f:1f:66:5f:78  10.43.97.3   5.2         BOOTP.Fingerprint  128,Inf,"53,61,12,55","3"                                               2
00:0f:1f:66:5f:78  10.43.97.3   5.1         BOOTP.Fingerprint  128,Inf,"53,61,12,55","3"                                               1
00:0b:db:d6:e1:c4  10.43.99.5   5.1         BOOTP.Fingerprint  128,Rel,"53,54,61",""                                                  1
00:0f:1f:69:f0:2a  10.43.96.7   5.2         BOOTP.Fingerprint  128,Ack,"53,54,1,3",""                                                  1
00:0b:db:e7:9a:c4  10.43.96.5   5.0         BOOTP.Fingerprint  128,Rel,"53,54,61",""                                                   1
00:0b:db:d6:e1:c4  10.43.99.5   5.1         BOOTP.Fingerprint  128,Rel,"53,54,61",""                                                   1

