query-100fce71983d2e70f5dcfd9699a315a9
title:Properties used in Incorporated Educational Institution items SELECT ?prop (Sample(?propLabel) AS ?label) (COUNT(?prop) AS ?count) WHERE { { SELECT DISTINCT ?item ?prop WHERE { hint:Query hint:optimizer "None" . ?item wdt:P1454 wd:Q11448283; ?p ?propvalue. ?prop wikibase:directClaim ?p . } } . OPTIONAL { ?prop rdfs:label ?propLabel filter (lang(?propLabel) = "ja") } } GROUP BY ?prop ORDER BY DESC(?count)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#title:Properties used in Incorporated Educational Institution items
SELECT ?prop (Sample(?propLabel) AS ?label) (COUNT(?prop) AS ?count)
WHERE
{
{
SELECT DISTINCT ?item ?prop WHERE {
?item wdt:P1454 wd:Q11448283; ?p ?propvalue.
?prop wikibase:directClaim ?p .
}
} .
OPTIONAL { ?prop rdfs:label ?propLabel filter (lang(?propLabel) = "ja") }
}
GROUP BY ?prop
ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?count")
v3("?item")
v7("?label")
v4("?p")
v6("?prop"):::projected
v2("?propLabel"):::projected
v5("?propvalue")
c3(["wd:Q11448283"]):::iri
v3 --"wdt:P1454"--> c3
v3 -->v4--> v5
v6 --"wikibase:directClaim"--> v4
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v6 -."rdfs:label".-> v2
end
bind2[/"sample(?propLabel)"/]
v2 --o bind2
bind2 --as--o v7
bind3[/"count(?prop)"/]
v6 --o bind3
bind3 --as--o v8