SELECT

-- block_timestamp,

tx_id,

index,

-- instruction,

-- inner_instruction,

(CASE WHEN inner_instruction like '%initializeMint%' THEN 'incrLiquidity'

WHEN inner_instruction like '%burnChecked%' THEN 'decrLiquidity'

WHEN inner_instruction like '%transfer%' THEN 'transfer'

WHEN inner_instruction like '%createAccount%' THEN 'createAccount'

ELSE NULL END) AS user_action,

(CASE WHEN user_action = 'incrLiquidity' THEN substring(inner_instruction, CHARINDEX('mintAuthority', inner_instruction) + 16, 44)

WHEN user_action = 'decrLiquidity' THEN NULL

WHEN instruction['accounts'][0] = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA' AND user_action = 'transfer'

THEN inner_instruction['instructions'][1]['parsed']['info'].authority

ELSE instruction['accounts'][0] END) AS trx_authority,

(CASE WHEN user_action = 'incrLiquidity' THEN substring(inner_instruction, CHARINDEX('mint', inner_instruction) + 7, 44)

WHEN user_action = 'decrLiquidity' THEN substring(inner_instruction, CHARINDEX('mint', inner_instruction) + 7, 44)

ELSE NULL END) AS lp_token

FROM

solana.core.fact_events

WHERE

program_id = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' -- ORCA WHIRLPOOL PROGRAM

--AND tx_id = '2WUA6Ng3adM88XwpEmxWbmCxks8Kee7zZYRejVwtJYrwh5b6y2g3uTYHzBMgN1UFP9ifJMGiZ6q4m59t1zKBVoJo'

AND succeeded = 'TRUE'

),

mint_pool AS (

SELECT

trx_authority as authority,

lp_token

FROM whirlpool_events

WHERE user_action = 'incrLiquidity'