select tz || ' ' || gmt_offset as full_tz, tz from timezones order by tz select label, locale from enabled_locales order by label