query-c01a400e8a66c9276f3448041a66f1b4

rq turtle/ttl

title:breakdown of P1114 statements qualified with P805 SELECT ?obj ?objLabel ?count ?sample { { SELECT ?obj (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) { ?item p:P1114 ?st . ?st pq:P805 ?obj . } GROUP BY ?obj }. SERVICE wikibase:label { bd:serviceParam wikibase:language "ja,en" } } ORDER BY DESC(?count) ASC(?objLabel)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:breakdown of P1114 statements qualified with P805
SELECT ?obj ?objLabel ?count ?sample {
  {
    SELECT ?obj  (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) {
      ?item p:P1114 ?st .
      ?st pq:P805 ?obj .
    } GROUP BY ?obj
  }.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ja,en"  }
}
ORDER BY DESC(?count) ASC(?objLabel)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?count"):::projected v3("?item") v5("?obj"):::projected v2("?objLabel"):::projected v6("?sample"):::projected v4("?st") c4(["bd:serviceParam"]):::iri c6(["ja,en"]):::literal v3 --"p:P1114"--> v4 v4 --"p:qualifier/P805"--> v5 bind2[/"count(?item)"/] v3 --o bind2 bind2 --as--o v6 bind3[/"sample(?st)"/] v4 --o bind3 bind3 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end