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)) AS stakerFROM ethereum.logsWHERE contract_address = 0x2b591e99afe9f32eaa6214f7b7629768c40eeb39AND topic0 = 0x14872dc760f33532684e68e1b6d5fd3f71ba7b07dee76bdb2b084f28b74233efAND bytearray_substring(topic1, 13, 20) IN (SELECT address FROM mine)