SELECT DISTINCT a.VALIDATOR AS validator_a, b.VALIDATOR AS validator_b, a.PROPOSAL_ID, a.VOTE AS vote_a, b.VOTE AS vote_b, a.CREATED_AT AS created_at_a, b.CREATED_AT AS created_at_b
FROM osmosis.core.fact_governance_validator_votes a
JOIN osmosis.core.fact_governance_validator_votes b ON a.PROPOSAL_ID = b.PROPOSAL_ID AND a.VALIDATOR < b.VALIDATOR AND a.CREATED_AT < b.CREATED_AT
WHERE a.VOTE != b.VOTE
and
(a.VALIDATOR ='{{validator_1}}'
or a.VALIDATOR ='{{validator_2}}'
or a.VALIDATOR ='{{validator_3}}')
AND a.CREATED_AT >= '{{start_date}}'
AND a.CREATED_AT <= '{{end_date}}'
and (b.VALIDATOR ='{{validator_1}}'
or b.VALIDATOR ='{{validator_2}}'
or b.VALIDATOR ='{{validator_3}}')
AND b.CREATED_AT >= '{{start_date}}'
AND b.CREATED_AT <= '{{end_date}}'
ORDER BY a.PROPOSAL_ID ASC, a.VALIDATOR ASC