. . . . "This query returns an monthly overview of published nanopublications by types for the past 12 months for the given pubkey hashes." . . . "Get type overview of monthly nanopubs by pubkeys" . . "prefix rdfs: \r\nprefix np: \r\nprefix npa: \r\nprefix npx: \r\nprefix xsd: \r\nprefix dct: \r\n\r\nselect ?type ?month ?npCount ?npCountType where {\r\n\r\n\r\n{ select ?type ?month (count(?np) as ?npCount) where {\r\n graph npa:graph {\r\n values ?_pubkey_multi {}\r\n ?np npa:hasValidSignatureForPublicKeyHash ?_pubkey_multi .\r\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?_pubkey_multi . }\r\n ?np dct:created ?date .\r\n ?np npx:hasNanopubType ?type .\r\n\r\n bind(substr(str(?date), 0, 8) as ?month)\r\n bind(now() as ?now)\r\n bind(concat(str(year(?now)), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?lastMonth)\r\n bind(concat(str(year(?now)-1), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?firstMonth)\r\n filter(?month > ?firstMonth && ?month <= ?lastMonth)\r\n }\r\n}\r\ngroup by ?type ?month\r\norder by ?type desc(?month)\r\n}\r\n\r\n{ select ?type (count(?np) as ?npCountType) where {\r\n graph npa:graph {\r\n values ?_pubkey_multi {}\r\n ?np npa:hasValidSignatureForPublicKeyHash ?_pubkey_multi .\r\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?_pubkey_multi . }\r\n ?np dct:created ?date .\r\n ?np npx:hasNanopubType ?type .\r\n\r\n bind(substr(str(?date), 0, 8) as ?month)\r\n bind(now() as ?now)\r\n bind(concat(str(year(?now)), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?lastMonth)\r\n bind(concat(str(year(?now)-1), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?firstMonth)\r\n filter(?month > ?firstMonth && ?month <= ?lastMonth)\r\n }\r\n}\r\ngroup by ?type\r\norder by desc(?npCountType)\r\n}\r\n\r\n}\r\norder by desc(?npCountType) ?type desc(?month)" . . "Tobias Kuhn" . "2025-10-02T07:36:08.194Z"^^ . . . . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB" . "tCkQ/wAjH8Ls0RUhGKhSQp1yspcSjlESQvp6fph5Yd7HP+9nmB+OD8YgSR1sORrF2Nwqy0GofzMZajguwz0mpcT5lXqRWJr8QODZ9jlz5am3fWSi+uudXZGFhphvcoHxPmHxsEy/29q2gtzbTAW5Sb0MlWf8ghQQXc6bjN0oAmI=" . . .