https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#Head https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#assertion https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#provenance https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#pubinfo https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#assertion https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid 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/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid http://purl.org/dc/terms/license http://www.apache.org/licenses/LICENSE-2.0 https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid http://www.w3.org/2000/01/rdf-schema#label Get some general user statistics https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/meta https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid 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 { 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/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#provenance https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#pubinfo https://orcid.org/0000-0002-1267-0234 http://xmlns.com/foaf/0.1/name Tobias Kuhn https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#sig http://purl.org/nanopub/x/hasPublicKey MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#sig http://purl.org/nanopub/x/hasSignature L3waFYv2e7v7nZnJKEFDlsffil2ZWMRK8MUmuk9nvfR+gn2pu3lUWeXjzZs+UTS6Dl9KR5lXh3oc1UFRDNrCdGjqYGa/OUMw+FTjCNCcP3eqkXW8EcY73qsarHSVh0q4IPnTRJ4QDAiMdVhA6MOKnUUewD3YeD1nG3/5huDZK6Y= https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#sig http://purl.org/nanopub/x/signedBy https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://purl.org/dc/terms/created 2024-09-23T10:32:50.049Z https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://purl.org/dc/terms/creator https://orcid.org/0000-0002-1267-0234 https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://purl.org/nanopub/x/introduces https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#get-user-stats-from-userid https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck http://purl.org/nanopub/x/wasCreatedAt https://nanodash.knowledgepixels.com/ https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate http://purl.org/np/RANwQa4ICWS5SOjw7gp99nBpXBasapwtZF1fIM3H2gYTM https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate http://purl.org/np/RAA2MfqdBCzmz9yVWjKLXNbyfBNcwsMmOqcNUxkk1maIM https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate http://purl.org/np/RAh1gm83JiG5M6kDxXhaYT1l49nCzyrckMvTzcPn-iv90 https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAYvkQOT9-zrcql5lzMW9OpiPjA9UvSh-RezaVwYmWvns