Speed up network device re-registration

SET SESSION group_concat_max_len = 1000000; SELECT GROUP_CONCAT(interface.ip) FROM interface
JOIN hosts ON (hosts.hostid=interface.hostid)
WHERE hosts.status=0 AND interface.main=1 AND interface.type=2
\G

Collect all registred IPs and create another discoveries. Max of 2048 characters can be used.