. . . . "Returns all 3PFF events with participant counts per role (Participants, Facilitators, Trainers, etc.)." . . . "Get 3PFF event participation stats" . . "prefix rdfs: \nprefix np: \nprefix npa: \nprefix npx: \nprefix dct: \nprefix tpff: \nprefix schema: \n\nselect ?event ?event_label (sample(?ev_name) as ?event_name) (sample(?ev_date) as ?event_date) (sum(if(?role = tpff:participatedAsParticipantIn, 1, 0)) as ?Participants) (sum(if(?role = tpff:participatedAsFacilitatorIn, 1, 0)) as ?Facilitators) (sum(if(?role = tpff:participatedAsTrainerIn, 1, 0)) as ?Trainers) (sum(if(?role = tpff:participatedAsFacilitatorAssistantIn, 1, 0)) as ?Facilitator_Assistants) (sum(if(?role = tpff:participatedAsTrainerAssistantIn, 1, 0)) as ?Trainer_Assistants) (sum(if(?role = tpff:participatedAsImplementerIn, 1, 0)) as ?Implementers) (sum(if(?role = tpff:participatedAsImplementerAspirantIn, 1, 0)) as ?Implementer_Aspirants) where {\n {\n select distinct ?event ?role ?user where {\n values ?role {\n tpff:participatedAsParticipantIn\n tpff:participatedAsFacilitatorIn\n tpff:participatedAsTrainerIn\n tpff:participatedAsFacilitatorAssistantIn\n tpff:participatedAsTrainerAssistantIn\n tpff:participatedAsImplementerIn\n tpff:participatedAsImplementerAspirantIn\n }\n graph npa:graph {\n ?np npx:hasNanopubType ?role .\n ?np npa:hasValidSignatureForPublicKeyHash ?pk .\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pk . }\n ?np np:hasAssertion ?a .\n }\n graph ?a {\n ?user ?role ?event .\n }\n }\n }\n graph npa:graph {\n ?enp npx:introduces ?event .\n ?enp npa:hasValidSignatureForPublicKeyHash ?epk .\n filter not exists { ?enpx npx:invalidates ?enp ; npa:hasValidSignatureForPublicKeyHash ?epk . }\n ?enp np:hasAssertion ?ea .\n }\n graph ?ea {\n ?event a tpff:3PFF-event .\n ?event rdfs:label ?ename .\n optional { ?event dct:date ?dateDct . }\n optional { ?event schema:startDate ?dateSchema . }\n }\n bind(replace(str(?event), \"^.*/\", \"\") as ?event_label)\n bind(coalesce(?dateDct, strBefore(str(?dateSchema), \"T\")) as ?ev_date)\n bind(replace(?ename, \"^[^|]*\\\\| ?\", \"\") as ?ev_name)\n}\ngroup by ?event ?event_label\norder by desc(sample(?ev_date))" . . "Tobias Kuhn" . "2026-03-26T11:25:28Z"^^ . . . . "Get 3PFF event participation stats" . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "Ro5l8jywWmGJJNhMtNR/YYz3FnooKvxJLm+vGkeotfq1Kg76YTOAB8wDgO/j97oQDcYRGP1wy0znhAjuLoio565w7Bz+8QXbOHwz8XXvzbu629TTX45UXwnVwb+d93ElOAw2/vJF46Fioew+fBPYIpRHVWFb4vFOpEN3qd1rIBI=" . . .