query-a0b00aca3808690b93b36f22b12d2645
title:VIAF appearing two times in the same item (= single-value violation) SELECT DISTINCT ?item ?v1 WHERE { ?item p:P214 ?viaf1 . ?viaf1 ps:P214 ?v1 . ?item p:P214 ?viaf2 . ?viaf2 ps:P214 ?v2 . FILTER(?viaf1 != ?viaf2) FILTER(?v1 = ?v2) } LIMIT 10
Use at
- https://query.wikidata.org/sparql
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
#title:VIAF appearing two times in the same item (= single-value violation)
SELECT DISTINCT ?item ?v1
WHERE {
?item p:P214 ?viaf1 .
?viaf1 ps:P214 ?v1 .
?item p:P214 ?viaf2 .
?viaf2 ps:P214 ?v2 .
FILTER(?viaf1 != ?viaf2)
FILTER(?v1 = ?v2)
}
LIMIT 10
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?item"):::projected
v1("?v1"):::projected
v2("?v2")
v3("?viaf1")
v4("?viaf2")
f0[["?v1 = ?v2"]]
f0 --> v1
f0 --> v2
f1[["?viaf1 != ?viaf2"]]
f1 --> v3
f1 --> v4
v5 --"p:P214"--> v3
v3 --"p:statement/P214"--> v1
v5 --"p:P214"--> v4
v4 --"p:statement/P214"--> v2