rows {
  options {
    physical_type: PHYSICAL_STREAM_TYPE_QUADS
    max_name_table_size: 128
    max_prefix_table_size: 16
    max_datatype_table_size: 16
    logical_type: LOGICAL_STREAM_TYPE_DATASETS
    version: 2
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/"
  }
}
rows {
  name {
    value: "RA0z2ybDd78hG_Y7UNnDmrUTJS0zHKrdOI_NqrNkhzrxw"
  }
}
rows {
  namespace {
    name: "this"
    value {
      prefix_id: 1
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/RA0z2ybDd78hG_Y7UNnDmrUTJS0zHKrdOI_NqrNkhzrxw/"
  }
}
rows {
  name {
  }
}
rows {
  namespace {
    name: "sub"
    value {
      prefix_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.nanopub.org/nschema#"
  }
}
rows {
  namespace {
    name: "np"
    value {
      prefix_id: 3
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/dc/terms/"
  }
}
rows {
  namespace {
    name: "dct"
    value {
      prefix_id: 4
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  namespace {
    name: "nt"
    value {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/nanopub/x/"
  }
}
rows {
  namespace {
    name: "npx"
    value {
      prefix_id: 6
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2001/XMLSchema#"
  }
}
rows {
  namespace {
    name: "xsd"
    value {
      prefix_id: 7
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2000/01/rdf-schema#"
  }
}
rows {
  namespace {
    name: "rdfs"
    value {
      prefix_id: 8
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://orcid.org/"
  }
}
rows {
  namespace {
    name: "orcid"
    value {
      prefix_id: 9
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/ns/prov#"
  }
}
rows {
  namespace {
    name: "prov"
    value {
      prefix_id: 10
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://xmlns.com/foaf/0.1/"
  }
}
rows {
  namespace {
    name: "foaf"
    value {
      prefix_id: 11
      name_id: 2
    }
  }
}
rows {
  name {
    value: "hasAssertion"
  }
}
rows {
  name {
    value: "assertion"
  }
}
rows {
  name {
    value: "Head"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 1
      name_id: 1
    }
    p_iri {
      prefix_id: 3
      name_id: 3
    }
    o_iri {
      prefix_id: 2
    }
    g_iri {
    }
  }
}
rows {
  name {
    value: "hasProvenance"
  }
}
rows {
  name {
    value: "provenance"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 3
    }
    o_iri {
      prefix_id: 2
    }
  }
}
rows {
  name {
    value: "hasPublicationInfo"
  }
}
rows {
  name {
    value: "pubinfo"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 3
    }
    o_iri {
      prefix_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  }
}
rows {
  name {
    value: "type"
  }
}
rows {
  name {
    value: "Nanopublication"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 12
    }
    o_iri {
      prefix_id: 3
    }
  }
}
rows {
  name {
    value: "get-3pff-events-for-user"
  }
}
rows {
  name {
    value: "description"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 4
    }
    o_literal {
      lex: "Returns all 3PFF events for a given user, including the role they had in each event."
    }
    g_iri {
      prefix_id: 2
      name_id: 4
    }
  }
}
rows {
  name {
    value: "license"
  }
}
rows {
  prefix {
    value: "http://www.apache.org/licenses/"
  }
}
rows {
  name {
    value: "LICENSE-2.0"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 13
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/kpxl/grlc/"
  }
}
rows {
  name {
    value: "grlc-query"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 12
      name_id: 10
    }
    o_iri {
      prefix_id: 14
      name_id: 16
    }
  }
}
rows {
  name {
    value: "label"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 8
    }
    o_literal {
      lex: "Get 3PFF events for user"
    }
  }
}
rows {
  name {
    value: "endpoint"
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/l/nanopub-query-1.1/repo/"
  }
}
rows {
  name {
    value: "full"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 14
    }
    o_iri {
      prefix_id: 15
    }
  }
}
rows {
  name {
    value: "sparql"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 14
    }
    o_literal {
      lex: "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nprefix np: <http://www.nanopub.org/nschema#>\r\nprefix npa: <http://purl.org/nanopub/admin/>\r\nprefix npx: <http://purl.org/nanopub/x/>\r\nprefix dct: <http://purl.org/dc/terms/>\r\nprefix tpff: <https://w3id.org/fair/3pff/>\r\nprefix schema: <http://schema.org/>\r\n\r\nselect ?event ?event_label (sample(?ev_name) as ?event_name) (sample(?ev_date) as ?event_date) ?roles_multi_iri ?roles_label_multi ?np_multi_iri ?np_label_multi where {\r\n  {\r\n    select ?event (replace(str(?event), \"^.*/\", \"\") as ?event_label) (group_concat(str(?role); separator=\" \") as ?roles_multi_iri) (group_concat(?role_label; separator=\"\\n\") as ?roles_label_multi) (group_concat(str(?latest_np); separator=\" \") as ?np_multi_iri) (group_concat(\"^\"; separator=\"\\n\") as ?np_label_multi) where {\r\n      {\r\n        select ?event ?role ?role_label (sample(?np) as ?latest_np) where {\r\n          values (?role ?role_label) {\r\n            (tpff:participatedAsParticipantIn \"Participant\")\r\n            (tpff:participatedAsFacilitatorIn \"Facilitator\")\r\n            (tpff:participatedAsTrainerIn \"Trainer\")\r\n            (tpff:participatedAsFacilitatorAssistantIn \"Facilitator Assistant\")\r\n            (tpff:participatedAsTrainerAssistantIn \"Trainer Assistant\")\r\n            (tpff:participatedAsImplementerIn \"Implementer\")\r\n            (tpff:participatedAsImplementerAspirantIn \"Implementer Aspirant\")\r\n          }\r\n          graph npa:graph {\r\n            ?np npx:hasNanopubType ?role .\r\n            ?np dct:creator ?_user_iri .\r\n            ?np npa:hasValidSignatureForPublicKeyHash ?pk .\r\n            filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pk . }\r\n            ?np np:hasAssertion ?a .\r\n            ?np dct:created ?date .\r\n          }\r\n          graph ?a {\r\n            ?_user_iri ?role ?event .\r\n          }\r\n          filter not exists {\r\n            graph npa:graph {\r\n              ?np2 npx:hasNanopubType ?role .\r\n              ?np2 dct:creator ?_user_iri .\r\n              ?np2 npa:hasValidSignatureForPublicKeyHash ?pk2 .\r\n              filter not exists { ?npx2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pk2 . }\r\n              ?np2 np:hasAssertion ?a2 .\r\n              ?np2 dct:created ?date2 .\r\n              filter(?date2 > ?date)\r\n            }\r\n            graph ?a2 {\r\n              ?_user_iri ?role ?event .\r\n            }\r\n          }\r\n        }\r\n        group by ?event ?role ?role_label\r\n      }\r\n    }\r\n    group by ?event\r\n  }\r\n  graph npa:graph {\r\n    ?enp npx:introduces ?event .\r\n    ?enp npa:hasValidSignatureForPublicKeyHash ?epk .\r\n    filter not exists { ?enpx npx:invalidates ?enp ; npa:hasValidSignatureForPublicKeyHash ?epk . }\r\n    ?enp np:hasAssertion ?ea .\r\n  }\r\n  graph ?ea {\r\n    ?event a tpff:3PFF-event .\r\n    ?event rdfs:label ?ename .\r\n    optional { ?event dct:date ?dateDct . }\r\n    optional { ?event schema:startDate ?dateSchema . }\r\n  }\r\n  bind(coalesce(?dateDct, strBefore(str(?dateSchema), \"T\")) as ?ev_date)\r\n  bind(replace(?ename, \"^[^|]*\\\\| ?\", \"\") as ?ev_name)\r\n}\r\ngroup by ?event ?event_label ?roles_multi_iri ?roles_label_multi ?np_multi_iri ?np_label_multi\r\norder by desc(sample(?ev_date))"
    }
  }
}
rows {
  name {
    value: "wasAttributedTo"
  }
}
rows {
  name {
    value: "0000-0002-1267-0234"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
      name_id: 4
    }
    p_iri {
      prefix_id: 10
      name_id: 21
    }
    o_iri {
      prefix_id: 9
    }
    g_iri {
      prefix_id: 2
      name_id: 7
    }
  }
}
rows {
  name {
    value: "name"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 9
      name_id: 22
    }
    p_iri {
      prefix_id: 11
    }
    o_literal {
      lex: "Tobias Kuhn"
    }
    g_iri {
      prefix_id: 2
      name_id: 9
    }
  }
}
rows {
  name {
    value: "created"
  }
}
rows {
  datatype {
    value: "http://www.w3.org/2001/XMLSchema#dateTime"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 1
      name_id: 1
    }
    p_iri {
      prefix_id: 4
      name_id: 24
    }
    o_literal {
      lex: "2026-04-07T16:27:22.879+02:00"
      datatype: 1
    }
  }
}
rows {
  name {
    value: "creator"
  }
}
rows {
  quad {
    p_iri {
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}
rows {
  prefix {
    value: "https://creativecommons.org/licenses/by/4.0/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 16
      name_id: 2
    }
  }
}
rows {
  name {
    value: "embeds"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 26
    }
    o_iri {
      prefix_id: 2
      name_id: 12
    }
  }
}
rows {
  name {
    value: "supersedes"
  }
}
rows {
  name {
    value: "RA4J4IoZuEBRPiNqT-LHuu0U3p5Hwzrw7i-10okl_6uzE"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 27
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "wasCreatedAt"
  }
}
rows {
  prefix {
    id: 5
    value: "http://localhost:37373/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
    }
    o_iri {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 7
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  name {
    value: "wasCreatedFromProvenanceTemplate"
  }
}
rows {
  name {
    value: "RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 7
      name_id: 30
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "wasCreatedFromPubinfoTemplate"
  }
}
rows {
  name {
    value: "RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 7
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw"
  }
}
rows {
  quad {
    o_iri {
    }
  }
}
rows {
  name {
    value: "RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI"
  }
}
rows {
  quad {
    o_iri {
    }
  }
}
rows {
  name {
    value: "wasCreatedFromTemplate"
  }
}
rows {
  name {
    value: "RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 7
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "sig"
  }
}
rows {
  name {
    value: "hasAlgorithm"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 6
    }
    o_literal {
      lex: "RSA"
    }
  }
}
rows {
  name {
    value: "hasPublicKey"
  }
}
rows {
  quad {
    p_iri {
    }
    o_literal {
      lex: "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB"
    }
  }
}
rows {
  name {
    value: "hasSignature"
  }
}
rows {
  quad {
    p_iri {
    }
    o_literal {
      lex: "Rv23ka6Iap2ZlUrqxYkpBJsJ7LlYxqIOsgD9FeOMBuQXvGolJgdJZ53PVuEQ04xzA/YMVT1p6ClhShdBiC3agelhbW421GsrQ6lXK4BGcOi2U8bV/p6Fv1GghYa44q/AK4O7KLq3y4rvO2xpycAEHuEbb+jK89CMzMUz5i7OHe8="
    }
  }
}
rows {
  name {
    value: "hasSignatureTarget"
  }
}
rows {
  quad {
    p_iri {
    }
    o_iri {
      prefix_id: 1
      name_id: 1
    }
  }
}
rows {
  name {
    value: "signedBy"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 43
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}