Background of the issue:
I am trying to make the translated elements work with my custom queries from JetEngine. The problem is that I'm not exactly sure how the database is structured as for WPML. For instance, how is a taxonomy term in English linked to its counterpart translated Japanese version? In this query, the term_id's (243, 242, 241 and 239) are the Japanese version of these terms
SELECT DISTINCT
t.term_id,
t.name,
t.slug,
t.term_group,
tt.description,
t.name AS button_title
FROM wp_terms t
JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id
JOIN wp_icl_translations icl_t ON icl_t.element_id = tt.term_taxonomy_id
LEFT JOIN wp_icl_translation_status icl_ts ON icl_ts.translation_id = icl_t.translation_id
WHERE tt.taxonomy IN ('team-employment-type', 'team-location')
AND icl_t.language_code = 'jp'
AND icl_t.element_type IN ('tax_team-employment-type', 'tax_team-location')
ORDER BY
CASE
WHEN t.term_id = 243 THEN 0 -- USA (translated)
WHEN t.term_id = 242 THEN 1 -- Japan (translated)
WHEN t.term_id = 241 THEN 2 -- Leadership (translated)
WHEN t.term_id = 239 THEN 3 -- Board (translated)
ELSE 4
END;
Symptoms:
I am unsure how the database links each respective taxonomy term to its English version.
Questions:
What exactly in the database links each respective taxonomy term to its English version?
Which specific table and columns are used to link translated taxonomy terms?
Please note that we currently are not able to provide support for custom work within this forum.
I will, however, try to point you to the correct direction.
WPML manages translations of taxonomies (such as categories, tags, and custom taxonomies) by storing them in dedicated database tables. It stores the connections. This structure ensures that each taxonomy term and its translations are properly linked, maintaining the relationships between original and translated content. 
Here you have detailed information about how WPML organizes and stores these translations within your database, our documentation on WPML’s database tables provides detailed insights:  https://wpml.org/documentation/support/wpml-tables/
