date(block_timestamp) as dates,

msg_value:execute_msg:ledger_proxy:msg:execute_order:order:order:maker_asset:info:nft:contract_addr::string as nft_maker,

msg_value:execute_msg:ledger_proxy:msg:execute_order:order:order:taker_asset:info:nft:contract_addr::string as nft_taker, case

when nft_maker is not null then nft_maker

when nft_maker is null then nft_taker end as nft_contract_address,

(msg_value:execute_msg:ledger_proxy:msg:execute_order:order:order:taker_asset:amount::int)/1000000 as amount

from terra.msgs

where msg_value:contract::string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'

and tx_status = 'SUCCEEDED'

and (msg_value:execute_msg:execute_order is not null or msg_value:execute_msg:ledger_proxy:msg:execute_order is not null)

)

select

nft_contract_address, CASE

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'