select block_timestamp,

tx_id,

substr(msg_value:execute_msg:transfer_nft:token_id::string,1,12) AS TokenID,

msg_value:execute_msg:transfer_nft:recipient::string AS owner

from terra.msgs

where msg_value:contract::string = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'

and msg_value:execute_msg:transfer_nft is not null

and tx_status = 'SUCCEEDED'

),

orders AS (

select block_timestamp,

tx_id,

substr(msg_value:execute_msg:execute_order:order:order:maker_asset:info:nft:token_id::string,1,12) AS tokenid,

msg_value:sender::string AS owner

from terra.msgs

where msg_value:contract::string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'

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

and tx_status = 'SUCCEEDED'

)

SELECT transfer_nfts.owner, count(transfer_nfts.tx_id) + count(orders.tx_id) as num_transactions

FROM transfer_nfts INNER JOIN orders ON transfer_nfts.owner = orders.owner

GROUP BY transfer_nfts.owner

ORDER BY num_transactions DESC

LIMIT 17