SELECT o.poll_option_text Candidate, COUNT(v.id) votes
FROM oc_polls_options o LEFT JOIN oc_polls_votes v ON (v.poll_id = o.poll_id AND v.vote_option_id = o.id)
WHERE o.poll_id = 2
GROUP BY poll_option_text