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' |