granadohoOrion Money vs Flipside Voting Records
    Updated 2022-01-19
    select
    t.proposal_id,
    t.option as orion_money_vote_option,
    s.option as flipside_vote_option,
    t.voting_power as orion_money_voting_power,
    s.voting_power as flipside_voting_power
    from terra.gov_vote as t
    INNER JOIN terra.gov_vote as s
    ON t.proposal_id = s.proposal_id
    where s.voter_address_label = 'flipside' and t.voter_address_label = 'Orion.Money'
    and t.tx_status = 'SUCCEEDED' and s.tx_status = 'SUCCEEDED'
    and (s.option != t.option)

    Run a query to Download Data