query-5dc3f02e7544b341bea58f3f1493f067
title:NUKAT appearing two times equal in two different items (= unique-value violation) SELECT DISTINCT ?v1 ?item1 ?item2 WHERE { ?item1 p:P1207 ?s1 . ?s1 ps:P1207 ?v1 . ?item2 p:P1207 ?s2 . ?s2 ps:P1207 ?v2 . FILTER(?item1 != ?item2) 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:NUKAT appearing two times equal in two different items (= unique-value violation)
SELECT DISTINCT ?v1 ?item1 ?item2
WHERE {
?item1 p:P1207 ?s1 .
?s1 ps:P1207 ?v1 .
?item2 p:P1207 ?s2 .
?s2 ps:P1207 ?v2 .
FILTER(?item1 != ?item2)
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;
v3("?item1"):::projected
v4("?item2"):::projected
v5("?s1")
v6("?s2")
v1("?v1"):::projected
v2("?v2")
f0[["?v1 = ?v2"]]
f0 --> v1
f0 --> v2
f1[["?item1 != ?item2"]]
f1 --> v3
f1 --> v4
v3 --"p:P1207"--> v5
v5 --"p:statement/P1207"--> v1
v4 --"p:P1207"--> v6
v6 --"p:statement/P1207"--> v2