(case

when contract_address='0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89' then 'kmxSUSHI/USDC-LINK'

when contract_address='0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50' then 'kmWETH/USDT-LINK'

when contract_address='0x4f68e70e3a5308d759961643afcadfc6f74b30f4' then 'kmLINK/USDC-LINK'

when contract_address='0xb7b45754167d65347c93f3b28797887b4b6cd2f3' then 'kmWETH/USDC-LINK'

when contract_address='0x17fb5f39c55903de60e63543067031ce2b2659ee' then 'kmxSUSHI/USDT-LINK'

else contract_address

end) as Kashi_pairs

,count(1) as number from ethereum_core.fact_event_logs where EVENT_NAME='LogAddAsset' and contract_name='KashiPairMediumRiskV1'

group by 1

order by 2 DESC

limit 5