-- bring back the product assocation ids
-- get the associated product ids from those associations
-- get the info for those associatiod_product ids

SELECT fldProductID,fldProvider,fldAmount FROM defaqto_erc_fee_incentive WHERE 
fldProductID IN

(SELECT da.ASSOCIATED_PRODUCT_ID FROM defaqto_associations as da 

LEFT join defaqto_fixed_data AS d ON d.fldProductID = da.PRODUCT_ID

WHERE d.fldProductID = "189394")

-- AND fldFeeType != 'NULL'

AND fldFeeType IS NOT NULL
;