今日はじめてコメントが入ったゲーム一覧の実行結果

SQLの説明

検索結果

実行したSQL

      SELECT '<a href="game.php?game=' || g.id || '">' || g.gamename || '</a>' AS "今日はじめてコメントが入ったゲーム一覧" FROM ( SELECT game FROM userreview GROUP BY game HAVING COUNT(*) = 1 ) AS tmp1 , ( SELECT game FROM userreview WHERE tourokubi::date = current_date GROUP BY game HAVING COUNT(*) = 1 ) AS tmp2 , gamelist g WHERE tmp1.game = tmp2.game AND tmp2.game = g.id ;