thoraddresses AS

SELECT DISTINCT from_address AS address

FROM thorchain.liquidity_actions

WHERE (pool_name LIKE 'TERRA.%')

AND (block_id BETWEEN 5532105 AND 5744097)

AND (SUBSTR(from_address, 1, 4) = 'thor')

),

addresses1 AS

SELECT DISTINCT from_address AS address

FROM thorchain.swaps

WHERE native_to_address IN (SELECT * FROM thoraddresses)

),

addresses2 AS

SELECT DISTINCT native_to_address AS address

FROM thorchain.swaps

WHERE (from_address IN (SELECT * FROM thoraddresses))

AND (native_to_address <> '')

),

addresses3 AS

SELECT DISTINCT address

FROM (

(SELECT * FROM thoraddresses)

UNION ALL

(SELECT * FROM addresses1)

UNION ALL

(SELECT * FROM addresses2)

)

),