query-b9d32ea0f94a5e42e91e921847cf5b0d
ערים ללא J9U
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 p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?countryLabel ?itemLabel_en ?itemLabel_he ?itemLabel_pl ?itemLabel_de ?itemLabel_fr ?itemLabel_es ?itemLabel_it ?itemLabel_ru ?itemLabel_bg ?itemLabel_uk ?itemLabel_sr ?itemLabel_ro ?itemLabel_hr ?itemLabel_el ?itemLabel_zh ?itemLabel_sl ?itemLabel_sq WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
SERVICE bd:slice {
?item wdt:P31 wd:Q1549591 .
bd:serviceParam bd:slice.offset 0 . # Start at item number (not to be confused with QID)
bd:serviceParam bd:slice.limit 20000 . # List this many items
}
MINUS {
?item p:P8189 ?j9u.
}
OPTIONAL {?item wdt:P17 ?country}
OPTIONAL { ?item rdfs:label ?itemLabel_en . filter(lang(?itemLabel_en)="en") }
OPTIONAL { ?item rdfs:label ?itemLabel_he . filter(lang(?itemLabel_he)="he") }
OPTIONAL { ?item rdfs:label ?itemLabel_pl . filter(lang(?itemLabel_pl)="pl") }
OPTIONAL { ?item rdfs:label ?itemLabel_de . filter(lang(?itemLabel_de)="de") }
OPTIONAL { ?item rdfs:label ?itemLabel_fr . filter(lang(?itemLabel_fr)="fr") }
OPTIONAL { ?item rdfs:label ?itemLabel_es . filter(lang(?itemLabel_es)="es") }
OPTIONAL { ?item rdfs:label ?itemLabel_it . filter(lang(?itemLabel_it)="it") }
OPTIONAL { ?item rdfs:label ?itemLabel_ru . filter(lang(?itemLabel_ru)="ru") }
OPTIONAL { ?item rdfs:label ?itemLabel_bg . filter(lang(?itemLabel_bg)="bg") }
OPTIONAL { ?item rdfs:label ?itemLabel_uk . filter(lang(?itemLabel_uk)="uk") }
OPTIONAL { ?item rdfs:label ?itemLabel_sr . filter(lang(?itemLabel_sr)="sr") }
OPTIONAL { ?item rdfs:label ?itemLabel_ro . filter(lang(?itemLabel_ro)="ro") }
OPTIONAL { ?item rdfs:label ?itemLabel_hr . filter(lang(?itemLabel_hr)="hr") }
OPTIONAL { ?item rdfs:label ?itemLabel_ar . filter(lang(?itemLabel_ar)="ar") }
OPTIONAL { ?item rdfs:label ?itemLabel_zh . filter(lang(?itemLabel_zh)="zh") }
OPTIONAL { ?item rdfs:label ?itemLabel_sq . filter(lang(?itemLabel_sq)="sq") }
OPTIONAL { ?item rdfs:label ?itemLabel_sl . filter(lang(?itemLabel_sl)="sl") }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v20("?country")
v18("?item"):::projected
v4("?itemLabel_ar")
v9("?itemLabel_bg"):::projected
v14("?itemLabel_de"):::projected
v17("?itemLabel_en"):::projected
v12("?itemLabel_es"):::projected
v13("?itemLabel_fr"):::projected
v16("?itemLabel_he"):::projected
v5("?itemLabel_hr"):::projected
v11("?itemLabel_it"):::projected
v15("?itemLabel_pl"):::projected
v6("?itemLabel_ro"):::projected
v10("?itemLabel_ru"):::projected
v1("?itemLabel_sl"):::projected
v2("?itemLabel_sq"):::projected
v7("?itemLabel_sr"):::projected
v8("?itemLabel_uk"):::projected
v3("?itemLabel_zh"):::projected
v19("?j9u")
c19(["bd:serviceParam"]):::iri
c21(["#91;AUTO_LANGUAGE#93;"]):::literal
c24(["wd:Q1549591"]):::iri
c28(["20000^^xsd:integer"]):::literal
c26(["0^^xsd:integer"]):::literal
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c19 --"wikibase:language"--> c21
end
subgraph s2["http://www.bigdata.com/rdf#slice"]
style s2 stroke-width:4px;
v18 --"p:direct/P31"--> c24
c19 --"bd:slice.offset"--> c26
c19 --"bd:slice.limit"--> c28
end
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v18 --"p:P8189"--> v19
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v18 -."p:direct/P17".-> v20
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v17
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v16
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v15
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v14
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v13
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v12
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v11
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v10
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v9
end
subgraph optional10["(optional)"]
style optional10 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v8
end
subgraph optional11["(optional)"]
style optional11 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v7
end
subgraph optional12["(optional)"]
style optional12 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v6
end
subgraph optional13["(optional)"]
style optional13 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v5
end
subgraph optional14["(optional)"]
style optional14 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v4
end
subgraph optional15["(optional)"]
style optional15 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v3
end
subgraph optional16["(optional)"]
style optional16 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v2
end
subgraph optional17["(optional)"]
style optional17 fill:#bbf,stroke-dasharray: 5 5;
v18 -."rdfs:label".-> v1
end