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 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_00 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_01 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_02 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_03 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_04 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_05 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_06 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_07 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_bscgap_08 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_00 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_01 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_02 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_03 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_04 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_05 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_06 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_07 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_fx_08 UNION ALL SELECT address FROM dune.zdcacaca5306.dataset_lw_00)SELECT DISTINCT '0x'||to_hex(bytearray_substring(topic1,13,20)) lockerFROM ethereum.logsWHERE contract_address=0x5f3b5dfeb7b28cdbd7faba78963ee202a494e2a2 AND topic0=0x4566dfc29f6f11d13a418c26a02bef7c28bae749d4de47e4e6a7cddea6730d59AND bytearray_substring(topic1,13,20) IN (SELECT address FROM mine)