from cosmos.core.fact_msg_attributes where MSG_TYPE ='redelegate'

),

source_valid as (select BLOCK_TIMESTAMP,tx_id,ATTRIBUTE_VALUE as voter

from cosmos.core.fact_msg_attributes where tx_id in (select tx_id from redel)

and MSG_TYPE='redelegate'

and ATTRIBUTE_KEY ='source_validator'

and BLOCK_TIMESTAMP>='2022-11-14 03:03:04'

),

destination_valid as (select BLOCK_TIMESTAMP,tx_id,ATTRIBUTE_VALUE as voter

from cosmos.core.fact_msg_attributes where tx_id in (select tx_id from redel)

and MSG_TYPE='redelegate'

and ATTRIBUTE_KEY ='destination_validator'

and BLOCK_TIMESTAMP>='2022-11-14 03:03:04'

select

when a.voter ='cosmosvaloper1sjllsnramtg3ewxqwwrwjxfgc4n4ef9u2lcnj0' then '1-stake.fish'

when a.voter ='cosmosvaloper1c4k24jzduc365kywrsvf5ujz4ya6mwympnc4en' then '2-Coinbase Custody'

when a.voter ='cosmosvaloper14lultfckehtszvzw4ehu0apvsr77afvyju5zzy' then '3-DokiaCapital'

when a.voter ='cosmosvaloper1v5y0tg0jllvxf5c3afml8s3awue0ymju89frut' then '4-Zero Knowledge Validator (ZKV)'

when a.voter ='cosmosvaloper196ax4vc0lwpxndu9dyhvca7jhxp70rmcvrj90c' then '5-SG-1'

when a.voter ='cosmosvaloper18ruzecmqj9pv8ac0gvkgryuc7u004te9rh7w5s' then '6-Binance Node'

when a.voter ='cosmosvaloper14k4pzckkre6uxxyd2lnhnpp8sngys9m6hl6ml7' then '7-Polychain'

when a.voter ='cosmosvaloper1tflk30mq5vgqjdly92kkhhq3raev2hnz6eete3' then '8-Everstake'

when a.voter ='cosmosvaloper1qaa9zej9a0ge3ugpx3pxyx602lxh3ztqgfnp42' then '9-GAME'

when a.voter ='cosmosvaloper19lss6zgdh5vvcpjhfftdghrpsw7a4434elpwpu' then '10-Paradigm'

when a.voter ='cosmosvaloper1ey69r37gfxvxg62sh4r0ktpuc46pzjrm873ae8' then '11-Sikka'

when a.voter ='cosmosvaloper1hjct6q7npsspsg3dgvzk3sdf89spmlpfdn6m9d' then '12-Figment'

when a.voter ='cosmosvaloper1clpqr4nrk4khgkxj78fcwwh6dl3uw4epsluffn' then '13-Cosmostation'

when a.voter ='cosmosvaloper156gqf9837u7d4c4678yt3rl4ls9c5vuursrrzf' then '14-Binance Staking'

when a.voter ='cosmosvaloper132juzk0gdmwuxvx4phug7m3ymyatxlh9734g4w' then '15-P2P.ORG - P2P Validator'

when a.voter ='cosmosvaloper15urq2dtp9qce4fyc85m6upwm9xul3049e02707' then '16-Chorus One'