ids AS (

SELECT DISTINCT tx_id

FROM thorchain.core.fact_swaps_events INNER JOIN thorchain.core.dim_block

ON fact_swaps_events.dim_block_id = dim_block.dim_block_id

WHERE (pool_name = 'BTC.BTC')

AND ((SPLIT(memo, ':')[2] = 'thor15cl4m94khtlt20p4s6k5vkfhrqxasl2r7rgsv6')

OR ((IFNULL(SPLIT(memo, ':')[2], '') = '')

AND (from_address = 'thor15cl4m94khtlt20p4s6k5vkfhrqxasl2r7rgsv6')))

--AND (to_asset = 'THOR.RUNE')

AND (block_id BETWEEN 4610718 and 8195055)

SELECT DISTINCT asset, COUNT(*) OVER(PARTITION BY asset) AS feenumber

FROM thorchain.core.fact_fee_events INNER JOIN thorchain.core.dim_block

ON fact_fee_events.dim_block_id = dim_block.dim_block_id

WHERE (fact_fee_events.tx_id IN (SELECT tx_id FROM ids))

AND (block_id BETWEEN 4610718 and 8195055)