select A.answer, COUNT(V.answer_id) as 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 = 4 and A.id = V.answer_id group by A.answer