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

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

select tx_hash from bsc.core.fact_decoded_event_logs

where event_name='FinishedOperatorJob'

group by 1