This is the sql query I used to verify if the official central places are in the pages table
(Where de_cpt is a table with one column "de_place", the official list of central places;)
SELECT *
FROM (
SELECT *
FROM de_cpt
LEFT JOIN pages
ON de_cpt.de_place = pages.de OR de_cpt.de_place = pages.de_alias_for
) AS search
WHERE search.de IS NULL OR search.de_alias_for IS NULL
ORDER BY search.de_place ASC;
(I might have misunderstood how to handle the aliases.)
This is the sql query I used to verify if the official central places are in the pages table (Where de_cpt is a table with one column "de_place", the official list of central places;)
(I might have misunderstood how to handle the aliases.)
The list of still missing places is attached de_cpt_missing_places.txt
Moreover, I pulled manually pulled out places that were previously uncaught, but now caught because it can be linked to an alias.