3+
- No categories
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_product_cat') LEFT JOIN qtw_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_product_cat')
WHERE tt.taxonomy IN ('product_cat') AND (
( qtw_termmeta.meta_key = 'order' OR qtw_termmeta.meta_key IS NULL )
) AND ( ( icl_t.element_type IN ('tax_product_cat') 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_product_cat') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_product_cat') 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_product_cat') OR icl_t.element_type IS NULL )
ORDER BY qtw_termmeta.meta_value+0 ASC, t.name ASC
WordPress database error: [Not unique table/alias: 'icl_t']
SELECT t.term_id
FROM qtw_terms AS t 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_age') LEFT JOIN qtw_icl_translations icl_t
ON icl_t.element_id = tt.term_taxonomy_id
AND icl_t.element_type IN ('tax_pa_age')
WHERE tt.taxonomy IN ('pa_age') AND t.slug IN ('3') AND ( ( icl_t.element_type IN ('tax_pa_age') 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_age') OR icl_t.element_type IS NULL ) AND ( ( icl_t.element_type IN ('tax_pa_age') 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_age') OR icl_t.element_type IS NULL )
LIMIT 1
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
