iboo-jbj2MV147 - Swing and a Miss Count Overall
Updated 2022-02-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT COUNT(tx_id) AS NUM_TXS, tx_status, CASE WHEN msg_value:execute_msg:initiate_transfer:recipient_chain != 3 THEN 'Terra' END AS name_source,
CASE WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 1 THEN 'Solana'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 2 THEN 'Ethereum'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 3 THEN 'Terra'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 4 THEN 'BSC'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 5 THEN 'Polygon'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 6 THEN 'Avax'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 7 THEN 'Oasis'
END AS name_recipient
FROM terra.msgs AS msgs
WHERE msgs.chain_id = 'columbus-5'
AND msgs.msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
AND msgs.msg_value:contract IS NOT NULL
AND msgs.msg_value:execute_msg:initiate_transfer:recipient_chain IS NOT NULL
AND tx_status = 'FAILED'
GROUP BY 2, 3, 4
Run a query to Download Data