query-9564f8685ed85ff04c7b58f298e40a90
title: Romanian actors missing an external identifier SELECT ?item ?label ?search WHERE { VALUES ?prop { #wd:P9102 # cinefan.ro wd:P345 # imdb } ?prop wdt:P4354 ?url . ?item wdt:P31 wd:Q5 ; wdt:P106/wdt:P279* wd:Q33999 ; wdt:P27 wd:Q218 . MINUS { ?prop wikibase:directClaim ?c . ?item ?c [] } BIND (URI(REPLACE(str(?url), "\$1", str(?label))) AS ?search ) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?label } } LIMIT 100
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Romanian actors missing an external identifier
SELECT ?item ?label ?search WHERE {
VALUES ?prop { #wd:P9102 # cinefan.ro
wd:P345 # imdb
}
?prop wdt:P4354 ?url .
?item wdt:P31 wd:Q5 ;
wdt:P106/wdt:P279* wd:Q33999 ;
wdt:P27 wd:Q218 .
MINUS { ?prop wikibase:directClaim ?c . ?item ?c [] }
BIND (URI(REPLACE(str(?url), "\\$1", str(?label))) AS ?search )
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?label }
} LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?c")
v3("?item"):::projected
v6("?label"):::projected
v1("?prop")
v5("?search"):::projected
v2("?url")
a2((" "))
a1((" "))
c11(["bd:serviceParam"]):::iri
c8(["wd:Q218"]):::iri
c3(["wd:Q5"]):::iri
c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c6(["wd:Q33999"]):::iri
bind0[/VALUES ?prop/]
bind0-->v1
bind00(["wd:P345"])
bind00 --> bind0
v1 --"wdt:P4354"--> v2
v3 --"wdt:P31"--> c3
v3 --"wdt:P106"--> a1
a1 --"wdt:P279"--> c6
v3 --"wdt:P27"--> c8
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v1 --"wikibase:directClaim"--> v4
v3 -->v4--> a2
end
bind2[/"replace(str(?url),'\$1',str(?label))"/]
v2 --o bind2
v6 --o bind2
bind2 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c11 --"wikibase:language"--> c13
v3 --"rdfs:label"--> v6
end