SELECT A.answer, COUNT( V.answer_id ) AS votes, ******* AS total_votes
FROM poll_answers A
LEFT JOIN poll_votes V ON A.poll_id = V.poll_id
AND A.id = V.answer_id
WHERE A.poll_id = 42
AND A.id = V.answer_id
GROUP BY A.answer