I'm trying to prefilter a list join from Virtuemart table that is creating multiple duplicate rows in my Fabrik list.
The table is: jos_virtumart_order_userinfos which contains the data for VM shoppers in an order
Shoppers have a billto address and might have a shipto address as well. I want to filter out the duplicates.
here's what I've tried so far with no luck yet:
(SELECT IF ((SELECT COUNT(*) FROM `jos_virtuemart_order_userinfos` WHERE virtuemart_order_id = `jos_vmdropshipping_order`.order_id AND address_type = 'ST') > 0, (SELECT virtuemart_order_userinfo_id FROM `jos_virtuemart_order_userinfos` WHERE virtuemart_order_id = `hm9dh_vmdropshipping_order`.order_id AND address_type = 'ST'), (SELECT virtuemart_order_userinfo_id FROM `jos_virtuemart_order_userinfos` WHERE virtuemart_order_id = `jos_vmdropshipping_order`.order_id AND address_type = 'BT')))
Some insight would be greatly appreciated
Cheers
The table is: jos_virtumart_order_userinfos which contains the data for VM shoppers in an order
Shoppers have a billto address and might have a shipto address as well. I want to filter out the duplicates.
here's what I've tried so far with no luck yet:
(SELECT IF ((SELECT COUNT(*) FROM `jos_virtuemart_order_userinfos` WHERE virtuemart_order_id = `jos_vmdropshipping_order`.order_id AND address_type = 'ST') > 0, (SELECT virtuemart_order_userinfo_id FROM `jos_virtuemart_order_userinfos` WHERE virtuemart_order_id = `hm9dh_vmdropshipping_order`.order_id AND address_type = 'ST'), (SELECT virtuemart_order_userinfo_id FROM `jos_virtuemart_order_userinfos` WHERE virtuemart_order_id = `jos_vmdropshipping_order`.order_id AND address_type = 'BT')))
Some insight would be greatly appreciated
Cheers