TABLE WITHOUT ID
file.link AS "Ort",
parent AS "Teil von",
population AS "Einwohner",
faction AS "Kontrolle"
FROM "Orte"
WHERE type = "ort"
GROUP BY scale AS "Maßstab"
SORT scale ASCTABLE WITHOUT ID
file.link AS "Ort",
parent AS "Teil von",
population AS "Einwohner",
faction AS "Kontrolle"
FROM "Orte"
WHERE type = "ort"
GROUP BY scale AS "Maßstab"
SORT scale ASC