RE_events AS (

SELECT

block_timestamp,

tx_id,

event_attributes

FROM

terra.msg_events

WHERE event_attributes:action = 'execute_orders'

AND event_type = 'from_contract'

AND tx_status = 'SUCCEEDED'

),

RE_takers AS (

SELECT DISTINCT

tx_id,

msg_value:sender as taker

FROM

terra.msgs

WHERE

tx_id IN (SELECT DISTINCT tx_id FROM RE_events)

),

allSales AS

SELECT

block_timestamp,

tx_id,

platform,

nft_from,

nft_to,

nft_address,

amount,

denom,

tokenid

FROM (