Advertisement
Guest User

Untitled

a guest
Mar 19th, 2019
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. SELECT
  2. t1.field_idproduktu_value, t3.name, t5.name, t7.name, t9.name, t11.name
  3. FROM
  4. field_data_field_idproduktu t1, field_data_field_kategoria_e_katalog_ref t2, taxonomy_term_data t3, taxonomy_term_hierarchy t4,
  5. taxonomy_term_data t5, taxonomy_term_hierarchy t6, taxonomy_term_data t7, taxonomy_term_hierarchy t8, taxonomy_term_data t9, taxonomy_term_hierarchy t10,
  6. taxonomy_term_data t11
  7. WHERE
  8. t1.entity_id = t2.entity_id AND t2.field_kategoria_e_katalog_ref_tid = t3.tid
  9. AND t3.tid = t4.tid AND t4.parent = t5.tid
  10. AND t5.tid = t6.tid AND t6.parent = t7.tid
  11. AND t7.tid = t8.tid AND t8.parent = t9.tid
  12. AND t9.tid = t10.tid AND t10.parent = t11.tid
  13. AND t2.entity_id IN
  14. (SELECT
  15. entity_id
  16. FROM
  17. field_data_field_kategoria_e_katalog_ref
  18. GROUP BY
  19. entity_id
  20. HAVING
  21. COUNT(entity_id) > 1) order by t1.field_idproduktu_value
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement