SELECT vote.target_id AS comment_id, user.user_login, vote.vote_direction 
FROM user, vote
WHERE user.user_id = vote.user_voter_id
AND
vote.target_type = 'comment'
AND
vote.target_id = 136968 /* comment id */