mirror of
https://github.com/lalanza808/monero.fail.git
synced 2026-01-17 07:39:03 -05:00
12 lines
590 B
Text
12 lines
590 B
Text
SELECT
|
|
strftime('%s', datetime_entered) AS time,
|
|
|
|
-- Cumulative counts
|
|
COUNT(*) FILTER (WHERE is_tor = 1) OVER (ORDER BY datetime_entered) AS "Tor",
|
|
COUNT(*) FILTER (WHERE is_i2p = 1) OVER (ORDER BY datetime_entered) AS "I2P",
|
|
COUNT(*) FILTER (WHERE web_compatible = 1) OVER (ORDER BY datetime_entered) AS "Web-compatible",
|
|
COUNT(*) FILTER (WHERE is_tor = 0 AND is_i2p = 0 AND web_compatible = 0) OVER (ORDER BY datetime_entered) AS "Clearnet"
|
|
|
|
FROM node
|
|
WHERE datetime_entered >= '2023-01-01' -- optional static range, or just remove
|
|
ORDER BY datetime_entered;
|