Query cities: Difference between revisions

Revision as of 18:54, 5 February 2024

form is loading...

All citiies:

page title	city	country	population
Regensburg	Regensburg	Germany	150000
Shifang	shifang	China	420000
Rome	Rome	Italy	2873000
Athens	Athens	Greece	3155000
Madrid	Madrid	Spain	3223000
Prague	Prague	Czech Republic	4000000
New York	New York	United States	8468000
London	London	United Kingdom	8982000

[[city::+]][[population::> 3000000]]

The following table uses (in the first column) the printout template Template:Link to country to perform a join with the "Country article" schema.

The column "city" is the actual subject of the query, whose link is still retrieved using a template, but without an additional query.

false	country	city	population
Athens	Greece	Athens	3155000
Madrid	Spain	Madrid	3223000
Prague		Prague	4000000
New York	United States	New York	8468000
London	United Kingdom	London	8982000

@@ Line 31: / Line 31: @@
 |?population
 |format=table
+|order=population asc
 |limit=100
 }}
@@ Line 57: / Line 58: @@
 |template?city=Link to city
 |pagetitle=false
+|order=population asc
 |format=table
 |limit=100
 }}