LEFT OUTER JOIN public.pc_paf_postzon_100m p USING (outward_code, inward_code)
LEFT OUTER JOIN public.pc_paf_county_alias a ON a.postcode = (rpad(m.outward_code,4) || m.inward_code)
LEFT OUTER JOIN public.pc_paf_counties apc ON apc.county_key = a.former_postal_county;
LEFT OUTER JOIN public.pc_paf_postzon_100m p USING (outward_code, inward_code)
LEFT OUTER JOIN public.pc_paf_county_alias a ON a.postcode = (rpad(m.outward_code,4) || m.inward_code)
LEFT OUTER JOIN public.pc_paf_counties apc ON apc.county_key = a.former_postal_county;