Yes they are linked already.
My request is: Give me the latest release for each one of these app ids. In SQL that can be done with a self-join I think
franzap
npub1wf…3dgh9
2024-10-11 16:25:05
in reply to nevent1q…vekz
Author Public Key
npub1wf4pufsucer5va8g9p0rj5dnhvfeh6d8w0g6eayaep5dhps6rsgs43dgh9Published at
2024-10-11 16:25:05Event JSON
{
"id": "a73b5ec179f0cbc651defb9b6aa22c97d51c47fec3f758d73c5af3e86aeea1f3",
"pubkey": "726a1e261cc6474674e8285e3951b3bb139be9a773d1acf49dc868db861a1c11",
"created_at": 1728663905,
"kind": 1,
"tags": [
[
"e",
"9cd9af51437d921450f0edb0e7b9485f90823f4c7665f48ff6a93ef950462dd5",
"",
"root"
],
[
"e",
"9b3f6db5e5f8e34d89572d8a38309a59202fa02bfcb5394d001e3993a43b055c",
"",
"reply"
],
[
"p",
"3356de61b39647931ce8b2140b2bab837e0810c0ef515bbe92de0248040b8bdd",
"",
"mention"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c",
"",
"mention"
],
[
"p",
"a9434ee165ed01b286becfc2771ef1705d3537d051b387288898cc00d5c885be",
"",
"mention"
],
[
"p",
"de7ecd1e2976a6adb2ffa5f4db81a7d812c8bb6698aa00dcf1e76adb55efd645",
"",
"mention"
]
],
"content": "Yes they are linked already.\n\nMy request is: Give me the latest release for each one of these app ids. In SQL that can be done with a self-join I think",
"sig": "cf40c7c74bf252834a77a2254be585a3f0537fb9a717303d474b4bf2d0bc16a5a376e3c547fbd0f395b3659bf3d2e9e261564e9baab1dd35ca4478054b178993"
}