campaign_names AS (

SELECT

INPUTS[0]:value AS campaignID

, CASE INPUTS[0]:value

WHEN 1 THEN 'zkLend'

WHEN 2 THEN 'Nostra'

WHEN 3 THEN 'mySwap'

WHEN 4 THEN 'Fibrous'

WHEN 5 THEN 'Braavos'

WHEN 6 THEN 'Unframed'

ELSE 'CHECK'

END AS campaignName

, TX_HASH AS hash

FROM external.tokenflow_starknet.decoded_traces

WHERE CHAIN_ID = 'mainnet'

AND CONTRACT = '0x0106c94dc954944b3893e2102d9ad5065d04a0ec9b08910891d8eedb75965334'

AND FUNCTION = 'mint'

, tokenIDs_and_campaign_names AS (

SELECT

ev.PARAMETERS[2]:value[0]:value AS tokenID

, cn.campaignName AS campaignName

, cn.campaignID AS campaignID

, CONCAT((ev.PARAMETERS[2]:value[0]:value), cn.campaignName) AS tokenIDandCampaignName

, ev.TX_HASH AS hash

FROM external.tokenflow_starknet.decoded_events ev

LEFT JOIN campaign_names cn ON ev.TX_HASH = cn.hash

WHERE CHAIN_ID = 'mainnet'

AND CONTRACT = '0x0106c94dc954944b3893e2102d9ad5065d04a0ec9b08910891d8eedb75965334'

AND NAME = 'Transfer'

AND PARAMETERS[0]:value = 0

AND TX_HASH IN (SELECT hash FROM campaign_names)