query-15c9a24da19d3e175c85eda0d7ca4413
title:Count by prefix SELECT ?pref (COUNT(?item) AS ?n) WHERE { ?item wdt:P691 ?nkc . BIND(REPLACE(STR(?nkc), "^([a-z]*)\d+$", "$1") AS ?pref) } GROUP BY ?pref ORDER BY DESC(?n)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
#title:Count by prefix
SELECT ?pref (COUNT(?item) AS ?n)
WHERE {
?item wdt:P691 ?nkc .
BIND(REPLACE(STR(?nkc), "^([a-z]*)\\d+$", "$1") AS ?pref)
}
GROUP BY ?pref
ORDER BY DESC(?n)
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v5("?n")
v3("?nkc")
v4("?pref"):::projected
v2 --"wdt:P691"--> v3
bind0[/"replace(str(?nkc),'^(#91;a-z#93;*)\d+$','$1')"/]
v3 --o bind0
bind0 --as--o v4
bind2[/"count(?item)"/]
v2 --o bind2
bind2 --as--o v5