Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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'
Add Comment
Please, Sign In to add comment