mirror of
https://seed.radicle.dev/rad:z254T5p17bdFPmzfDojsdjo4HjpoZ.git
synced 2026-10-31 17:00:47 +08:00
14 lines
282 B
SQL
14 lines
282 B
SQL
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 |