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)) usr,bytearray_to_uint256(topic2) pidFROM bnb.logsWHERE contract_address=0xa5f8c5dbd5f286960b9d90548680ae5ebff07652 AND topic0=0x90890809c654f11d6e72a28fa60149770a0d11ec6c92319d6ceb2bb0a4ea1a15AND bytearray_substring(topic1,13,20) IN (SELECT address FROM mine)