query-7f8c625b0e76c22a3337a36f692a5674
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?property ?propertyLabel ?count WHERE
{
{
SELECT ?property (count(?predicate) as ?count) WHERE {
SERVICE bd:slice {
?item wdt:P31 ?w.
bd:serviceParam bd:slice.offset 0 . # Start at item number (not to be confused with QID)
bd:serviceParam bd:slice.limit 50000 . # List this many items
}
{
?item ?predicate ?object .
?property wikibase:claim ?predicate. }
} group by ?property } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
filter not exists {?property rdfs:label ?propertyLabel_cy . filter(lang(?propertyLabel_cy)="cy") }
} ORDER BY DESC(?count) limit 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?count"):::projected
v4("?item")
v7("?object")
v6("?predicate")
v3("?property"):::projected
v2("?propertyLabel_cy")
v5("?w")
c7(["0^^xsd:integer"]):::literal
c5(["bd:serviceParam"]):::iri
c9(["50000^^xsd:integer"]):::literal
c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0f0[["?propertyLabel_cy = 'cy'"]]
e0f0 --> e0v1
e0v2 --"rdfs:label"--> e0v1
e0v2("?property"):::projected
e0v1("?propertyLabel_cy"):::projected
end
f0--EXISTS--> f0e0
f0 --> v2
f0 --> v3
f0 --> c2
f1[["?propertyLabel_cy = 'cy'"]]
f1 --> v2
v3 --"rdfs:label"--> v2
subgraph s1["http://www.bigdata.com/rdf#slice"]
style s1 stroke-width:4px;
v4 --"wdt:P31"--> v5
c5 --"bd:slice.offset"--> c7
c5 --"bd:slice.limit"--> c9
end
v4 -->v6--> v7
v3 --"wikibase:claim"--> v6
bind3[/"count(?predicate)"/]
v6 --o bind3
bind3 --as--o v8
subgraph s2["http://wikiba.se/ontology#label"]
style s2 stroke-width:4px;
c5 --"wikibase:language"--> c13
end