Mike McCaffrey on Nostr: This post might have something that works:
This post might have something that works: https://stackoverflow.com/questions/30676761/select-the-latest-3-records-for-each-id-in-a-table
Mike McCaffrey
npub19v…dhana
2025-09-08 16:47:23 UTC
in reply to nevent1q…ax5l
Author Public Key
npub19v49hcl74yh8y3pauhevm2jltyqttn898r4d2dgtge0gnw0j0ulsmdhanaSeen on
wss://relay.momostr.pinkPublished at
2025-09-08 16:47:23 UTCEvent JSON
{
"id": "6aa8832771607e8bc627d7f847ef8f899e2a0a2d313cae6da24b14a1c6abae17",
"pubkey": "2b2a5be3fea92e72443de5f2cdaa5f5900b5cce538ead5350b465e89b9f27f3f",
"created_at": 1757350043,
"kind": 1,
"tags": [
[
"e",
"f7b67bb7a7c2304afdf60c7b10246217f5cb014a280db847204c52c0a9ad0a37",
"",
"root",
"cda55305912981a5600c924b4bfc559d4ac3aad8fa87441dba6e3f39baa437dc"
],
[
"proxy",
"https://drupal.community/@mikemccaffrey/115169692473454338",
"web"
],
[
"p",
"cda55305912981a5600c924b4bfc559d4ac3aad8fa87441dba6e3f39baa437dc"
],
[
"proxy",
"https://drupal.community/users/mikemccaffrey/statuses/115169692473454338",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://drupal.community/users/mikemccaffrey/statuses/115169692473454338",
"pink.momostr"
],
[
"-"
]
],
"content": "This post might have something that works: https://stackoverflow.com/questions/30676761/select-the-latest-3-records-for-each-id-in-a-table",
"sig": "e13009c42d97ceb86e15bf076e20c7873cc63e3df8f0b6d3de09d61ab97a64b0828567ee54305c38c5ef950c37371212e112c5c558640dbc340d8d9c3511336b"
}