-- forked from Flipside Treasury Payments @ https://flipsidecrypto.xyz/edit/queries/c6354886-4c39-4d2f-952d-f7e0522828bd -- FLOW SELECT DISTINCT recipient as paid_user_wallet FROM flow.core.ez_token_transfers WHERE sender IN ( '0x4fca974d4658d42b', '0x9bd48bb0f0c0fe48', '0x92a125bdd1dc6964' ) AND recipient NOT IN ( '0x4fca974d4658d42b', '09bd48bb0f0c0fe48', '0x92a125bdd1dc6964' ) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND tx_succeeded UNION -- ETH mainnet SELECT DISTINCT to_address as paid_user_wallet FROM ethereum.core.ez_token_transfers WHERE from_address IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x4faFB87de15cFf7448bD0658112F4e4B0d53332c')) AND to_address NOT IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x4faFB87de15cFf7448bD0658112F4e4B0d53332c')) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- AVAX SELECT DISTINCT avax_to_address as paid_wallet_address FROM avalanche.core.ez_avax_transfers WHERE avax_from_address IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0xeD639298998518cCb0405ea675A6198048de4fE3')) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- Axelar SELECT DISTINCT receiver as paid_user_wallet FROM axelar.core.fact_transfers WHERE sender IN ('axelar1cvmw32achlrv8fh0ffyhsyuu4f8lwpzsmxwlnt', 'axelar1ggewp0sdcpcpv87qwfyzm03exkhfmgld88dgpu') AND receiver NOT IN ('axelar1cvmw32achlrv8fh0ffyhsyuu4f8lwpzsmxwlnt', 'axelar1ggewp0sdcpcpv87qwfyzm03exkhfmgld88dgpu') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- NEAR SELECT DISTINCT tx_receiver as paid_user_wallet FROM near.core.fact_transfers WHERE tx_signer IN ('426f0f2383edcb4780b12f509a3731e02a9df32211fe4da8e698e6225fdee383', '79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558') AND tx_receiver NOT IN ('426f0f2383edcb4780b12f509a3731e02a9df32211fe4da8e698e6225fdee383', '79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND status UNION -- Osmosis SELECT DISTINCT receiver as paid_user_wallet FROM osmosis.core.fact_transfers WHERE sender IN ('osmo1cvmw32achlrv8fh0ffyhsyuu4f8lwpzshnt8wc', 'osmo1ggewp0sdcpcpv87qwfyzm03exkhfmgldtjgsu0', 'osmo1ljll6ewqtngm5je40q8pgzxc8j9yvhkssuh2ey') AND receiver NOT IN ('osmo1cvmw32achlrv8fh0ffyhsyuu4f8lwpzshnt8wc', 'osmo1ggewp0sdcpcpv87qwfyzm03exkhfmgldtjgsu0', 'osmo1ljll6ewqtngm5je40q8pgzxc8j9yvhkssuh2ey') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND tx_succeeded UNION -- Polygon SELECT DISTINCT to_address as paid_user_address FROM polygon.core.fact_token_transfers WHERE from_address IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x22AF3aC7Ce20441220C6AeC524854DE03150A4d7')) AND to_address NOT IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x22AF3aC7Ce20441220C6AeC524854DE03150A4d7')) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- Thorchain SELECT DISTINCT to_address as paid_user_address FROM thorchain.core.fact_transfers WHERE from_address IN ('thor12vcn44pdlqzpvm9kr2d4a245jfsg7ufmfr04g9', 'thor1wg6ua25qqvdxz6kqt5paetx7qn3dphnemld7se') AND to_address NOT IN ('thor12vcn44pdlqzpvm9kr2d4a245jfsg7ufmfr04g9', 'thor1wg6ua25qqvdxz6kqt5paetx7qn3dphnemld7se') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- Solana SELECT DISTINCT tx_to FROM solana.core.fact_transfers WHERE block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND tx_from IN ('DwEAXyPRtEJyxtWNCStsfd2sVabzTXmRDzE1Sv6cyjcU', 'FPDwXFUzHYh3uBh68jPZyyvFCoqcGktMX9MTSZPixqkB') AND tx_to NOT IN ('DwEAXyPRtEJyxtWNCStsfd2sVabzTXmRDzE1Sv6cyjcU', 'FPDwXFUzHYh3uBh68jPZyyvFCoqcGktMX9MTSZPixqkB') UNION -- Terra SELECT DISTINCT receiver as paid_user_address FROM terra.core.ez_transfers WHERE block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-01' AND sender in ('terra1v0yhsvk9gzwglu27c02md9z9kmg0vqgrf4q433', 'terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr') AND receiver NOT IN ('terra1v0yhsvk9gzwglu27c02md9z9kmg0vqgrf4q433', 'terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr')

Query	Creator	Created
Flipside Treasury Payments Q1 2023 terra thorchain flow axelar near	jkhuhnke11	Jun 1, 2023
Flipside Treasury Payments terra thorchain flow axelar near	jkhuhnke11	Jun 1, 2023

jkhuhnke11