投票の多い順にコメントを並べました。
SELECT ut.uid, '<A href=http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/login_touhyo_comment.php?uid='||uid||'&game_id='||ut.game||'>'||g.gamename||'</a>',COUNT(game) FROM userreview_touhyou AS ut, gamelist AS g WHERE ut.game=g.id GROUP BY game, ut.uid, g.gamename ORDER BY COUNT(game) DESC LIMIT 200