问使复杂查询更加复杂(需要获得完整的术语路径，而不是一个级别)

EN

SELECT
  field_data_field_products.field_products_product_id AS p1,
  taxonomy_term_data.name AS p2
  c.field_products_product_id AS p1,
  a.name AS p2
FROM taxonomy_term_data
INNER JOIN field_data_field_catalog
  ON taxonomy_term_data.tid = field_data_field_catalog.field_catalog_tid
INNER JOIN field_data_field_products
  ON field_data_field_catalog.entity_id = field_data_field_products.entity_id
INNER JOIN taxonomy_term_hierarchy
ON taxonomy_term_data.tid = taxonomy_term_hierarchy.tid
INNER JOIN taxonomy_term_data a
ON a.tid = taxonomy_term_hierarchy.parent
INNER JOIN field_data_field_catalog b
  ON taxonomy_term_data.tid = b.field_catalog_tid
INNER JOIN field_data_field_products c
  ON b.entity_id = c.entity_id