query-935421161e59414e7bf5c1afb3d8e2bf

rq turtle/ttl

title: Durchschnittliche Zahl an Quellenangabe (URL bzw. Item) bei Objekten in Kunstmuseen SELECT ?collection ?collectionLabel (AVG(?numberOfReferences) AS ?revAverage) WITH { #named Subquery via https://renenyffenegger.ch/notes/development/Data/open/Wikidata/index nach https://w.wiki/5pWb SELECT ?obj $collection WHERE { ?obj wdt:P276 $collection . ?collection wdt:P31 wd:Q207694; wdt:P17 wd:Q183 . } } AS %objects

WHERE { SELECT ?collection ?collectionLabel ?obj (COUNT(?refnode) AS ?numberOfReferences) WHERE { include %objects ?obj ?x ?statement. ?statement prov:wasDerivedFrom ?refnode. ?refnode (pr:P248| pr:P854) ?ref. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?collection ?collectionLabel ?obj } GROUP BY ?collection ?collectionLabel ORDER BY DESC(?revAverage)

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 prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Durchschnittliche Zahl an Quellenangabe (URL bzw. Item) bei Objekten in Kunstmuseen
SELECT ?collection ?collectionLabel (AVG(?numberOfReferences) AS ?revAverage)

WHERE {
  SELECT ?collection ?collectionLabel ?obj (COUNT(?refnode) AS ?numberOfReferences)
  WHERE {
     {
  #named Subquery via https://renenyffenegger.ch/notes/development/Data/open/Wikidata/index nach https://w.wiki/5pWb
  SELECT ?obj $collection WHERE {
    ?obj wdt:P276 $collection .
    ?collection wdt:P31 wd:Q207694;
                wdt:P17 wd:Q183 .
  }
}    ?obj ?x ?statement.
    ?statement prov:wasDerivedFrom ?refnode.
    ?refnode (pr:P248| pr:P854) ?ref.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  GROUP BY ?collection ?collectionLabel ?obj
}
GROUP BY ?collection ?collectionLabel
ORDER BY DESC(?revAverage)

Query found at

• https://www.wikidata.org/wiki/User:Awinkler3