binhachon3. [Easy] Brace for (Meteor) Impact - Meteor cracked by rarity
Updated 2021-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with meteor_data as(
select block_timestamp, msg_value:execute_msg:mint:owner::string as owner,
msg_value:execute_msg:mint:token_id::string as token_id,
msg_value:execute_msg:mint:extension:attributes[0]:value::string as rarity,
msg_value:execute_msg:mint:extension:attributes[1]:value::string as rank,
msg_value:execute_msg:mint:extension:attributes[2]:value::string as shower,
msg_value
from terra.msgs
where msg_value:contract::string = 'terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v'
and msg_value:sender::string = 'terra1v7v2nqs7flrpqqam7l5ulvnva8ly8j653sw4n3'
and msg_value:execute_msg:mint is not null
and tx_status = 'SUCCEEDED'),
egg_data as(
select block_timestamp,
msg_value:execute_msg:mint:owner::string as owner,
msg_value:execute_msg:mint:token_id::float as token_id,
msg_value:execute_msg:mint:extension:attributes[0]:value::string as rarity,
msg_value:execute_msg:mint:extension:attributes[1]:value::string as rank,
case
when msg_value:execute_msg:mint:extension:attributes[0]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[0]:value::string
when msg_value:execute_msg:mint:extension:attributes[1]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[1]:value::string
when msg_value:execute_msg:mint:extension:attributes[2]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[2]:value::string
when msg_value:execute_msg:mint:extension:attributes[3]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[3]:value::string
when msg_value:execute_msg:mint:extension:attributes[4]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[4]:value::string
when msg_value:execute_msg:mint:extension:attributes[5]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[5]:value::string
when msg_value:execute_msg:mint:extension:attributes[6]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[6]:value::string
when msg_value:execute_msg:mint:extension:attributes[7]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[7]:value::string
when msg_value:execute_msg:mint:extension:attributes[8]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[8]:value::string
when msg_value:execute_msg:mint:extension:attributes[9]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[9]:value::string
when msg_value:execute_msg:mint:extension:attributes[10]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[10]:value::string
when msg_value:execute_msg:mint:extension:attributes[11]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[11]:value::string
when msg_value:execute_msg:mint:extension:attributes[12]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[12]:value::string
when msg_value:execute_msg:mint:extension:attributes[13]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[13]:value::string
when msg_value:execute_msg:mint:extension:attributes[14]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[14]:value::string
when msg_value:execute_msg:mint:extension:attributes[15]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[15]:value::string
when msg_value:execute_msg:mint:extension:attributes[16]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[16]:value::string
Run a query to Download Data