Server version: 5.5.55-0+deb8u1 (Debian)
I made an account in order not to wait to be moderated mysql> select -> ip.id,ip.ip_addr,ip.lastSeen,ip.subnetId,ip.description,ip.dns_name,ip.lastSeen, -> su.subnet,su.mask,su.sectionId,su.description, -> 'delete' as action -> from -> ipaddresses as ip, subnets as su -> where -> ip.subnetId = su.id -> and su.pingSubnet = 1 -> and ip.excludePing != 1 -> and -> (ip.lastSeen < '2017-06-10 00:00:00' and ip.lastSeen != '0000-00-00 00:00:00' and ip.lastSeen is not NULL); Empty set (0.00 sec) My set is...