Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
Line 29: Line 29:
SELECT
SELECT
     translated_code,
     translated_code,
     translated_table_name,
     translated_table_code,
    translated_field_name,
     translated_field_code,
     translated_field_code,
    translated_field_value,
     iso_alpha2_lingo_code,
     iso_alpha2_lingo_code,
     iso_alpha2_state_code,
     iso_alpha2_state_code,

Revision as of 19:43, 11 September 2019

Languages

SELECT
    iso_alpha2_lingo_code,
    iso_alpha2_lingo_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M00X00

Countries

SELECT
    iso_alpha2_state_code,
    iso_alpha2_state_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M01X00

Translations

SELECT
    translated_code,
    translated_table_code,
    translated_field_code,
    translated_field_value,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M02X00