query-24f9272667ba628a2fc448b877fb1e9e
Zombie referencesDo we have a lot of zombie references still lodged in the system, or on WDQS, but no longer connected to any statement? in a reference. Currently it's finding nine such references, but none of them connected to any statements. (P1013)criterion used The following query looks for statements using
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?stmt ?ref ?criterion ?criterionLabel WHERE {
?ref pr:P1013 ?criterion .
OPTIONAL {?stmt prov:wasDerivedFrom ?ref} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?criterion"):::projected
v1("?ref"):::projected
v3("?stmt"):::projected
c4(["bd:serviceParam"]):::iri
c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v1 --"pr:P1013"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."prov:wasDerivedFrom".-> v1
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end