with hlg_contracts_bsc as

select

CONTRACT_ADDRESS as address

from bsc.core.fact_event_logs

where 1=1

and block_timestamp >= '2022-11-01 00:00:00'

and origin_to_address in

('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55',

'0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')

and CONTRACT_ADDRESS not in

('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55',

'0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')

group by contract_address

),

NFTs_table as (

select

contract_address as contract,

topics[3] as tokenId,

topics[0] as topics_0,

topics[1] as topics_1,

topics[3] as topics_3

from bsc.core.fact_event_logs

where 1=1

and block_timestamp >= '2022-11-01 00:00:00'

and contract_address in (select address from hlg_contracts_bsc group by 1)

and topics_0='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND topics_1 = '0x0000000000000000000000000000000000000000000000000000000000000000'

and topics_3 is not null

and tx_hash not in