select

event_attributes:validator::string as veloper

, vp_address as valcons

, min(block_id) as first_block

, max(block_id) as last_block

from terra.transitions t

left join terra.validator_labels v on (t.event_attributes:validator::string = v.operator_address)

where event = 'rewards'

and block_timestamp > getdate() - interval '6 months'

and event_attributes:validator::string in (select

operator_address

from terra.validator_labels

where vp_address is null)

group by t.event_attributes:validator::string, v.vp_address