Dave on Nostr: This SQL is hard for me. I have very little experience with window functions and rank ...
This SQL is hard for me. I have very little experience with window functions and rank syntax. I've only used that once. Getting there slowly.
Dave /
npub1rc…2dw4h
2024-08-22 04:18:21
in reply to nevent1q…hu9s
Author Public Key
npub1rcnr0tt3mdzn0zkksz2pzhc39rxn90wmt5yqll2y7dgc73vre0asc2dw4hPublished at
2024-08-22 04:18:21Event JSON
{
"id": "3f6442198bf14eb8d37763a2b7f0004558f6d533f5a84c0a02fea770786e1612",
"pubkey": "1e2637ad71db45378ad68094115f1128cd32bddb5d080ffd44f3518f4583cbfb",
"created_at": 1724300301,
"kind": 1,
"tags": [
[
"proxy",
"https://podcastindex.social/@dave/113003744576906619",
"web"
],
[
"p",
"1e2637ad71db45378ad68094115f1128cd32bddb5d080ffd44f3518f4583cbfb"
],
[
"e",
"ad676aba004354a8a8856587b00530c420b4d3919de188999a09302cfde27cbb",
"",
"root",
"1e2637ad71db45378ad68094115f1128cd32bddb5d080ffd44f3518f4583cbfb"
],
[
"proxy",
"https://podcastindex.social/users/dave/statuses/113003744576906619",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://podcastindex.social/users/dave/statuses/113003744576906619",
"pink.momostr"
],
[
"-"
]
],
"content": "This SQL is hard for me. I have very little experience with window functions and rank syntax. I've only used that once. Getting there slowly.",
"sig": "9492c0848ac5ce10e389dc14cbb21a65a1fa7e8030621782deed74cd897b1a97111e798325147fd91d3726df3ca42dfe1f15cae7f61f34d1ace214ff1e52364a"
}