. . . . "Returns the introduction nanopublications of a given user (creation date, key location, declared public-key hashes), plus session-relative flags from the viewer's local key (?__LOCALPUBKEY_multi): whether each intro declares it and conditional retract/derive targets driving the per-row actions." . . . "Get user introductions" . . "prefix np: \nprefix npx: \nprefix npa: \nprefix dct: \n\nselect (max(?date0) as ?date) (sample(str(?keyLocation)) as ?location)\n (group_concat(distinct ?keyHash; separator=\", \") as ?keys) ?np (\"^\" as ?np_label)\n (if(sum(?isLocal) > 0, \"true\", \"\") as ?declares_local_key)\n (if(sum(?isLocal) > 0 && ?localCount > 1, str(?np), \"\") as ?retract_target)\n (if(sum(?isLocal) = 0 && ?localCount = 0 && max(?lpkBound) > 0, str(?np), \"\") as ?derive_target)\nwhere {\n values ?__LOCALPUBKEY_multi {}\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKey ?introPubkey .\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?introPubkey . }\n ?np dct:created ?date0 .\n ?np np:hasAssertion ?a .\n }\n graph ?a {\n ?keydeclaration npx:declaredBy ?_user_iri .\n ?keydeclaration npx:hasPublicKey ?pubkey .\n optional { ?keydeclaration npx:hasKeyLocation ?keyLocation . }\n bind(substr(sha256(?pubkey), 1, 10) as ?keyHash)\n }\n bind(coalesce(if(str(?pubkey) = str(?__LOCALPUBKEY_multi), 1, 0), 0) as ?isLocal)\n bind(if(bound(?__LOCALPUBKEY_multi), 1, 0) as ?lpkBound)\n {\n select (count(distinct ?lnp) as ?localCount) where {\n values ?__LOCALPUBKEY_multi {}\n graph npa:graph {\n ?lnp npa:hasValidSignatureForPublicKey ?lk2 .\n filter not exists { ?lnpx npx:invalidates ?lnp ; npa:hasValidSignatureForPublicKey ?lk2 . }\n ?lnp np:hasAssertion ?la .\n }\n graph ?la { ?lkd npx:declaredBy ?_user_iri ; npx:hasPublicKey ?lpubkey . }\n filter(coalesce(str(?lpubkey) = str(?__LOCALPUBKEY_multi), false))\n }\n }\n}\ngroup by ?np ?localCount\norder by desc(max(?date0))" . . "Tobias Kuhn" . "2026-06-08T15:42:35Z"^^ . . . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "kGthdul1QtCLaYkbhVgQ18oxlL+v7upXveu7axD2Tav19Ou+ehnzRogWdvhLP/6WbGX4H8C3RR7DKbXiLlPE2yzapmxZzzmUX9WDsvtGeEoQ7PP67xCfNpW6HXGzB83XDmfQVNhTTcfom4/6Jzjh41rQCiG2m0GTVMbbtDrNVV4=" . . .