BitcoinJungle on Nostr: select count(distinct author) from event; for nostr-rs-relay
select count(distinct author) from event; for nostr-rs-relay
Published at
2022-12-27 16:17:28Event JSON
{
"id": "da5d002f08fa3fb4e7d2b4ac17dd1520e77cc764f18c3a40de5add1795d6e793",
"pubkey": "aa55a479ad6934d0fd78f3dbd88515cd1ca0d7a110812e711380d59df7598935",
"created_at": 1672157848,
"kind": 1,
"tags": [
[
"e",
"d853f969c3f160f9b475d5ea307d5da30cc0482edc7c53c9ed3586eee713ad29",
"wss://nostr-relay.wlvs.space"
],
[
"e",
"e56927607c12ec2b3e98556242d76f6c5db0afdf53fa884f19f65d95786a66ca"
],
[
"p",
"20abfe8173dbe1e07c26a2dd4cc109e6b4f9c12502ad4ee82428cad50bb6a867"
],
[
"p",
"b2d670de53b27691c0c3400225b65c35a26d06093bcc41f48ffc71e0907f9d4a"
]
],
"content": "select count(distinct author) from event; for nostr-rs-relay",
"sig": "14702b89d78e980a616b471fd3c0d4d1f186bc5d712cc3509a91a97cb371d0fa20543b90f02942c26d22eeca28d0345d996bc1405413285c3825a493cd59b8ed"
}