query-7d503211403f8e81c4b53511245dea76
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?item ?itemLabel ?BavNo WHERE {
?item wdt:P4244 ?BavNo . # item has a P4244
MINUS { ?item wdt:P18 [] } . # item has no image
filter(substr(?BavNo,1,11)="D-5-64-000-") # P4244 value starts with D-5-64-000-
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de". }
}
Order by ?BavNo
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?BavNo"):::projected
v2("?item"):::projected
a1((" "))
c9(["#91;AUTO_LANGUAGE#93;,de"]):::literal
c7(["bd:serviceParam"]):::iri
f0[["substring(?BavNo,'1^^xsd:integer','11^^xsd:integer') = 'D-5-64-000-'"]]
f0 --> v1
v2 --"wdt:P4244"--> v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P18"--> a1
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end