from terra.msgs

where msg_value:contract::string = 'terra16wuzgsx3tz4hkqu73q5s7unxenefkkvefvewsh' and msg_value:execute_msg:reserve_nft:operator::string = 'terra1lglmepz64mlcus2f7zq9gxzhtucpf080hf0997'

and tx_status = 'SUCCEEDED')

select msg_value:sender::string as buyer, count (distinct msg_value:execute_msg:execute_order:order:order:maker_asset:info:nft:token_id::string) as GP_bought

from terra.msgs

where msg_value:sender::string in (select minter from minter)

and msg_value:execute_msg:execute_order:order:order:maker_asset:info:nft:contract_addr::string = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'

and msg_value:execute_msg:execute_order:order:order:maker_asset:info:nft:token_id::string is not null and tx_status = 'SUCCEEDED'

group by 1