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
15DELETE FROM node AS n1 USING (SELECT mac, switch, port from node GROUP BY mac, switch, port HAVING count(*) > 1) n2 WHERE n1.mac = n2.mac AND n1.switch = n2.switch AND n1.port = n2.port AND n1.vlan = '0';
16
17COMMIT;
18