 SELECT t.element_id, tax.term_id, tax.taxonomy FROM wprb_icl_translations t JOIN wprb_term_taxonomy tax ON t.element_id = tax.term_taxonomy_id AND t.element_type = CONCAT('tax_', tax.taxonomy) JOIN wprb_terms terms ON terms.term_id = tax.term_id WHERE tax.term_id != tax.term_taxonomy_id;