SELECT g.* , MAX(s.score_game) as highscore FROM nuke_bbgames g left join nuke_bbscores s on g.game_id = s.game_id WHERE g.game_id = 721 GROUP BY g.game_id,g.game_highscore Line : 147 File : /home/xamrex1/domains/gierki-online.xorg.pl/public_html/modules/Forums/games.php