query-7707f2d9f210339469ebf9403e836247

rq turtle/ttl

Deutsche Städteportale

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 bd: <http://www.bigdata.com/rdf#>
#defaultView:ImageGrid
#title: Deutsche Städteportale
SELECT DISTINCT ?portal ?portalLabel ?article ?bild ?population WHERE {
  ?portal wdt:P31 wd:Q4663903;
    wdt:P1204 ?thema.
  ?thema (wdt:P31/(wdt:P279*)) wd:Q262166.
  OPTIONAL { ?thema wdt:P1082 ?population. }
  OPTIONAL {
    ?article schema:about ?portal;
      schema:isPartOf <https://de.wikipedia.org/>;
      schema:name ?page_title.
  }
  OPTIONAL { ?thema wdt:P18 ?bild. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?population)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?article"):::projected v6("?bild"):::projected v5("?page_title") v1("?population"):::projected v2("?portal"):::projected v3("?thema") a1((" ")) c9([https://de.wikipedia.org/]):::iri c2(["wd:Q4663903"]):::iri c13(["bd:serviceParam"]):::iri c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal c5(["wd:Q262166"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P1204"--> v3 v3 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P1082".-> v1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:about".-> v2 v4 --"schema:isPartOf"--> c9 v4 --"schema:name"--> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P18".-> v6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end