query-c65f41cfbf994802b71fa12e683819c9
Non-unique identifiers
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?identifier ?value ?item2 WHERE {
{
SELECT DISTINCT ?item WHERE {
?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
}
}
?identifier wikibase:propertyType wikibase:ExternalId; wikibase:claim ?identifierClaim; wikibase:statementProperty ?identifierStatementProperty; wikibase:reference ?ref .
?item ?identifierClaim [ ?identifierStatementProperty ?value ] .
?item2 ?identifierClaim [ ?identifierStatementProperty ?value ] .
FILTER(?item != ?item2) .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?identifier"):::projected
v4("?identifierClaim")
v5("?identifierStatementProperty")
v1("?item"):::projected
v2("?item2"):::projected
v6("?ref")
v7("?value"):::projected
a1((" "))
a2((" "))
a3((" "))
a4((" "))
c4(["wd:Q26270618"]):::iri
c6(["wikibase:ExternalId"]):::iri
f0[["?item != ?item2"]]
f0 --> v1
f0 --> v2
v1 --"p:P106"--> a1
a1 --"p:statement/P106"--> a2
a2 --"p:direct/P279"--> c4
v3 --"wikibase:propertyType"--> c6
v3 --"wikibase:claim"--> v4
v3 --"wikibase:statementProperty"--> v5
v3 --"wikibase:reference"--> v6
a3 -->v5--> v7
v1 -->v4--> a3
a4 -->v5--> v7
v2 -->v4--> a4