original_holders as (

SELECT tx."FROM_ADDRESS" as original_holder, ev.EVENT_INPUTS:tokenId::string as tokenid FROM ethereum.transactions tx

LEFT JOIN ethereum.events_emitted ev ON tx."TX_ID"=ev."TX_ID"

WHERE tx."TO_ADDRESS"=Lower('0x1283ff14fB1dE447955af429af05eaFE959d2639')

AND ev."EVENT_NAME" = 'Transfer'

AND ev.EVENT_INPUTS:from = '0x0000000000000000000000000000000000000000'

),

all_buyers as (

SELECT tx."TO_ADDRESS" as buyer, ev.EVENT_INPUTS:tokenId::string as tokenid FROM ethereum.transactions tx

LEFT JOIN ethereum.events_emitted ev ON tx."TX_ID"=ev."TX_ID"

WHERE tx."TO_ADDRESS"=Lower('0x1283ff14fB1dE447955af429af05eaFE959d2639')

AND ev."EVENT_NAME" = 'Transfer'

AND ev.EVENT_INPUTS:from != '0x0000000000000000000000000000000000000000'

)

SELECT original_holder, oh."tokenid", buyer

FROM original_holders oh

LEFT JOIN all_buyers ab ON oh."tokenid" =ab."tokenid"