query-2ef25f883c00ea620917c790017836d8

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?itemLabel (AVG(?item_lat) AS ?lat) (AVG(?item_long) AS ?long) (AVG(?Einwohnerzahl) AS ?pop) WHERE {
#  ?item wdt:P31 wd:Q667509.
  ?item p:P31 ?statement.
  ?statement ps:P31 wd:Q667509.
  filter not exists {?statement pq:P582 [].}
  ?item rdfs:label ?itemLabel.
  ?item (p:P625/psv:P625) ?item_node.
  ?item_node wikibase:geoLatitude ?item_lat.
  ?item_node wikibase:geoLongitude ?item_long.
  ?item wdt:P1082 ?Einwohnerzahl.
  FILTER((LANG(?itemLabel)) = "de")
}
GROUP BY ?itemLabel
ORDER BY ?itemLabel

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?Einwohnerzahl"):::projected v3("?item") v1("?itemLabel"):::projected v5("?item_lat"):::projected v6("?item_long"):::projected v4("?item_node") v8("?lat") v9("?long") v10("?pop") v2("?statement") a1((" ")) a2((" ")) c5(["wd:Q667509"]):::iri f0[["?itemLabel = 'de'"]] f0 --> v1 f1[["not "]] subgraph f1e0["Exists Clause"] e0v1 --"p:qualifier/P582"--> e0a1 e0v1("?statement"):::projected e0a1((" ")):::projected end f1--EXISTS--> f1e0 f1 --> v2 f1 --> c2 f1 --> a1 v2 --"p:qualifier/P582"--> a1 v3 --"p:P31"--> v2 v2 --"p:statement/P31"--> c5 v3 --"rdfs:label"--> v1 v3 --"p:P625"--> a2 a2 --"p:statement/value/P625"--> v4 v4 --"wikibase:geoLatitude"--> v5 v4 --"wikibase:geoLongitude"--> v6 v3 --"p:direct/P1082"--> v7 bind5[/"average(?item_lat)"/] v5 --o bind5 bind5 --as--o v8 bind6[/"average(?item_long)"/] v6 --o bind6 bind6 --as--o v9 bind7[/"average(?Einwohnerzahl)"/] v7 --o bind7 bind7 --as--o v10