query-dae14cb03574e522586eebdea9d89f0a

rq turtle/ttl

title:Decrease of the number of VIAFs thanks to Wikidata SELECT ?item (COUNT(DISTINCT ?viaf_ref) AS ?n_ref) (COUNT(DISTINCT ?viaf) AS ?n) WHERE { ?item wdt:P69 wd:Q1576779 . ?item ?id [ prov:wasDerivedFrom [ pr:P214 ?viaf_ref ] ] . ?item wdt:P214 ?viaf . } GROUP BY ?item ?n_ref ?n HAVING(?n_ref > ?n)

Use at

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/>
#title:Decrease of the number of VIAFs thanks to Wikidata
SELECT ?item (COUNT(DISTINCT ?viaf_ref) AS ?n_ref) (COUNT(DISTINCT ?viaf) AS ?n)
WHERE {
  ?item wdt:P69 wd:Q1576779 .
  ?item ?id [ prov:wasDerivedFrom [ pr:P214 ?viaf_ref ] ] .
  ?item wdt:P214 ?viaf .
}
GROUP BY ?item ?n_ref ?n
HAVING(?n_ref > ?n)

Query found at