query-cc0c8e8ed769461543a6e9c11d934a39

rq turtle/ttl

Iranian cities, Max pop from last point in time SELECT ?city ?city_FA ?city_EN (MAX(?population) AS ?pop) ?coordinates ?date

WHERE { ?city wdt:P31/wdt:P279* wd:Q515; wdt:P17 wd:Q794; wdt:P625 ?coordinates; p:P1082 [pq:P585 ?date; ps:P1082 ?population]. FILTER NOT EXISTS {?city p:P1082 [pq:P585 ?date_] FILTER (?date_ > ?date)} SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?city rdfs:label ?city_EN. } SERVICE wikibase:label { bd:serviceParam wikibase:language "fa". ?city rdfs:label ?city_FA. } hint:Prior hint:runLast false. } GROUP BY ?city ?city_FA ?city_EN ?pop ?coordinates ?date

Use at

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Iranian cities, Max pop from last point in time
SELECT ?city ?city_FA ?city_EN (MAX(?population) AS ?pop) ?coordinates ?date

WHERE {
  ?city wdt:P31/wdt:P279* wd:Q515;
        wdt:P17 wd:Q794;
        wdt:P625 ?coordinates;
        p:P1082 [pq:P585 ?date; ps:P1082 ?population].
   FILTER NOT EXISTS {?city p:P1082 [pq:P585 ?date_] FILTER (?date_ > ?date)}
     SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
            ?city rdfs:label ?city_EN.
     }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "fa".
            ?city rdfs:label ?city_FA.
     } hint:Prior hint:runLast false.
 } GROUP BY ?city ?city_FA ?city_EN ?pop ?coordinates ?date

Query found at