https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#Head https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#assertion https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#provenance https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#pubinfo https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#assertion https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#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/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#get-user-stats http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#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/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#get-user-stats http://www.w3.org/2000/01/rdf-schema#label Get some general user statistics https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#get-user-stats https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/empty https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#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 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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select ?key ?value where { { select ?key (count(?np) as ?value) where { optional { <x:> <x:> ?_pubkeyhashes } # ensure grlc is picking up the placeholder #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?_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 ?service) service ?service { select distinct ?np ?invalidated { optional { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?_pubkeyhashes, sha256(str(?pubkeyx)))) } 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 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/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#provenance https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#sig http://purl.org/nanopub/x/hasSignature ZeoLK1TXhK1lOwhMmkZde6Cnd6c31i379M/GoGCaAijma7qW6SZMsw6o6wE+cJoRpKI5COBsgPiWKXa9QK7QWuKeovWH1uLhHfMOW7PXWUs0FDZbqf3Jlo9iaftWw8biGxOxx1LCs/PsSd39nNc0Pm/TsFjPu0PQtX+HMYKBCBc= https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://purl.org/dc/terms/created 2024-08-14T07:23:55.572Z https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://purl.org/nanopub/x/introduces https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA#get-user-stats https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA http://purl.org/nanopub/x/wasCreatedAt https://nanodash.knowledgepixels.com/ https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate http://purl.org/np/RANwQa4ICWS5SOjw7gp99nBpXBasapwtZF1fIM3H2gYTM https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate http://purl.org/np/RAA2MfqdBCzmz9yVWjKLXNbyfBNcwsMmOqcNUxkk1maIM https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate http://purl.org/np/RAh1gm83JiG5M6kDxXhaYT1l49nCzyrckMvTzcPn-iv90 https://w3id.org/np/RAmP2Ymp-tiIN0IBzHhdzcYoYAoCr1jJtgH03ekFX6rZA https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAYvkQOT9-zrcql5lzMW9OpiPjA9UvSh-RezaVwYmWvns