Returns a list of all events related to the Three Point FAIRification Framework (3PFF), with IRIs output directly (not pre-rendered as HTML). Multi-value organizer/facilitator/more-info columns carry their IRIs alongside a parallel label companion column (organizer and facilitator labels resolved from the trust repository, falling back to the URI's local name). Variant of get-3pff-events-html intended for tabular views that render IRIs and labels natively (e.g. Nanodash). The final 'np' column uses '^' labels to trigger the per-row dropdown menu.
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> prefix tpff: <https://w3id.org/fair/3pff/> prefix schema: <http://schema.org/> select (?event as ?Event_ID) (?eventShortName as ?Event_ID_label) (?eventLongName as ?Event_Name) (?eventDate as ?Date) ?Organizers_multi_iri ?Organizers_label_multi ?Facilitators_multi_iri ?Facilitators_label_multi ?More_Info_multi_iri ?More_Info_label_multi ?np ("^" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . optional { ?event dct:date ?dateDct . } optional { ?event schema:startDate ?dateSchema . } } bind(coalesce(?dateDct, strBefore(str(?dateSchema), "T")) as ?eventDate) bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) optional { select ?event (group_concat(str(?org); separator=" ") as ?Organizers_multi_iri) (group_concat(?orgLabel; separator="\n") as ?Organizers_label_multi) where { select ?event ?org (sample(?orgName) as ?orgLabel) where { graph npa:graph { ?onp npx:introduces ?event ; np:hasAssertion ?oa ; npa:hasValidSignatureForPublicKey ?opk . filter not exists { ?onpx npx:invalidates ?onp ; npa:hasValidSignatureForPublicKey ?opk . } } graph ?oa { ?event a tpff:3PFF-event . ?event tpff:has-event-organizer ?org . } bind(replace(replace(str(?org), "/$", ""), "^.*[/#]", "") as ?orgLocal) optional { service <https://w3id.org/np/l/nanopub-query-1.1/repo/trust> { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentTrustState ?ts . } graph ?ts { ?org foaf:name ?orgFoaf . } } } bind(coalesce(?orgFoaf, ?orgLocal) as ?orgName) } group by ?event ?org } group by ?event } optional { select ?event (group_concat(str(?fac); separator=" ") as ?Facilitators_multi_iri) (group_concat(?facLabel; separator="\n") as ?Facilitators_label_multi) where { select ?event ?fac (sample(?facName) as ?facLabel) where { graph npa:graph { ?fnp npx:introduces ?event ; np:hasAssertion ?fa ; npa:hasValidSignatureForPublicKey ?fpk . filter not exists { ?fnpx npx:invalidates ?fnp ; npa:hasValidSignatureForPublicKey ?fpk . } } graph ?fa { ?event a tpff:3PFF-event . ?event tpff:has-event-facilitator ?fac . } bind(replace(replace(str(?fac), "/$", ""), "^.*[/#]", "") as ?facLocal) optional { service <https://w3id.org/np/l/nanopub-query-1.1/repo/trust> { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentTrustState ?fts . } graph ?fts { ?fac foaf:name ?facFoaf . } } } bind(coalesce(?facFoaf, ?facLocal) as ?facName) } group by ?event ?fac } group by ?event } optional { select ?event (group_concat(str(?link); separator=" ") as ?More_Info_multi_iri) (group_concat(?linkLabel; separator="\n") as ?More_Info_label_multi) where { select ?event ?link (sample(?linkLocal) as ?linkLabel) where { graph npa:graph { ?lnp npx:introduces ?event ; np:hasAssertion ?la ; npa:hasValidSignatureForPublicKey ?lpk . filter not exists { ?lnpx npx:invalidates ?lnp ; npa:hasValidSignatureForPublicKey ?lpk . } } graph ?la { ?event a tpff:3PFF-event . ?event rdfs:seeAlso ?link . } bind(replace(replace(str(?link), "/$", ""), "^.*[/#]", "") as ?linkLocal) } group by ?event ?link } group by ?event } } order by desc(?eventDate)