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