(select

tx_hash,

max(case when CONTRACT_ADDRESS = lower('0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c') then 1 else 0 end) as from_token,

max(case when CONTRACT_ADDRESS = lower('0x0D8Ce2A99Bb6e3B7Db580eD848240e4a0F9aE153') then 1 else 0 end) as to_token,

min(case when origin_to_address = '0x10ed43c718714eb63d5aa57b78b54704e256024e' then 'a.PancakeSwap' else 'b.Others' end) as provider

from bsc.core.fact_event_logs

where

-- tx_hash = '0xbc0ae3201dd7280504f6a7a9aa963f320dec87382e729a5e37bdea0bd7d6b350' and

BLOCK_TIMESTAMP >= cast('2022-02-10' as timestamp)

-- and BLOCK_NUMBER = 25113075

group by 1)

select * from base where from_token = 1 and to_token = 1 limit 1000