Shop

WordPress database error: [Not unique table/alias: 'icl_t']
SELECT DISTINCT t.term_id FROM qtw_terms AS t LEFT JOIN qtw_termmeta ON ( t.term_id = qtw_termmeta.term_id AND qtw_termmeta.meta_key='order') INNER JOIN qtw_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN qtw_icl_translations icl_t ON icl_t.element_id = tt.term_taxonomy_id AND icl_t.element_type IN ('tax_pa_color') LEFT JOIN qtw_icl_translations icl_t ON icl_t.element_id = tt.term_taxonomy_id AND icl_t.element_type IN ('tax_pa_color') WHERE tt.taxonomy IN ('pa_color') AND ( ( tt.count > 0 OR ( SELECT term_taxonomy.count FROM qtw_term_taxonomy term_taxonomy INNER JOIN qtw_icl_translations translations ON translations.element_id = term_taxonomy.term_taxonomy_id WHERE translations.trid = icl_t.trid AND translations.language_code = 'vi' ) > 0 ) OR ( SELECT term_taxonomy.count FROM qtw_term_taxonomy term_taxonomy INNER JOIN qtw_icl_translations translations ON translations.element_id = term_taxonomy.term_taxonomy_id WHERE translations.trid = icl_t.trid AND translations.language_code = 'vi' ) > 0 ) AND ( ( qtw_termmeta.meta_key = 'order' OR qtw_termmeta.meta_key IS NULL ) ) AND ( ( icl_t.element_type IN ('tax_pa_color') AND ( icl_t.language_code = 'en' OR ( icl_t.language_code = 'vi' AND tt.taxonomy IN ( 'product_cat' ) AND ( ( ( SELECT COUNT(element_id) FROM qtw_icl_translations WHERE trid = icl_t.trid AND language_code = 'en' ) = 0 ) OR ( 0 ) ) ) ) ) OR icl_t.element_type NOT IN ('tax_pa_color') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_pa_color') AND ( icl_t.language_code = 'en' OR ( icl_t.language_code = 'vi' AND tt.taxonomy IN ( 'product_cat' ) AND ( ( ( SELECT COUNT(element_id) FROM qtw_icl_translations WHERE trid = icl_t.trid AND language_code = 'en' ) = 0 ) OR ( 0 ) ) ) ) ) OR icl_t.element_type NOT IN ('tax_pa_color') OR icl_t.element_type IS NULL ) ORDER BY qtw_termmeta.meta_value+0 ASC, t.name ASC