query-8ba866ed569bf564a86f621f4e92a8b2

rq turtle/ttl

title:P1114 statements for class Q2140665 qualified with P642 SELECT ?obj ?objLabel ?count ?sample { { SELECT ?obj (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) { ?item wdt:P279 wd:Q2140665 . ?item p:P1114 ?st . ?st pq:P642 ?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 wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:P1114 statements for class Q2140665 qualified with P642
SELECT ?obj ?objLabel ?count ?sample {
  {
    SELECT ?obj  (COUNT(DISTINCT ?item) AS ?count) (SAMPLE(?st) AS ?sample) {
      ?item wdt:P279 wd:Q2140665 .
      ?item p:P1114 ?st .
      ?st pq:P642 ?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") c2(["wd:Q2140665"]):::iri c6(["bd:serviceParam"]):::iri c8(["ja,en"]):::literal v3 --"p:direct/P279"--> c2 v3 --"p:P1114"--> v4 v4 --"p:qualifier/P642"--> 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; c6 --"wikibase:language"--> c8 end