query-04005fccf9c904a98cef16328ac92440

rq turtle/ttl

Südtirol/Alto Adige

Use at

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