query-84fd1f866215f54cf83919c94710596d
Painters with duplicate labels in English. I keep running into time-outs so I hope someone else has a smart way of fixing this: (P1889)different from gets added so we can find these mistakes. I would like to get an overview of painter pairs where both have the same label in English, but not linked to each other with (P1889)different from . These often get mixed up so (Q2483000)Jan Steen and (Q205863)Jan Steen Sometimes we have multiple painters with the same name like for example
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?item2 WHERE {
?item wdt:P106 wd:Q1028181 .
?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "en") .
?item2 rdfs:label ?item2Label .
FILTER(LANG(?item2Label) = "en" && !(str(?item)=str(?item2)) && ?itemLabel=?item2Label ) .
?item2 wdt:P106 wd:Q1028181 .
} LIMIT 10
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v3("?item2"):::projected
v1("?item2Label")
v4("?itemLabel")
c3(["wd:Q1028181"]):::iri
f0[["?item2Label = 'en'not str(?item) = str(?item2)?itemLabel = ?item2Label"]]
f0 --> v1
f0 --> v2
f0 --> v3
f0 --> v4
f1[["?itemLabel = 'en'"]]
f1 --> v4
v2 --"wdt:P106"--> c3
v2 --"rdfs:label"--> v4
v3 --"rdfs:label"--> v1
v3 --"wdt:P106"--> c3