query-4acf2fca81e39d4c4d8cb5be2f5fb1ac
List Darts players without an ID on the Darts database
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 ?item_label ?check_url WHERE {
?item wdt:P106 wd:Q18574233 .
MINUS {?item wdt:P3621 [] } .
?item rdfs:label ?item_label FILTER(lang(?item_label) = 'en') .
wd:P3621 wdt:P4354 ?fmt .
BIND(IRI(REPLACE(str(?item_label), '(^.*)', ?fmt)) AS ?check_url) .
} LIMIT 50
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?check_url"):::projected
v3("?fmt")
v2("?item"):::projected
v1("?item_label"):::projected
a1((" "))
c3(["wd:Q18574233"]):::iri
c6(["wd:P3621"]):::iri
f0[["?item_label = 'en'"]]
f0 --> v1
v2 --"wdt:P106"--> c3
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P3621"--> a1
end
v2 --"rdfs:label"--> v1
c6 --"wdt:P4354"--> v3
bind2[/"replace(str(?item_label),'(^.*)',?fmt)"/]
v1 --o bind2
v3 --o bind2
bind2 --as--o v4