https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#Head https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#assertion https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#provenance https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#pubinfo https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#assertion https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#get-user-stats http://purl.org/dc/terms/description This query returns some general user statistics in the form of number of valid/invalidated/accepted nanopublications published. https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#get-user-stats http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#get-user-stats http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#get-user-stats http://www.w3.org/2000/01/rdf-schema#label Get some general user statistics https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#get-user-stats https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/empty https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#get-user-stats https://w3id.org/kpxl/grlc/sparql 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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix pav: <http://purl.org/pav/> select ?key ?value where { { select ?key (count(?np) as ?value) where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(if(?__pubkeyhashes = "", ?unbound, ?__pubkeyhashes) as ?vs) # <- VAR __pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) bind(if(bound(?pkh), ?pubkeyservice, <https://w3id.org/np/l/nanopub-query-1.1/repo/meta>) as ?service) service ?service { select distinct ?np ?invalidated { optional { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:creator ?_userid_iri . bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } as ?invalidated ) } } } } bind(if(?invalidated,"invalidatedNpCount","validNpCount") as ?key) values ?key { "invalidatedNpCount" "validNpCount" } } group by ?key ?invalidated } union { select ?key (sum(?npcount) as ?value) where { bind("acceptedNpCount" as ?key) optional { <x:> <x:> ?_userid_iri } # ensure grlc is picking up the placeholder values ?npType { <https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> <https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> <https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { select (count(distinct ?np) as ?npcount) where { optional { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasPublicationInfo ?i . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } { { graph ?i { ?np pav:authoredBy ?_userid_iri . } } union { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?_userid_iri . filter(strstarts(str(?hasElement), str(rdf:_))) } } } } } group by ?np } } group by ?key } } order by ?key https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#provenance https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#sig http://purl.org/nanopub/x/hasSignature NAieYIehuEzomkcN+PD40SsNYpZ7V4F8OwXMfM09B5kkquDGupoKvj8YYvH+wmJvwYEU0Jr1ijHOiZRTFDDZHGjzr+P1I2gp5ZV7eJe+q0TZ0x3N+hS5/4PUKhHax2bsC4FnN9fdCAGkxDxv+d4pbyMZJGEuDL0dlSr2agceFPQ= https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://purl.org/dc/terms/created 2024-09-13T12:46:38.988Z https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://purl.org/nanopub/x/introduces https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw#get-user-stats https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://purl.org/nanopub/x/supersedes https://w3id.org/np/RA-D7swMxOemxAf47A6ctL3VL1ueFUPbuZsJd155LgN1w https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw http://purl.org/nanopub/x/wasCreatedAt https://nanodash.knowledgepixels.com/ https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate http://purl.org/np/RANwQa4ICWS5SOjw7gp99nBpXBasapwtZF1fIM3H2gYTM https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate http://purl.org/np/RAA2MfqdBCzmz9yVWjKLXNbyfBNcwsMmOqcNUxkk1maIM https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate http://purl.org/np/RAh1gm83JiG5M6kDxXhaYT1l49nCzyrckMvTzcPn-iv90 https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate http://purl.org/np/RAjpBMlw3owYhJUBo3DtsuDlXsNAJ8cnGeWAutDVjuAuI https://w3id.org/np/RAIDPR_KLFyiJ7eCLFxxljGVOaRui3p-RLzx2pH7nZ1Pw https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAYvkQOT9-zrcql5lzMW9OpiPjA9UvSh-RezaVwYmWvns