from optimism.core.fact_token_transfers join (select date(block_timestamp) as claim_date, event_inputs:recipient as claimer,

event_inputs:amount/1e18 as claimed_amount

from optimism.core.fact_event_logs

where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

and origin_function_signature = '0x2e7ba6ef' and claimed_amount > 0

and event_name = 'Claimed' ) as claiming

on optimism.core.fact_token_transfers.from_address = claiming.claimer

where contract_address = '0x4200000000000000000000000000000000000042'

and optimism.core.fact_token_transfers.block_timestamp > claim_date

and optimism.core.fact_token_transfers.block_timestamp <= current_date - 1),

non_holding2 as (select origin_from_address as non_holding_wallets

from optimism.core.fact_event_logs join (select date(block_timestamp) as claim_date, event_inputs:recipient as claimer,

event_inputs:amount/1e18 as claimed_amount

from optimism.core.fact_event_logs

where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

and origin_function_signature = '0x2e7ba6ef' and claimed_amount > 0

and event_name = 'Claimed' ) as claiming

on optimism.core.fact_event_logs.origin_from_address = claiming.claimer

where contract_address = '0x4200000000000000000000000000000000000042'

and origin_from_address = event_inputs:from

and optimism.core.fact_event_logs.block_timestamp > claim_date

and optimism.core.fact_event_logs.block_timestamp <= current_date - 1

and claimed_amount > 0),

non_holding3 as (select delegator as non_holding_wallets

from optimism.core.fact_delegations join (select date(block_timestamp) as claim_date, event_inputs:recipient as claimer,

event_inputs:amount/1e18 as claimed_amount

from optimism.core.fact_event_logs

where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

and origin_function_signature = '0x2e7ba6ef' and claimed_amount > 0

and event_name = 'Claimed' ) as claiming

on optimism.core.fact_delegations.delegator = claiming.claimer

where status = 'SUCCESS'

and optimism.core.fact_delegations.block_timestamp > claim_date

and optimism.core.fact_delegations.block_timestamp <= current_date - 1

and claimed_amount >0),