Incorrect totals for /candidates/totals for some candidates

[lbeaufort]

Incorrect totals for /candidates/totals for some candidates, impacting raising/spending dropdowns.

Look at Doug Jones, Luther Strange, Roy Moore, Karen Hendel, Greg Gianaforte

cc: @AmyKort @patphongs

Data tracking in progress https://docs.google.com/spreadsheets/d/1NUlhWZ6aHvNNSugPk3BWemDQSZn3pimjbqW_4IC_cnw/edit#gid=1784243483

Example: Doug Jones, Raised

Total raised	Total Receipts (from candidate page)
$46,956,378.00	$23,478,189.00

Incorrect totals in API call:
https://api.open.fec.gov/v1/candidates/totals/?api_key=DEMO_KEY&per_page=20&page=1&candidate_id=S0AL00156&cycle=2018

• Resource is TotalsCandidateView
• MV is ofec_candidate_totals_with_0s_mv which relies on ofec_candidate_totals_mv
• ofec_candidate_totals_mv has incorrect totals for Doug Jones (S0AL00156)
• The problem is with the join on ofec_cand_cmte_linkage_mv - off-year special election candidates will have two entries for 2018 in there.

cand_id	cand_election_yr	fec_election_yr	cmte_id	cmte_tp	cmte_dsgn
S0AL00156	2018	2018	C00640623	S	P
S0AL00156	2017	2018	C00640623	S	P

Impacted areas:

• https://www.fec.gov/data/candidates/senate/
• https://www.fec.gov/data/candidates/house/
• https://www.fec.gov/data/raising/
• https://www.fec.gov/data/spending
• Top raising candidates here: https://www.fec.gov/data/