r
Radicle
Git
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