adds some translations and a slight fix to the zipcode sql