Untitled Query

nitsUntitled Query

Updated 2022-02-16

SELECT *, msg_value:exceute_msg:deposit:asset:info:nft,msg_value:exceute_msg:ledger_proxy: from terra.msgs

where msg_value:contract = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'

limit 100

-- WHEN nft_contract_address = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' THEN 'Galactic Punks'

-- WHEN nft_contract_address = 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' THEN 'LunaBulls'

-- WHEN nft_contract_address = 'terra1vhuyuwwr4rkdpez5f5lmuqavut28h5dt29rpn6' THEN 'Levana Dragons'

-- WHEN nft_contract_address = 'terra1k0y373yxqne22pc9g7jvnr4qclpsxtafevtrpg' THEN 'Levana Dragon: Eggs'

-- WHEN nft_contract_address = 'terra1p70x7jkqhf37qa7qm4v23g4u4g8ka4ktxudxa7' THEN 'Levana Dragons: Meteor Dust'

-- WHEN nft_contract_address = 'terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v' THEN 'Levana Dragons: Meteors'

-- WHEN nft_contract_address = 'terra14gfnxnwl0yz6njzet4n33erq5n70wt79nm24el' THEN 'Levana Dragons: Loot'

-- WHEN nft_contract_address = 'terra1zvmesqul8ss2ty84eml8aqkq0kq5ydwjuyf6a3' THEN 'BabyBulls'

-- WHEN nft_contract_address = 'terra1598rvtgufwr7pnpqhrlajjrmvte4l8a6xkty6y' THEN 'Galactic Baby Ape Clup'

-- WHEN nft_contract_address = 'terra1lfr4aja5a2xpxvnrl4gyjpru0wwglu7k87jmeq' THEN 'Hero'

-- WHEN nft_contract_address = 'terra1sux7jjk9vfd0q6z0l99wpg07yd0wme0ac9le40' THEN 'The Crunks'

-- WHEN nft_contract_address = 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' THEN 'Styllar'

-- WHEN nft_contract_address = 'terra1wcdapxh8030czdketyfemsa7lndsmpmk2e76l5' THEN 'WagmiKongz'

-- WHEN nft_contract_address = 'terra1jp5fjj7rlc0erw4z3qr5zuvmg2w49pfzyhvsnk' THEN 'WagmiMonkeez'

-- WHEN nft_contract_address = 'terra1jdt2wnfhgy4ptk6m5kxacyj0k6e8rc7e2ugulz' THEN 'TerraWhales'

-- WHEN nft_contract_address = 'terra13ptfhnrl7n2zcq8369s39a5eqg85xxtj77jtuh' THEN 'Astroverse x Vinboy'

-- WHEN nft_contract_address = 'terra1xv0as2esvwqcuaqtdhvrdhykrfe75qw42tgh6f' THEN 'Astroverse #02'

-- WHEN nft_contract_address = 'terra1y076t8yrj0t4ag969w92ez9qfdj0c6dn7xhmkq' THEN 'Astroverse'

-- WHEN nft_contract_address = 'terra1me5q9trnuvxg8yg2hxzuvlr9h6ej3a5lrpccq9' THEN 'DObble-Heads'

-- WHEN nft_contract_address = 'terra1gek0c83grmj6twdr8c9al00hagd4kw5lxlt0cu' THEN 'Styllar Items'

-- WHEN nft_contract_address = 'terra18d5cqlsqgxp8w7ysn48l4r8a5328592wfwjtyz' THEN 'LunaBulls 3D'

-- WHEN nft_contract_address = 'terra1ca9peph7c20eqr9cns2vhn6sp6cp7vv4jnzjrc' THEN 'Derby Stars'

-- WHEN nft_contract_address = 'terra1h6msx3t0qj7fuhssyqc44g20qwwyz35zqel96l' THEN 'Poppin Puffins'

-- WHEN nft_contract_address = 'terra1ycp3azjymqckrdlzpp88zfyk6x09m658c2c63d' THEN 'Space Toadz'

-- WHEN nft_contract_address = 'terra1tv5hu9d2hw4q9tn4x30870ae0e4mrttqj0fcv6' THEN 'Deviants Factions'

-- WHEN nft_contract_address = 'terra1f89xq3qhu98v4jch4y5xcrkhl9gytrne99x74t' THEN 'Terrapins on Terra'

-- WHEN nft_contract_address = 'terra180tvldnt7h3lts6sp0n3kq7x496sf8cuvqf4xd' THEN 'Luna Monkey Business'

-- WHEN nft_contract_address = 'terra1l678rednwh5vdsk06zl6ld6je5jkvrslsed6sr' THEN 'Goochi Land'

-- WHEN nft_contract_address = 'terra1hj0dga445h3faxu85gm0293608qntsj3a727ck' THEN 'TerraBots'

-- WHEN nft_contract_address = 'terra1fnv8f2202zgsnvpju7auehmygmdfj93xls8x0s' THEN 'Goochi Goochi'

Run a query to Download Data

flipside