query-c42e70e00e64792fe9f1bc2a1f32fda5

rq turtle/ttl

title:Count all properties used with a defined value SELECT ?prop ?propLabel (COUNT(?item) AS ?n) WHERE { ?item ?p wd:Q25339110 . ?prop wikibase:directClaim ?p . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?prop ?propLabel ORDER BY DESC(?n)

Use at

https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Count all properties used with a defined value
SELECT ?prop ?propLabel (COUNT(?item) AS ?n)
WHERE {
  ?item ?p wd:Q25339110 .
  ?prop wikibase:directClaim ?p .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?prop ?propLabel
ORDER BY DESC(?n)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v5("?n") v3("?p") v4("?prop"):::projected c4(["bd:serviceParam"]):::iri c1(["wd:Q25339110"]):::iri c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 -->v3--> c1 v4 --"wikibase:directClaim"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end bind1[/"count(?item)"/] v2 --o bind1 bind1 --as--o v5