--msgs.block_id,

--msgs.block_timestamp,

--msgs.tx_id,

--msg_value:sender::string as sender,

-- msg_value:execute_msg:send:amount / POW(10,6) as event_amount,

--msg_value:contract::string as token_address,

--t.address_name as token_address_name,

--msg_value:execute_msg:send:contract::string as contract_address,

--c.address_name as contract_address_name

validator_address_label

,count (validator_address_label )countvalidator

FROM terra.msgs

LEFT OUTER JOIN terra.labels t

ON msg_value:contract = t.address

LEFT OUTER JOIN terra.labels c

ON msg_value:execute_msg:send:contract = c.address

Left outer JOIN

terra.staking s

on s.block_id=terra.msgs.block_id

WHERE msg_type = 'wasm/MsgExecuteContract'

AND msg_value:contract = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' --mine Token Address

AND msg_value:execute_msg:send:contract = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' --mine stak Contract

AND msgs.block_timestamp >= CURRENT_DATE - 30

group by validator_address_label

order by countvalidator desc