Find contest results by precinct

Custom SQL query (hide)

SELECT precincts.precinct, candidates.name, results.total
FROM results
JOIN candidates ON results.candidate_id = candidates.id
JOIN precincts ON results.precinct_id = precincts.precinct
WHERE results.contest_id = :contest_id;

Query parameters

contest_id

Edit SQL