Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- t1.field_idproduktu_value, t3.name, t5.name, t7.name, t9.name, t11.name
- FROM
- field_data_field_idproduktu t1, field_data_field_kategoria_e_katalog_ref t2, taxonomy_term_data t3, taxonomy_term_hierarchy t4,
- taxonomy_term_data t5, taxonomy_term_hierarchy t6, taxonomy_term_data t7, taxonomy_term_hierarchy t8, taxonomy_term_data t9, taxonomy_term_hierarchy t10,
- taxonomy_term_data t11
- WHERE
- t1.entity_id = t2.entity_id AND t2.field_kategoria_e_katalog_ref_tid = t3.tid
- AND t3.tid = t4.tid AND t4.parent = t5.tid
- AND t5.tid = t6.tid AND t6.parent = t7.tid
- AND t7.tid = t8.tid AND t8.parent = t9.tid
- AND t9.tid = t10.tid AND t10.parent = t11.tid
- AND t2.entity_id IN
- (SELECT
- entity_id
- FROM
- field_data_field_kategoria_e_katalog_ref
- GROUP BY
- entity_id
- HAVING
- COUNT(entity_id) > 1) order by t1.field_idproduktu_value
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement