with mints as (

select

tx_hash,

tokenid

from base.nft.ez_nft_transfers

where nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'

and event_type = 'mint'),

source as (

select

tx_hash,

regexp_substr_all(SUBSTR(data:input, 11, len(data:input)), '.{64}') AS segmented_data

from base.core.fact_traces

where tx_hash in (select tx_hash from mints)

and type = 'CALL')

select

tokenid as brushID,

case

when ethereum.public.udf_hex_to_int(segmented_data[0] :: STRING) = '100' then 'Regular'

when ethereum.public.udf_hex_to_int(segmented_data[0] :: STRING) = '500' then 'Bronze'

when ethereum.public.udf_hex_to_int(segmented_data[0] :: STRING) = '5000' then 'Rare'

when ethereum.public.udf_hex_to_int(segmented_data[0] :: STRING) = '200' then 'Upgraded'

end as Brush_type,

ethereum.public.udf_hex_to_int(segmented_data[0] :: STRING) as strength

from source s inner join mints m on m.tx_hash = s.tx_hash

where brushID = '{{Brush_ID}}'