sub:assertion {
  sub:get-all-user-intros dct:description "This query returns all user IDs, introductions, and associated pubkeys." ;
    dct:license <http://www.apache.org/licenses/LICENSE-2.0> ;
    a <https://w3id.org/kpxl/grlc/grlc-query> ;
    rdfs:label "Get all user intros" ;
    <https://w3id.org/kpxl/grlc/endpoint> <https://w3id.org/np/l/nanopub-query-1.1/repo/type/77757cabf6184c51c20b8b0fe5dc5e1365b7f628448335184ad54319a0affdfc> ;
    <https://w3id.org/kpxl/grlc/sparql> """prefix np: <http://www.nanopub.org/nschema#>
prefix npx: <http://purl.org/nanopub/x/>
prefix npa: <http://purl.org/nanopub/admin/>
prefix dct: <http://purl.org/dc/terms/>
prefix foaf: <http://xmlns.com/foaf/0.1/>

select ?user ?name ?intronp ?date ?pubkey ?pubkeyHash ?authoritative ?keyLocation where {
  graph npa:graph {
    ?intronp npa:hasValidSignatureForPublicKey ?introPubkey .
    filter not exists { ?intronpx npx:invalidates ?intronp ; npa:hasValidSignatureForPublicKey ?introPubkey . }
    ?intronp dct:created ?date .
    ?intronp np:hasAssertion ?a .
  }
  graph ?a {
    ?keydeclaration npx:declaredBy ?user .
    ?keydeclaration npx:hasPublicKey ?pubkey .
    optional {
      ?user foaf:name ?name .
    }
    optional {
      ?keydeclaration npx:hasKeyLocation ?keyLocation .
    }
  }
  bind(?pubkey = ?introPubkey as ?authoritative)
  bind(sha256(?pubkey) as ?pubkeyHash)
}
order by ?user desc(?authoritative) desc(?date)""" .
}