SHOW:
|
|
- or go back to the newest paste.
1 | SELECT * | |
2 | FROM | |
3 | ( | |
4 | SELECT user_id, id as ballotOptionId, vote FROM ( | |
5 | SELECT vote.user_id, mbo.id, vote.vote FROM long_beach_clicker_vote vote | |
6 | join lb_clicker_upload_ballot_option bo on bo.id = vote.lb_clicker_upload_ballot_option_id | |
7 | join cdp_manual_ballot_option mbo on mbo.long_beach_clicker_upload_ballot_option = bo.id | |
8 | union all | |
9 | SELECT vote.user_id, bo.id, vote.vote FROM cdpaccess.cdp_manual_pch_vote vote | |
10 | join cdp_manual_ballot_option bo on bo.id = vote.manual_ballot_option_id | |
11 | ) res | |
12 | GROUP BY res.user_id, res.id | |
13 | ) votes | |
14 | join cdp_manual_ballot_option bo on bo.id = votes.ballotOptionId | |
15 | join cdp_manual_ballot_option_in_group bog on bog.id = bo.ballot_option_in_group_id | |
16 | join cdp_manual_pch_ballot ballot on ballot.id = bo.manual_pch_ballot_id and ballot.hearing_phase = 'pch1' |