monlovesmango on Nostr: settings > dev tools, choose sql query and use this search: SELECT n.event FROM ...
settings > dev tools, choose sql query and use this search:
SELECT n.event FROM nostr_events e
left join nostr n on e.id = n.id
where kind = 0
and pubkey = '3f770d65d3a764a9c5cb503ae123e62ec7598ad035d836e2a810f3877a745b24';
Published at
2023-01-27 23:07:39Event JSON
{
"id": "771e570dd8a5875f068284ed3efb4e0b5890fcf26edd6155082cdc611829c994",
"pubkey": "8c0da4862130283ff9e67d889df264177a508974e2feb96de139804ea66d6168",
"created_at": 1674860859,
"kind": 1,
"tags": [
[
"p",
"fa984bd7dbb282f07e16e7ae87b26a2a7b9b90b7246a44771f0cf5ae58018f52"
],
[
"p",
"3f770d65d3a764a9c5cb503ae123e62ec7598ad035d836e2a810f3877a745b24",
"wss://nostr-pub.wellorder.net"
],
[
"e",
"af6f2512a5aea7ebc77e351678ea31e1f2bcbf32d127862b560cd939b14936a8",
"wss://nostr.fmt.wiz.biz",
"root"
],
[
"e",
"1f17a84091bee0457b758a541908fce4861f668199671e8ab8a44fc6325609b2",
"wss://nostr-pub.semisol.dev",
"reply"
]
],
"content": "settings \u003e dev tools, choose sql query and use this search:\nSELECT n.event FROM nostr_events e\nleft join nostr n on e.id = n.id\nwhere kind = 0\nand pubkey = '3f770d65d3a764a9c5cb503ae123e62ec7598ad035d836e2a810f3877a745b24';",
"sig": "13b3a97f738a5b20ccc19f3658339eb43cd7ef443affd02be940445b1fe9bc2e59e8f04c0af772f92772c7fc66635b7019710512d4aef7bfe55048b0ce73b056"
}
