affiliate_address,

FROM thorchain.defi.fact_swaps

WHERE affiliate_address IS NOT NULL

AND affiliate_address NOT LIKE 'thor%'

GROUP BY affiliate_address, AFFILIATE_FEE_BASIS_POINTS

ORDER BY affiliate_address ASC ;