Query editor
WITHlz_summary AS (SELECTuser_address AS ua,COUNT(*) AS tc,CAST(date_trunc('day', MIN(block_time)) AS DATE) AS first_day,CAST(date_trunc('day', MAX(block_time)) AS DATE) AS last_day,0 + IF(bool_or(source_chain_name = 'Optimism'), 1, 0)+ IF(bool_or(source_chain_name = 'Arbitrum'), 2, 0)+ IF(bool_or(source_chain_name = 'Ethereum'), 4, 0)+ IF(bool_or(source_chain_name = 'Polygon'), 8, 0)+ IF(bool_or(source_chain_name = 'BNB Chain'), 16, 0)+ IF(bool_or(source_chain_name = 'Fantom'), 32, 0)+ IF(bool_or(source_chain_name = 'Avalanche'), 64, 0)+ IF(bool_or(source_chain_name = 'Gnosis'), 128, 0)+ IF(bool_or(source_chain_name = 'Base'), 256, 0)+ IF(bool_or(source_chain_name = 'Celo'), 512, 0)AS source_chains_mask,COUNT(DISTINCT date_trunc('day', block_time)) AS daysFROM layerzero.sendGROUP BY user_address),sybil_groups AS (SELECTCOUNT(*) AS sybils_in_group,bool_or(ua = {{address}}) as group_with_address,tc, first_day, last_day, source_chains_mask, daysFROM lz_summaryWHERE tc > 1GROUP BY tc, first_day, last_day, source_chains_mask, days)SELECT sybils_in_group, tc, first_day, last_day, source_chains_mask, daysFROM sybil_groupsWHERE group_with_addressORDER BY sybils_in_group DESC