Query editor
WITH mine AS (SELECT address FROM dune.zdcacaca5306.dataset_cand_000 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_001 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_002 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_003 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_004 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_005 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_006 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_007 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_008 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_009 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_010 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_011 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_012 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_013 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_014 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_015 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_016 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_017 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_018 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_019 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_020 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_021 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_022 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_023 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_024 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_025 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_026 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_027 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_028 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_029 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_030 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_031 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_032 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_033 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_cand_034)SELECT '0x'||to_hex(a) address FROM (SELECT "from" a FROM tokens_bnb.transfers WHERE "from" IN (SELECT address FROM mine)UNION ALLSELECT "to" a FROM tokens_bnb.transfers WHERE "to" IN (SELECT address FROM mine)) xGROUP BY 1