SELECT x.tokenid, background, body, accessory, head, glasses, 1 as constant

FROM

(select

tokenflow_eth.hextoint(topics[1])::integer as tokenID,

tokenflow_eth.hextoint(substr(data,3,64)) as background,

tokenflow_eth.hextoint(substr(data,67,64)) as body,

tokenflow_eth.hextoint(substr(data,131,64)) as accessory,

tokenflow_eth.hextoint(substr(data,195,64)) as head,

tokenflow_eth.hextoint(substr(data,259,64)) as glasses

from ethereum.core.fact_event_logs

where block_number > 12000000

and contract_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')

and topics[0]::string = '0x1106ee9d020bfbb5ee34cf5535a5fbf024a011bd130078088cbf124ab3092478' )x

RIGHT JOIN (

select a.tokenid

from ethereum.core.ez_nft_mints a

LEFT JOIN ethereum.core.ez_nft_sales b

ON a.tokenid = b.tokenid AND datediff(hour, a.block_timestamp, b.block_timestamp) <= 24

WHERE b.nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')

AND a.nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')

) y

ON y.tokenid = x.tokenid