List joins Prefilter with conditional logic

[Metabern]

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

 

[cheesegrits]

Does that query produce a result set when run in a MySQL client?

Are you using "IN" and type "query"?

-- hugh