Wikipedista:Wesalius/draft

města z wd

• https://query.wikidata.org
• Francie = Q142
• abecedně: ORDER BY ?city
• dle populace: ORDER BY DESC(?population)

SELECT DISTINCT ?cityLabel ?population WHERE {
  ?city (wdt:P31/wdt:P279*) wd:Q515.
  ?city wdt:P1082 ?population.
  ?city wdt:P17 wd:Q142.
  FILTER( ?population > 1000000)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs". }
}
ORDER BY ?city

SELECT DISTINCT ?cityLabel ?population WHERE {
  ?city (wdt:P31/wdt:P279*) wd:Q515.
  ?city wdt:P1082 ?population.
  ?city wdt:P17 wd:Q142.
  FILTER( ?population > 500000)
  FILTER( ?population < 1000000)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs". }
}
ORDER BY ?city

SELECT DISTINCT ?cityLabel ?population WHERE {
  ?city (wdt:P31/wdt:P279*) wd:Q515.
  ?city wdt:P1082 ?population.
  ?city wdt:P17 wd:Q142.
  FILTER( ?population > 250000)
  FILTER( ?population < 500000)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs". }
}
ORDER BY ?city

SELECT DISTINCT ?cityLabel ?population WHERE {
  ?city (wdt:P31/wdt:P279*) wd:Q515.
  ?city wdt:P1082 ?population.
  ?city wdt:P17 wd:Q142.
  FILTER( ?population > 150000)
  FILTER( ?population < 250000)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs". }
}
ORDER BY ?city

SELECT DISTINCT ?cityLabel ?population WHERE {
  ?city (wdt:P31/wdt:P279*) wd:Q515.
  ?city wdt:P1082 ?population.
  ?city wdt:P17 wd:Q142.
  FILTER( ?population > 100000)
  FILTER( ?population < 150000)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs". }
}
ORDER BY ?city