LibreNMS delete elements without devices

START TRANSACTION;
DELETE FROM alert_log WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM alerts WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM availability WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM bgpPeers WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM bgpPeers_cbgp WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM cef_switching WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM device_graphs WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM hrSystem WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ipv6_nd WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM isis_adjacencies WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM mempools WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ospf_areas WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ospf_instances WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ospf_nbrs WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ospf_ports WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ports WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ports_vlans WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM processors WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM sensors WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM storage WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM transceivers WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM ucd_diskio WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM vlans WHERE device_id NOT IN (SELECT device_id FROM devices);
DELETE FROM vrfs WHERE device_id NOT IN (SELECT device_id FROM devices);
COMMIT;