WITH dao_amm_mapping AS (

SELECT DISTINCT

CASE dao_pubkey

WHEN '5n61x4BeVvvRMcYBMaorhu1MaZDViYw6HghE8gwLCvPR' THEN 'Sanctum'

WHEN '9RNQx6cnheD4tzvRCW5Mo1sTo72Vm6PbPj6SFC5aK4fy' THEN 'Marinade'

WHEN 'B3PDBD7NCsJyxSdSDFEK38oNKZMBrgkg46TuqqkgAwPp' THEN 'Jito'

WHEN '5vVCYQHPd8o3pGejYWzKZtnUSdLjXzDZcjZQxiFumXXx' THEN 'Drift'

WHEN '3LGGRzLrgwhEbEsNYBSTZc5MLve1bw3nDaHzzfJMQ1PG' THEN 'Coal'

WHEN 'ofvb3CPvEyRfD5az8PAqW6ATpPqVBeiB5zBnpPR5cgm' THEN 'FutureDAO'

WHEN '9TKh2yav4WpSNkFV2cLybrWZETBWZBkQ6WB6qV9Nt9dJ' THEN 'Deans List'

WHEN 'CNMZgxYsQpygk8CLN9Su1igwXX2kHtcawaNAGuBPv3G9' THEN 'MetaDAO'

WHEN '7XoddQu6HtEeHZowzCEwKiFJg4zR3BXUqMygvwPwSB1D' THEN 'Ore'

WHEN '4WRHiYEUw2vJh38frofFFEdsxmZN6PVcUshAh6MNcvHy' THEN 'Kollan House'

WHEN '6uY9NohsBFGF1BafttPNZtJ4uyNbYKaNToL169nEegox' THEN 'mtnCapital'

WHEN '4jwpLPehFNs3orsi3MoK6BdBQ9axCXxYrB8hJwLnewYC' THEN 'Save'

ELSE 'Unknown'

END AS dao_name,

pass_amm,

fail_amm,

pass_lp_mint,

fail_lp_mint,

proposal

FROM (

SELECT

MAX(CASE WHEN f.value:name = 'dao' THEN f.value:pubkey END) AS dao_pubkey,

MAX(CASE WHEN f.value:name = 'proposal' THEN f.value:pubkey END) AS proposal,

MAX(CASE WHEN f.value:name = 'passAmm' THEN f.value:pubkey END) AS pass_amm,

MAX(CASE WHEN f.value:name = 'failAmm' THEN f.value:pubkey END) AS fail_amm,

MAX(CASE WHEN f.value:name = 'passLpMint' THEN f.value:pubkey END) AS pass_lp_mint,

MAX(CASE WHEN f.value:name = 'failLpMint' THEN f.value:pubkey END) AS fail_lp_mint

FROM solana.core.fact_decoded_instructions,

LATERAL FLATTEN(input => decoded_instruction:accounts) f

WHERE program_id IN ('autoQP9RmUNkzzKRXsMkWicDVZ3h29vvyMDcAYjCxxg', 'autowMzCbM29YXMgVG3T62Hkgo7RcyrvgQQkd54fDQL')

AND event_type = 'initializeProposal'