select
	                                        node,
	substr(value, 0, instr(value, ':'))  as host,
	substr(value, instr(value, ':') + 1) as port

from
	addresses

where
	banned = false and
	type == 'dns' and
	unixepoch() - (last_success / 1000) < (60 * 60 * 24 * 7)

order by node