SELECT user.user_login, user.user_id, user.user_profile_name FROM USER, vote WHERE user.user_id = vote.user_voter_id AND vote.vote_direction = 1 /* or -1 for negative votes */ AND vote.target_type = 'comment' AND vote.target_id = 136943 /* comment id */