Open bro-n-bro-2 opened 8 months ago
@bro-n-bro-0 we discussed it with you few weeks ago, can you check, did we calculate it correctly?
select JSONExtractString(_t, 'delegator_address') as address from (
SELECT JSONExtractString(arrayJoin(JSONExtractArrayRaw(JSONExtractString(msgs)))) as _t FROM spacebox.exec_message
where JSONExtractString(_t, '@type') = '/cosmos.staking.v1beta1.MsgDelegate')
where address = 'cosmos106yp7zw35wftheyyv9f9pe69t8rteumjxjql7m' limit 1
/statistics/get_statistics_validators /statistics/get_statistics_validators__operatoraddress
Seems, like it broken