where label = 'anchor' or label = 'mirror' or label = 'pylon'

or label = 'astroport')

SELECT *, row_number() over (partition byorder by total_txs desc ) as rn

from (SELECT * from

(SELECT msg_value:contract as ctr, contract_name, count(*) as total_txs, count(DISTINCT msg_value:sender) as unique_interactions

from

*, case when msg_value:contract = 'terra1angxk38zehp0k09m0wqrrxf0r3ces6qjj432l8' then 'prism' -- forge -- https://finder.extraterrestrial.money/mainnet/projects/Prism

when msg_value:contract = 'terra1fyyq65sfltsnj53jdfsf6dammdfhjnelt9eh72' then 'prism' -- vesting

when msg_value:contract = 'terra1h4al753uvwmhxwhn2dlvm9gfk0jkf52xqasmq2' then 'prism' -- gov

when msg_value:contract = 'terra1xw3h7jsmxvh6zse74e4099c6gl03fnmxpep76h' then 'prism' -- luna vault

when msg_value:contract = 'terra1p7jp8vlt57cf8qwazjg58qngwvarmszsamzaru' then 'prism' -- yluna stake

when msg_value:contract = 'terra1u600u35p84fntlk5cnwvy373s2qzk903qnsdyf' then 'prism' -- airdrop

when msg_value:contract = 'terra1yxgq5y6mw30xy9mmvz9mllneddy9jaxndrphvk' then 'prism' -- cluna lp

when msg_value:contract = 'terra1persuahr6f8fm6nyup0xjc7aveaur89nwgs5vs' then 'prism' -- pluna lp

when msg_value:contract = 'terra1kqc65n5060rtvcgcktsxycdt2a4r67q2zlvhce' then 'prism' -- yluna lp

when msg_value:contract = 'terra1r38qlqt69lez4nja5h56qwf4drzjpnu8gz04jd' then 'prism' -- yluna lp

when msg_value:contract = 'terra1n38982txtv2yygtcfv3e9wp2ktmjyxl6z88rma' then 'mars' -- mars lockdrop

when msg_value:contract = 'terra1hgyamk2kcy3stqx82wrnsklw9aq7rask5dxfds' then 'mars' -- mars lppair lockdrop

end as lbl , case when label is NULL then lbl else label end as contract_name

from terra.msgs

left join labels

on msg_value:contract = address )

where contract_name is Not NULL

GROUP by 1,2 )

inner join terra.labels on ctr = address or address in ('terra1angxk38zehp0k09m0wqrrxf0r3ces6qjj432l8','terra1fyyq65sfltsnj53jdfsf6dammdfhjnelt9eh72', 'terra1h4al753uvwmhxwhn2dlvm9gfk0jkf52xqasmq2',

'terra1xw3h7jsmxvh6zse74e4099c6gl03fnmxpep76h', 'terra1p7jp8vlt57cf8qwazjg58qngwvarmszsamzaru', 'terra1u600u35p84fntlk5cnwvy373s2qzk903qnsdyf', 'terra1yxgq5y6mw30xy9mmvz9mllneddy9jaxndrphvk',

'terra1persuahr6f8fm6nyup0xjc7aveaur89nwgs5vs', 'terra1kqc65n5060rtvcgcktsxycdt2a4r67q2zlvhce', 'terra1r38qlqt69lez4nja5h56qwf4drzjpnu8gz04jd', 'terra1n38982txtv2yygtcfv3e9wp2ktmjyxl6z88rma', 'terra1hgyamk2kcy3stqx82wrnsklw9aq7rask5dxfds')

)

where rn < '3'

order by total_txs desc

limit 20