query-04005fccf9c904a98cef16328ac92440
Südtirol/Alto Adige
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 schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map
SELECT DISTINCT (GROUP_CONCAT(DISTINCT ?lang; SEPARATOR = ", ") AS ?sprachen) ?page_title ?article ?verwaltung ?il ?item (GROUP_CONCAT(DISTINCT ?io; SEPARATOR = ", ") AS ?ist_ein) ?coordinate WHERE {
?item (wdt:P131*) wd:Q15124;
wdt:P131 ?einheit.
OPTIONAL {
?gepage schema:about ?item;
schema:isPartOf <https://it.wikipedia.org/>;
schema:name ?ge_title.
}
OPTIONAL { ?item wikibase:sitelinks ?sl. }
FILTER(?sl > 0 )
OPTIONAL {
?page schema:about ?item;
schema:inLanguage ?lang.
}
FILTER(?lang IN("lld", "fr", "de", "it", "en"))
OPTIONAL {
?enwiki schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>;
schema:name ?en_title.
}
OPTIONAL {
?dewiki schema:about ?item;
schema:isPartOf <https://de.wikipedia.org/>;
schema:name ?de_title.
}
OPTIONAL { ?item wdt:P625 ?coordinate. }
OPTIONAL { ?item wdt:P31 ?instance. }
BIND(IF(BOUND(?dewiki), ?dewiki, IF(BOUND(?enwiki), ?enwiki, ?gepage)) AS ?article)
BIND(IF(BOUND(?de_title), ?de_title, IF(BOUND(?en_title), ?en_title, ?ge_title)) AS ?page_title)
FILTER(BOUND(?article))
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,it".
?item rdfs:label ?il.
?instance rdfs:label ?io.
?einheit rdfs:label ?verwaltung.
}
FILTER(?einheit IN(wd:Q377319, wd:Q255568, wd:Q499129, wd:Q504491, wd:Q381366, wd:Q377980, wd:Q6526, wd:Q185541, wd:Q378095, wd:Q261187, wd:Q433287, wd:Q15124))
}
GROUP BY ?page_title ?article ?verwaltung ?il ?item ?coordinate
ORDER BY (?page_title)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v16("?article"):::projected
v14("?coordinate"):::projected
v13("?de_title")
v12("?dewiki")
v2("?einheit")
v11("?en_title")
v10("?enwiki")
v8("?ge_title")
v7("?gepage")
v16("?il"):::projected
v15("?instance")
v17("?io"):::projected
v20("?ist_ein")
v6("?item"):::projected
v4("?lang"):::projected
v9("?page")
v16("?page_title"):::projected
v5("?sl")
v19("?sprachen")
v18("?verwaltung"):::projected
c27([https://de.wikipedia.org/]):::iri
c22([https://it.wikipedia.org/]):::iri
c26([https://en.wikipedia.org/]):::iri
c31(["bd:serviceParam"]):::iri
c12(["wd:Q15124"]):::iri
c33(["#91;AUTO_LANGUAGE#93;,en,it"]):::literal
list0c4(["wd:Q504491"]):::iri
list0c8(["wd:Q185541"]):::iri
list0c3(["wd:Q499129"]):::iri
list0c6(["wd:Q377980"]):::iri
list0c5(["wd:Q381366"]):::iri
list0c2(["wd:Q255568"]):::iri
list0c1(["wd:Q377319"]):::iri
list0c9(["wd:Q378095"]):::iri
list0c10(["wd:Q261187"]):::iri
list0c11(["wd:Q433287"]):::iri
list0c12(["wd:Q15124"]):::iri
list0c7(["wd:Q6526"]):::iri
list0c1 --o f0
list0c2 --o f0
list0c3 --o f0
list0c4 --o f0
list0c5 --o f0
list0c6 --o f0
list0c7 --o f0
list0c8 --o f0
list0c9 --o f0
list0c10 --o f0
list0c11 --o f0
list0c12 --o f0
f0[[" in "]]
f0 --> v2
f1[["bound(?article)"]]
f1 --> v16
list1c3(["de"]):::literal
list1c1(["lld"]):::literal
list1c5(["en"]):::literal
list1c4(["it"]):::literal
list1c2(["fr"]):::literal
list1c1 --o f2
list1c2 --o f2
list1c3 --o f2
list1c4 --o f2
list1c5 --o f2
f2[[" in "]]
f2 --> v4
f3[["?sl > '0^^xsd:integer'"]]
f3 --> v5
v6 --"wdt:P131"--> c12
v6 --"wdt:P131"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v7 -."schema:about".-> v6
v7 --"schema:isPartOf"--> c22
v7 --"schema:name"--> v8
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wikibase:sitelinks".-> v5
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v9 -."schema:about".-> v6
v9 --"schema:inLanguage"--> v4
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v10 -."schema:about".-> v6
v10 --"schema:isPartOf"--> c26
v10 --"schema:name"--> v11
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v12 -."schema:about".-> v6
v12 --"schema:isPartOf"--> c27
v12 --"schema:name"--> v13
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P625".-> v14
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P31".-> v15
end
bind4[/"if(bound(?dewiki),?dewiki,if(bound(?enwiki),?enwiki,?gepage))"/]
v12 --o bind4
v10 --o bind4
v7 --o bind4
bind4 --as--o v16
bind5[/"if(bound(?de_title),?de_title,if(bound(?en_title),?en_title,?ge_title))"/]
v13 --o bind5
v11 --o bind5
v8 --o bind5
bind5 --as--o v16
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c31 --"wikibase:language"--> c33
v6 --"rdfs:label"--> v16
v15 --"rdfs:label"--> v17
v2 --"rdfs:label"--> v18
end
bind8[/"?lang"/]
v4 --o bind8
bind8 --as--o v19
bind9[/"?io"/]
v17 --o bind9
bind9 --as--o v20