SELECT *
FROM
(
	SELECT user_id, id as ballotOptionId, vote FROM (
		SELECT vote.user_id, mbo.id, vote.vote FROM long_beach_clicker_vote vote
		join lb_clicker_upload_ballot_option bo on bo.id = vote.lb_clicker_upload_ballot_option_id
		join cdp_manual_ballot_option mbo on mbo.long_beach_clicker_upload_ballot_option = bo.id
	union all
		SELECT vote.user_id, bo.id, vote.vote FROM cdpaccess.cdp_manual_pch_vote vote
		join cdp_manual_ballot_option bo on bo.id = vote.manual_ballot_option_id	
	) res
	GROUP BY res.user_id, res.id
) votes
join cdp_manual_ballot_option bo on bo.id = votes.ballotOptionId
join cdp_manual_ballot_option_in_group bog on bog.id = bo.ballot_option_in_group_id
join cdp_manual_pch_ballot ballot on ballot.id = bo.manual_pch_ballot_id and ballot.hearing_phase = 'pch1'