Event JSON
{
"id": "91af741c66a59b149fa1db2615e5b9e23d39dd3cf310552cdbd83e9f538cc862",
"pubkey": "01b564093b88a80fa5269f27044e1dea1d832f56f9b40f2064a6ba39506f27e2",
"created_at": 1710876097,
"kind": 1,
"tags": [
[
"p",
"99648d4aea21d705a28720652805e1ade1c45b211f5d52cc88cb4d58bfa31ee2",
"wss://relay.mostr.pub"
],
[
"p",
"5ef17752b874f50078060449ba4c300edaa2c94bd05c70e2fb8afbec1deed441",
"wss://relay.mostr.pub"
],
[
"p",
"2bfa1b1afdf04720acb10de437f19123d2db3c0012aa3c44cab0bc6259056cad",
"wss://relay.mostr.pub"
],
[
"p",
"e3e11bab8bb77d0f26287ef854311adaf5830f2891e1b9d355f55345cfc4a013",
"wss://relay.mostr.pub"
],
[
"e",
"0d3ba53fce6f892b2d51a740dd59aa85d04b90b7cb6b4bf6a2ae300e56668379",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://podcastindex.social/users/dave/statuses/112123975918919221",
"activitypub"
]
],
"content": "nostr:npub1n9jg6jh2y8tstg58ypjjsp0p4hsugkepraw49nygedx430arrm3qpfnza0 nostr:npub1tmchw54cwn6sq7qxq3ym5npspmd29j2t6pw8pchm3ta7c80w63qspczavv I think I see what the issue is. It's a problematic LEFT JOIN in the SQL. A many to one issue that is getting handled properly in the followup code but is hard to account for in the call itself when it comes to how to LIMIT the result set from SQL.",
"sig": "30a9d9b74fcdf31147599fe9f032aa05a003ee89c3513d03deea577b331d64839a6394fe31e68b2c49ff3fe8a9bf4555042eb9807bbbea0e005e44be49b2dd5c"
}