select antecedent_items, p2.attribute_subname as consequent_item, p0.support, confidence, lift, p3.number_of_items from dm$p0assoc_ap_1_1 p0 left outer join ( select ip4.itemset_id, listagg(ip2.attribute_subname, ',') within group (order by ip2.item_id) as antecedent_items from dm$p4assoc_ap_1_1 ip4 left join dm$p2assoc_ap_1_1 ip2 on ip2.item_id = ip4.item_id group by ip4.itemset_id ) p4 on p4.itemset_id = p0.antecedent_itemset_id left outer join dm$p2assoc_ap_1_1 p2 on p2.item_id = p0.consequent_itemset_id left outer join dm$p3assoc_ap_1_1 p3 on p3.itemset_id = p0.antecedent_itemset_id
