WITH s0 AS (

-- sol incinerator txs

SELECT e.tx_id

, e.block_timestamp

, e.inner_instruction:instructions[0]:parsed:info:signers[0]::string AS address

FROM solana.core.fact_events e

WHERE e.block_timestamp >= '2022-12-24'

AND program_id = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'

AND address IS NOT NULL

), s1 AS (

SELECT DISTINCT s.tx_id

, 'Sol Incinerator' AS program

FROM s0

JOIN solana.core.fact_swaps s

ON s.swapper = s0.address

AND s.block_timestamp <= DATEADD('seconds', 60, s0.block_timestamp)

AND s.block_timestamp >= s0.block_timestamp

AND s.swap_to_mint ='DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

WHERE s.block_timestamp >= '2022-12-24'

), t0 AS (

SELECT DISTINCT tx_id

FROM solana.core.fact_transfers

WHERE block_timestamp >= '2022-12-24'

AND mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

), transfers AS (

SELECT DISTINCT tx_id

, CASE WHEN (

tx_from = '8Myhky6nWVJFeNkcBH3FE9i29KqV4qsD8reook3AUqYk'

OR tx_to = '8Myhky6nWVJFeNkcBH3FE9i29KqV4qsD8reook3AUqYk'

) THEN 'Boibook'

WHEN (

tx_from = '5sC34xJvGxQWagAUQtzxqxiqLKyEXaEJZiAzBd812YBM'

OR tx_to = '5sC34xJvGxQWagAUQtzxqxiqLKyEXaEJZiAzBd812YBM'

) THEN 'Quackpot'