SELECT bull_id, token_id, IFF(background <> '', background, 'none') as background, IFF(eyes <> '', eyes, 'none') as eyes, IFF(glasses <> '', glasses, 'none') as glasses, IFF(hats <> '', hats, 'none') as hats, IFF(head <> '', head, 'none') as head, IFF(horn <> '', horn, 'none') as horn, IFF(nose <> '', nose, 'none') as nose, IFF(noserings <> '', noserings, 'none') as noserings, IFF(pants <> '', pants, 'none') as pants, IFF(shoes <> '', shoes, 'none') as shoes, IFF(sword <> '', sword, 'none') as sword, IFF(tops <> '', tops, 'none') as tops FROM ( SELECT msg_value:execute_msg:redeem_reservation:request:extension:name::string as bull_id, msg_value:execute_msg:redeem_reservation:request:token_id::decimal as token_id, MAX(IFF(F.Value:trait_type::string = 'BACKGROUND', F.Value:value::string, '')) as background, MAX(IFF(F.Value:trait_type::string = 'EYES', F.Value:value::string, '')) as eyes, MAX(IFF(F.Value:trait_type::string = 'GLASSES', F.Value:value::string, '')) as glasses, MAX(IFF(F.Value:trait_type::string = 'HATS', F.Value:value::string, '')) as hats, MAX(IFF(F.Value:trait_type::string = 'HEAD', F.Value:value::string, '')) as head, MAX(IFF(F.Value:trait_type::string = 'HORNS', F.Value:value::string, '')) as horn, MAX(IFF(F.Value:trait_type::string = 'NOSE', F.Value:value::string, '')) as nose, MAX(IFF(F.Value:trait_type::string = 'NOSERINGS', F.Value:value::string, '')) as noserings, MAX(IFF(F.Value:trait_type::string = 'PANTS', F.Value:value::string, '')) as pants, MAX(IFF(F.Value:trait_type::string = 'SHOES', F.Value:value::string, '')) as shoes, MAX(IFF(F.Value:trait_type::string = 'SWORD', F.Value:value::string, '')) as sword, MAX(IFF(F.Value:trait_type::string = 'TOPS', F.Value:value::string, '')) as tops FROM terra.msgs, LATERAL FLATTEN(input => msg_value:execute_msg:redeem_reservation:request:extension:attributes) F WHERE msg_value:execute_msg:redeem_reservation is not null AND msg_value:contract = 'terra1mpuuxpaqnhkmtngkj773u7kr5p7zv9nfwe8wh6' AND tx_status = 'SUCCEEDED' GROUP BY bull_id, token_id ) ORDER BY token_id

Query	Creator	Created
Caffeine Club Rarity Scrape	nikolai828x	Mar 29, 2022
Untitled Query	nikolai828x	Jan 6, 2022

nikolai828x