@prefix this: . @prefix sub: . @prefix np: . @prefix dct: . @prefix nt: . @prefix npx: . @prefix xsd: . @prefix rdfs: . @prefix orcid: . @prefix prov: . @prefix foaf: . sub:Head { this: a np:Nanopublication; np:hasAssertion sub:assertion; np:hasProvenance sub:provenance; np:hasPublicationInfo sub:pubinfo . } sub:assertion { sub:get-non-approved-users a ; dct:description "Returns all users that have published a self-introduction but have no approved (trust-state-loaded) account, with their display name and latest introduction nanopublication, ordered by the date of that latest introduction (newest first)."; dct:license ; rdfs:label "❓ Non-Approved Users"; ; """prefix np: prefix npx: prefix npa: prefix foaf: select ?user_iri (sample(?name) as ?user_iri_label) (iri(strafter(max(concat(str(?date), \" \", str(?intronp))), \" \")) as ?approve_target) where { graph npa:graph { ?intronp npa:hasValidSignatureForPublicKey ?pk ; np:hasAssertion ?a ; ?date . filter not exists { ?x npx:invalidates ?intronp ; npa:hasValidSignatureForPublicKey ?pk . } } graph ?a { ?kd npx:declaredBy ?user_iri . optional { ?user_iri foaf:name ?name } } minus { service { graph npa:graph { npa:thisRepo npa:hasCurrentTrustState ?g . } graph ?g { ?acct npa:agent ?user_iri ; npa:trustStatus npa:loaded . } } } } group by ?user_iri order by desc(max(?date))""" . } sub:provenance { sub:assertion prov:wasAttributedTo orcid:0000-0002-1267-0234 . } sub:pubinfo { orcid:0000-0002-1267-0234 foaf:name "Tobias Kuhn" . this: dct:created "2026-08-13T06:30:15Z"^^xsd:dateTime; dct:creator orcid:0000-0002-1267-0234; dct:license ; npx:introduces sub:get-non-approved-users; npx:supersedes ; nt:wasCreatedFromProvenanceTemplate ; nt:wasCreatedFromPubinfoTemplate , , ; nt:wasCreatedFromTemplate . sub:sig npx:hasAlgorithm "RSA"; npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB"; npx:hasSignature "RtEacQZE424zfyoAMoafcR4Jgc/5Oxred2NxiX3xHl6IyvLg9EUPybgwKCClUYdHqNJRnbuxXpPAimKvYGy3FjM5loU0XlOTqXnAj65z/kUTFqtuchK0VZD1CM6RBCDTbRy7l/96aHPWkrkjenHy7WUZwK39UpgvHPw4fShRCA4="; npx:hasSignatureTarget this:; npx:signedBy orcid:0000-0002-1267-0234 . }