query-10da408f1001e1ff12219e4e136c316d
Warships without English names
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 ?name WHERE
{
?item wdt:P31/wdt:P279* wd:Q177597.
MINUS {?item rdfs:label ?label. FILTER(LANG(?label) = "en").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "ru").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "ja").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "el").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "ko").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "bg").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "he").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "uk").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "zh").}
MINUS {?item rdfs:label ?label1. FILTER(LANG(?label1) = "bn").}
# OPTIONAL {?item wdt:P1448 ?official. FILTER(LANG(?official) = "mul")}
# BIND (COALESCE(?official,?label) AS ?name)
#FILTER(CONTAINS(?name, "(")).
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
v2("?label")
v3("?label1")
a1((" "))
c3(["wd:Q177597"]):::iri
v1 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c3
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
f1[["?label = 'en'"]]
f1 --> v2
v1 --"rdfs:label"--> v2
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
f3[["?label1 = 'ru'"]]
f3 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus4["MINUS"]
style minus4 stroke-width:6px,fill:pink,stroke:red;
f5[["?label1 = 'ja'"]]
f5 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus6["MINUS"]
style minus6 stroke-width:6px,fill:pink,stroke:red;
f7[["?label1 = 'el'"]]
f7 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus8["MINUS"]
style minus8 stroke-width:6px,fill:pink,stroke:red;
f9[["?label1 = 'ko'"]]
f9 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus10["MINUS"]
style minus10 stroke-width:6px,fill:pink,stroke:red;
f11[["?label1 = 'bg'"]]
f11 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus12["MINUS"]
style minus12 stroke-width:6px,fill:pink,stroke:red;
f13[["?label1 = 'he'"]]
f13 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus14["MINUS"]
style minus14 stroke-width:6px,fill:pink,stroke:red;
f15[["?label1 = 'uk'"]]
f15 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus16["MINUS"]
style minus16 stroke-width:6px,fill:pink,stroke:red;
f17[["?label1 = 'zh'"]]
f17 --> v3
v1 --"rdfs:label"--> v3
end
subgraph minus18["MINUS"]
style minus18 stroke-width:6px,fill:pink,stroke:red;
f19[["?label1 = 'bn'"]]
f19 --> v3
v1 --"rdfs:label"--> v3
end