query-2602d70fd38b51457a0f795afb51098a
title:List of properties qualified with P1114 SELECT ?prop ?propLabel ?count ?sample WHERE { { SELECT ?prop (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) WHERE { hint:Query hint:optimizer "None". ?st pq:P1114 ?val. ?item ?p ?st. ?prop wikibase:claim ?p. } GROUP BY ?prop } SERVICE wikibase:label { bd:serviceParam wikibase:language "ja,en". } } ORDER BY DESC (?count) (?propLabel)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:List of properties qualified with P1114
SELECT ?prop ?propLabel ?count ?sample WHERE {
{
SELECT ?prop (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) WHERE {
?st pq:P1114 ?val.
?item ?p ?st.
?prop wikibase:claim ?p.
}
GROUP BY ?prop
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "ja,en". }
}
ORDER BY DESC (?count) (?propLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?count"):::projected
v5("?item")
v6("?p")
v7("?prop"):::projected
v2("?propLabel"):::projected
v8("?sample"):::projected
v3("?st")
v4("?val")
c4(["bd:serviceParam"]):::iri
c6(["ja,en"]):::literal
v3 --"pq:P1114"--> v4
v5 -->v6--> v3
v7 --"wikibase:claim"--> v6
bind2[/"count(?item)"/]
v5 --o bind2
bind2 --as--o v8
bind3[/"sample(?st)"/]
v3 --o bind3
bind3 --as--o v8
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end