Query failed: ERROR:  column distance.shortname does not exist
LINE 1: select DISTINCT distance.shortname, distance.distance from d...
                        ^
HINT:  Perhaps you meant to reference the column "distance.short_name".