query-3bcdbd8c39408cad78ff5329676ca473

rq turtle/ttl

title:P2670 statements qualified with P1114 SELECT ?obj ?objLabel ?count ?sample { { SELECT ?obj (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) { ?item p:P2670 ?st . ?st ps:P2670 ?obj . ?st pq:P1114 ?val . } 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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:P2670 statements qualified with P1114
SELECT ?obj ?objLabel ?count ?sample {
  {
    SELECT ?obj  (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) {
      ?item p:P2670 ?st .
      ?st ps:P2670 ?obj .
      ?st pq:P1114 ?val .
    } 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; v7("?count"):::projected v3("?item") v5("?obj"):::projected v2("?objLabel"):::projected v7("?sample"):::projected v4("?st") v6("?val") c5(["bd:serviceParam"]):::iri c7(["ja,en"]):::literal v3 --"p:P2670"--> v4 v4 --"p:statement/P2670"--> v5 v4 --"p:qualifier/P1114"--> v6 bind2[/"count(?item)"/] v3 --o bind2 bind2 --as--o v7 bind3[/"sample(?st)"/] v4 --o bind3 bind3 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end