. . . . "Returns the latest 100 users who have introduced themselves, newest first, with their display name, a type column (software agent if declared npx:SoftwareAgent, human if an ORCID, unknown otherwise), a joined column (creation time of their earliest introduction, falling back to its load timestamp when the nanopub carries no dct:created) and a status column marking users whose approval in the trust state is still pending; for those, approve_target holds their current (latest non-invalidated) introduction nanopub." . . . "Get latest users with name and type" . . "prefix np: \nprefix npx: \nprefix npa: \nprefix dct: \nprefix foaf: \n\nselect ?user_iri (sample(?name) as ?user_iri_label) (if(?isBot, \"🤖 software agent\", if(strstarts(str(?user_iri), \"https://orcid.org/\") || strstarts(str(?user_iri), \"http://orcid.org/\"), \"👤 human\", \"❔ unknown\")) as ?type) (str(?mindate) as ?joined) (if(?isApproved, \"\", \"⏳ pending\") as ?status) (if(?isApproved, \"\", strafter(max(concat(str(?introDate), \" \", str(?currentIntro))), \" \")) as ?approve_target) where {\n {\n select ?user_iri (min(?date) as ?mindate) where {\n graph npa:graph {\n ?intronp npa:hasValidSignatureForPublicKey ?introPubkey .\n filter not exists { ?intronpx npx:retracts ?intronp ; npa:hasValidSignatureForPublicKey ?pubkey . }\n ?intronp npa:hasLoadTimestamp ?ldate .\n ?intronp np:hasAssertion ?a .\n }\n optional { graph npa:graph { ?intronp dct:created ?cdate . } }\n bind(coalesce(?cdate, ?ldate) as ?date)\n graph ?a {\n ?keydeclaration npx:declaredBy ?user_iri .\n ?keydeclaration npx:hasPublicKey ?pubkey .\n }\n }\n group by ?user_iri\n order by desc(?mindate)\n limit 100\n }\n {\n select (concat(\" \", group_concat(distinct str(?approvedAgent); separator=\" \"), \" \") as ?approvedAgents) where {\n service {\n graph npa:graph { npa:thisRepo npa:hasCurrentTrustState ?tg . }\n graph ?tg { ?acct npa:agent ?approvedAgent ; npa:trustStatus ?trustStatus . }\n values ?trustStatus { npa:loaded npa:toLoad }\n }\n }\n }\n bind(contains(?approvedAgents, concat(\" \", str(?user_iri), \" \")) as ?isApproved)\n bind(exists { graph ?a2 { ?user_iri a npx:SoftwareAgent } } as ?isBot)\n optional { graph ?a3 { ?kd3 npx:declaredBy ?user_iri . ?user_iri foaf:name ?name } }\n optional {\n graph npa:graph {\n ?currentIntro npa:hasValidSignatureForPublicKey ?currentPubkey ; np:hasAssertion ?a4 ; npa:hasLoadTimestamp ?introLoad .\n filter not exists { ?invalidating npx:invalidates ?currentIntro ; npa:hasValidSignatureForPublicKey ?currentPubkey . }\n }\n optional { graph npa:graph { ?currentIntro dct:created ?introCreated . } }\n bind(coalesce(?introCreated, ?introLoad) as ?introDate)\n graph ?a4 { ?kd4 npx:declaredBy ?user_iri . }\n }\n}\ngroup by ?user_iri ?mindate ?isBot ?isApproved\norder by desc(?mindate)" . . "Tobias Kuhn" . "2026-09-29T05:19:46Z"^^ . . . . . "Get latest users with name and type" . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "idvttZt8zO1f/SFi7P5NiUmfT1eGKo9ck4fK60RhX30A5o5n+dFhU4xYkW5RthQVFkVtvHOoSiF1JTawqNyHNKjJIb4FqynM0ebZALsHKcMLKy0mI03y2POKNfscVpKxirBYyzCRwoiaC5OTXXXmea7yFEstdoI7vWA7vf9/B3M=" . . .