1-- clean up node table where vlan = 0 and vlan = <another number> 2-- 3-- DELETE n1.* 4-- FROM node n1 INNER JOIN 5-- (SELECT mac, switch, port from node 6-- GROUP BY mac, switch, port 7-- HAVING count(*) > 1) n2 8-- ON n1.mac = n2.mac 9-- AND n1.switch = n2.switch 10-- AND n1.port = n2.port 11-- AND n1.vlan = '0'; 12 13BEGIN; 14 15COMMIT; 16