| skipped 21 lines |
22 | 22 | | CREATE VIEW IF NOT EXISTS HandshakeAPUnique AS |
23 | 23 | | SELECT Handshake.bssid, AP.ssid, Handshake.mac, Client.manuf, Handshake.file, Handshake.hashcat |
24 | 24 | | FROM Handshake JOIN AP ON Handshake.bssid = AP.bssid JOIN Client ON Handshake.mac = Client.mac |
25 | | - | GROUP BY AP.ssid ORDER BY Handshake.bssid; |
| 25 | + | WHERE hashcat != '' GROUP BY AP.ssid ORDER BY Handshake.bssid; |
26 | 26 | | |
27 | 27 | | CREATE VIEW IF NOT EXISTS IdentityAP AS |
28 | 28 | | SELECT Identity.bssid, AP.ssid, Identity.mac, Client.manuf, Identity.identity |
| skipped 3 lines |