SQL Query Error (SELECT cheat_comment.*, users.name AS user_name, concat(substr(cheat_comment.content, 1, 100), case when length(cheat_comment.content) > 100 then '...' else '' end) as content_short, gt.title AS game_name, game.link_friendly_name AS game_link_friendly_name, platform.short_name AS platform_short_name, platform.short_name_big AS platform_short_name_big, cheat.title AS cheat_title, status.name AS status_name, cheat.ref_game, (select ref_vote_variant from votes where ref_user = cheat_comment.ref_user and ref_cheat = 42501) as vote_variant FROM cheat_comments AS cheat_comment LEFT OUTER JOIN users AS users ON cheat_comment.ref_user = users.id INNER JOIN cheat_comment_status AS status ON cheat_comment.ref_status = status.id INNER JOIN cheats AS cheat ON cheat_comment.ref_cheat = cheat.id INNER JOIN games AS game ON cheat.ref_game = game.id INNER JOIN game_titles as gt on (gt.ref_game = game.id and gt.is_primary = 1) INNER JOIN platforms AS platform ON game.ref_platform = platform.id WHERE 1=1 AND cheat_comment.ref_cheat = '42501' ORDER BY creation ASC) : Subquery returns more than 1 row