DELETE FROM `subnets` WHERE subnet='10.0.0.0/8' AND free=1; DELETE FROM `subnets` WHERE subnet='192.168.0.0/16' AND free=1; DELETE FROM `subnets` WHERE subnet='172.16.0.0/12' AND free=1;